What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.

  • Profile Image

    Additional column for money due

    Asked by benhassenger 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)
    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!

    Page URL:

  • Profile Image
    JotForm Support

    Answered by beril 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.