Hello, I hope this is an easy one. I have the following custom display and would like to know how to add. Please take a look.
[if 172 equals="Sale"]
[if 124 equals="Paid"]
<div class=”top_w”><a href=”[detaillink]“>[quote_title]</a></div>
<div class=”bot_w”><p style=”font-size: 16px;”><em>$[quote_commission_total]</em></p></div>
[/if 124]
[/if 172]
[quote_commission_total] is the commission from the entry. How do I add [quote_commission_total] to all of the entries in this list? Is it possible to select a date range also? I am capturing a date on the form.
Thank you in advance for your help!
October 9, 2012 at 10:18 am
You can use the frm-stats shortcode to total the values in a field.
http://formidablepro.com/knowledgebase/add-field-totals-and-statistics/
If there are only certain entries you'd like to include, it gets more complicated. It might be easiest to add some javascript to do the calculation in your custom display.
You can show a certain date range by using an advanced search form. Here are more instructions:
http://formidablepro.com/knowledgebase/advanced-search-forms/
October 29, 2012 at 4:56 pm
Thank you for answering this question. I do have a specific question about a custom search.
If my custom search form is only a date range (from_date, to_date) how would I get started in writing a custom url redirect?
Thank you.
October 29, 2012 at 7:17 pm
The URL you redirect to will look something like this:
[siteurl]/page-with-results/?sdate=[126 format='Y-m-d']&edate=[127 format='Y-m-d']
sdate = start date
edate = end date
Now that you have a form that redirects to the results page, you will need to add the where options into the custom display. You will need to add two where rows:
Date field is greater than [get param=sdate]
Date field is less than [get param=edate]
Topic closed.