Additional column for money due

  • benhassenger
    Asked on February 18, 2016 at 6: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)
    Discount: -30.00
    Total: 460.00
    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. 

    Thank you!

  • beril JotForm UI Developer
    Replied on February 18, 2016 at 11:17 AM

    You can add additional column with hidden field.

    Additional column for money due Image 1 Screenshot 30

    It will add $ sign automatically on your Google Spreadsheets Integration.

    Here is how it works:

    Additional column for money due Image 2 Screenshot 41

    If you have any question or issues, please do not hesitate contacting us. We will be glad to assist you.