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

    Can I update an existing integrated Spreadsheet?

    Asked by ollitempleuniversity on November 01, 2016 at 10:31 PM
    Also, we currently are using Jotform for event rsvps. Each rsvp must drop off or mail a check to our office. Is there a way update the excel spreadsheet with check numbers as the checks come in? Or will we have to keep a separate list? 
  • Profile Image
    JotForm Support

    Answered by Jim_R on November 01, 2016 at 10:45 PM

    When you said, "Is there a way update the excel spreadsheet with check numbers as the checks come in?"

    1. Did you mean your form is currently integrated with Google Spreadsheet?


    2. Are you using the XLS export feature from the Submissions Page?

    If it's #1, then no, we wouldn't advise that you edit the integrated Spreadsheet (specially the column titles) as this may break the current integration. It's better to just keep a separate spreadsheet file for you to track those people who dropped off or mailed a check to your office. After all, this requires something that is done outside JotForm and a manual process is required.

    If it's #2, then sure, that won't pose any problems. Still, you'd have to do it manually since the drop offs/mails are being done physically and outside JotForm.

    In case we misunderstood your question, don't hesitate to explain further so we can better assist you.