Date/Time field conditional logic makes it possible to show or hide fields or sections of fields. One use case for this feature is providing ‘Early bird’ pricing (allowing customers to sign up for an event at a lower price during a specific time prior to the established registration time) on a registration form.
We’ll start by adding a number field that will display the Early Bird registration price during a specific date range. Make the field read-only, set it to display two decimal places, and choose your currency. Set the 'Default Value' to your Early Bird price.
Next, add a number field that will display the Regular registration price after the Early Bird pricing window is over. Format the field the same way as the Early Bird price field. Set the 'Default Value' to your Regular registration price.
Optionally, if the registrant can register multiple people, add a number or dropdown list field so the registrant can choose how many people he or she wants to register.
Now, add a number field that will calculate the total of the Early Bird and Regular prices and (optionally) the quantity chosen. Format the field the same way as the registration price fields.
Click the ‘Use Numeric Calculation’ link below the ‘Default Value’ setting within the number field’s settings and set up the calculation to add the Early Bird and Regular price fields together. If you have a quantity field, you’ll need to add parentheses around the price fields and multiply them by the quantity field.
Now that you have the calculation up and running, add a Date/Time field to your form. This will be used to control the field logic on your price fields. Set the field to be ‘Hidden’, the Time Format to 'None', and set the Default Value to ‘Current Date/Time’. This will fill in the field with the current date and time when the form is loaded.
Finally, add Date field logic to your price fields. Click on the Early Bird price field, then click the ‘Logic’ button. Choose the Date/Time field from the field list, choose ‘is between’ and then set the date range you’d like the Early Bird Pricing window to be. In this example, my window is between November 1, 2017 and November 18, 2017.
Next, click the Regular price field, then click the ‘Logic’ button. Choose the Date/Time field from the field list, choose ‘is after and then set the date as the last day of the Early Bird pricing window. In this example, I’ve set the field to show after November 18, 2017.
When done correctly, the Early Bird Pricing field will display on the field when someone visits the form between June 1, 2019 and July 31, 2019 and it will be the price that is calculated in the Total field. After July 31. 2019, then the Regular price will display and the Early Bird price will hide allowing the new pricing to be used in the calculation.