- MuhammadAsked on September 14, 2011 at 01:47 AM
i have two stores who are competing in sales i want them to enter information and submit it on the jot form and i want it to auto calculate the sales between the 2 stores!
- allanftdAnswered on September 14, 2011 at 02:46 AM
This is partially possible with JotForm. You must introduce a field that the users will select to choose their team (i.e. a drop down box with "Team A" and "Team B" as options) like this sample form I made - http://form.jotform.com/allanftd/12562543417. Then generate a report using the Visual Report Builder. Please follow these steps:
a. In the form list, select the form that you want to generate a report for
b. Click the Reports button in the toolbar
c. Select Visual Report Builder
d. Click Next
Note however that the pie graph will only show the number of sales or transactions made by each team, not the actual amount of sales in Dollars (or whichever is your currency). You have to download the submissions into an Excel file by following this tutorial:
in order to manually compute for total sales using Excel formulas.
Please let us know if you have any other questions or concerns. Thank you for using JotForm!