Zapof

How to Create a Registration Form with
Early Bird Discount

 

Seminar date:

Friday, April 11, 2025 at 1:30 AM PDT

Please choose the session you want to attend.

Marketing Seminar Session

Attending

Fee

A
B
C
1
Social Media Marketing (morning session)
$400.00
2
Email Marketing (afternoon session)
$400.00
3
 
Subtotal:
$0.00
4
Note: We apply Early Bird discount of 20% if you register and pay the amount at least 30 days before the seminar date.
Discount:
$0.00
5
 
Total:
$0.00

Number of days before the seminar date:
Note: to calculate the days before the seminar date,
we use a formula:

QUESTION1 - TODAY()

59.354166667
 
 

Instructions:

  1. Add a single-line text input field with a formula to show the seminar's date. E.g.:
    DATETIME(2025, 07, 21, 8, 30, 0)

    Note: to make this sample form always calculate early bird discount correctly, we move the seminar's date 2 months in the future by using a formula:
    DATETIME(YEAR(TODAY()), MONTH(TODAY()) + 2, DAY(TODAY()), 8, 30, 0)

  2. Add a table with 3 columns; seminar description column with Text data type, Attending column with Checkbox data type, and Fee column with Currency data type.

  3. Enter the subtotal formula on C3:
    B1*C1 + B2*C2

  4. Enter the early bird discount on C4:
    IF ( DAYS( QUESTION1, TODAY()) >= 30, -0.2 * (B1*C1 + B2*C2), 0)

    Note: if you prefer to show $0.00 when none is selected, use a formula:
    IF ( DAYS( QUESTION1, TODAY()) >= 30, IF((B1*C1 + B2*C2) = 0, 0, -0.2 * (B1*C1 + B2*C2)), 0)

  5. Enter the total formula on C5:
    C3+C4


 

To configure an element, select it on the form.

To add a new question or element, click the Question & Element button in the vertical toolbar on the left.