- benhassengerAsked on February 18, 2016 at 06:23 AM
The Excel spreadsheet generated by Jot Form for my musical camp has a column that states what tuition option the attendee is signing up for, it looks like this:
All-Inclusive Double Occupancy (Amount: 490.00 USD)
Coupon used: MUC30
Is there a way to generate an additional column that shows only the dollar amount due ($460 in this example) without any other text? That would make it easy to sum the total amount of money due so we can reconcile it with our Pay Pal payments.
- JotForm UI DeveloperberilAnswered on February 18, 2016 at 11:17 AM
You can add additional column with hidden field.
It will add $ sign automatically on your Google Spreadsheets Integration.
Here is how it works:
If you have any question or issues, please do not hesitate contacting us. We will be glad to assist you.