Need help getting a total of the number of reservations

  • Profile Image
    AngelaBuck
    Asked on December 10, 2020 at 10:28 AM

    Hi there- I am using a form to collect reservations and need help getting a total of the number of reservations not just the number of submissions. (i.e 1 person/submission can request 10 reservations) how do i do that?

  • Profile Image
    Richie
    Answered on December 10, 2020 at 11:35 AM

    To clarify, do you want to total the number of reservations booked already?

    Or do you have a limit on the number of reservations the users can submit?

    If you want to total all the reservation fields in your submission, you can download the data as excel and manually create a formula to calculate the total entries.

    Guide:https://www.jotform.com/help/73-how-to-download-form-submissions-as-excel-csv-pdf




  • Profile Image
    Alex_Geezy
    Answered on December 10, 2020 at 01:50 PM

    Hi, AngelaBuck!

    Richie_P is right. If you want to count total number of reservations you need to export data to Excel and create a formula.

    First step:

    Export your data to Excel or Google sheets. Guide was already provided by Richie_P above. Or use Zapier (You can read more about this variant in Jotform's blog).

    Second step:

    Select your "Reservations" column and find AutoSum button in Excel.

    Finally you should have a SUMM formula. It will count all reservations from all submissions.

    1607626019_5fd26d235db26_a558fff2d51c37a

    Hope it helps.

    Have a nice day!

  • Profile Image
    Elton
    Answered on December 10, 2020 at 04:47 PM

    In addition to my colleagues, it's also possible to get the total within your Tables (submissions page).

    Here's how:

    1. While in the Tables, click the Number of tickets column
    2. Click Add Summary then select Sum

    12112020_xSYkdzhPky.gif