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

    Is it possible to reference a Google Spreadsheet in conditional statements

    Asked by astagliano on December 10, 2015 at 11:24 AM

    I created a google sheets spreadsheet through jotform, 2016 Certificate of Attendance and a request form.

    This is what I'm trying to do.

    There will be a list of names and email addresses on the google spreadsheet. (right now only my name appears.) A member will complete the form and if their email address appears on the spreadsheet it should forward a certificate to their email with their first name and last name on it.

     

    I'm not sure how to tie the condition to the google sheets to activate the certificate.

    Can you help?

     

    Priscilla

     

    Page URL:
    https://form.jotform.com/53434794819973

    Than JotForm name first name Activate
  • Profile Image
    JotForm Support

    Answered by david on December 10, 2015 at 12:13 PM

    Hi,

    Unfortunately, it is not possible to reference external documents in your conditions.  The only integration the form has with the spreadsheet is forwarding collecting data to the sheet.  The form cannot access the sheet to reference in conditions.

    If you need conditions based on names, you would need to set up a specific condition for each name.