Zapof Forms
with Spreadsheet and Built-In Formulas

Are you looking for an online form that not only collects data but also manipulates and calculates data?

The benefit of the spreadsheet to businesses is fairly obvious, spreadsheet allows you to enter data and formulas into its cells and the spreadsheet does the calculation for you. We use a spreadsheet for an array of tasks, from basic administrative tasks to complex statistical and financial analysis.

Often, we need an online form with spreadsheet capability so that it is easier and quicker for the users to fill in the form. The spreadsheet helps the users auto-calculate values such as discounts, subtotals, payment total, the sum of values.

Zapof form provides the spreadsheet with hundreds of built-in formulas in financial, statistic, engineering, text, date, logical and general categories. Our spreadsheet offers innumerable ways to assist your customers in completing the form. You can combine it with online payment to provide a convenient way for your customers to pay for your products and services.

The following conference registration form has a facility to pay conference fee using credit/debit card or PayPal. Conference fee depends on the number of topics the user selects. The user only needs to choose the topics, and the spreadsheet auto-calculates the fee, including the applicable discounts. Our online forms also allow you to include user’s answers in the formula calculation. In this sample form, the user can choose to attend the conference networking dinner and our online form auto-calculates the total fee accordingly.

Conference Registration Form


Name:
Title
First
Last

Position: 
Email:

Phone:
Mobile:

Company:

Address: 

City:
State:

Zip Code: 
Country:

Topic Selection:
Topic Title
Attend?
Date & Time
Fee
Topic A
12/4/2017, 10:00 AM
$200.00
Topic B
12/4/2017, 1:00 PM
$200.00
Topic C
12/4/2017, 3:00 PM
$200.00
Topic D
12/5/2017, 10:00 AM
$200.00
Topic E
12/5/2017, 1:00 PM
$200.00
 
 
 
 
Each topic costs $200. You get discount of $10 x number of topics when you select more than 1 topic. E.g. if you select 5 topics, each topic costs $200 - $10x5 = $150
 
Total $
$0.00


Join our conference networking dinner after the conference, starting at 6pm. It’s an opportunity to kick back and mingle with other conference attendees. You can also bring along your colleagues or friends to attend this great event. 

The cost of the dinner is $120 per person.

Yes, I’d like to join the conference networking dinner.

Number of additional diner (leave empty if it’s just you): 


Total Conference Fee:
$0.00


Total Conference Fee:$0.00
Total$0.00


The above form is copied from our template collection: Conference Registration Form.