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

    URL Parameters to Prepopulate fields from different sources

    Asked by tom@tomdavidson.org on September 15, 2013 at 04:13 PM

    hello, I need a quick poll to report case activity. In this poll there will be 3-5 names of assigned cases, each with a corresponding yes/no button. The pupose is to poll which of their home visits they have made. 

    I need the case names to be qurried from a Google Spreadsheet by the respondants name (a value I intened to prepopulate via url). If the dynamic case names are to be lables of the yes/no checkbox, then I will need the lable to be available as a colum results with the corresponding checkbox (results are to be kept in a google spreadsheet).

    I have found a way to do everything with JotForm excpet the dynamic case names for the questions - can you point me in the right direction?

     

    thanks, tom

    JotForm checkbox name thanks
  • Profile Image

    Answered by Cesar on September 15, 2013 at 05:54 PM

    Hello,

    The URL Parameters can be used on fields. What you could do in this case is populate a field labeled Case Name or something that best suits your needs. Like so:

    http://form.jotform.co/form/32576474144862?caseName=John%20Doe

    Do let us know if you need further assistance. Thank you.

  • Profile Image

    Answered by tom@tomdavidson.org on September 15, 2013 at 06:21 PM
    Hello and thank you for the quick reply. So rather than try to set the
    checkbox label, just have a separate field. OK.
    What about the quantity of the fields? Each respondent has 3 to 5
    households to check in on (we might have more than five, but we currently
    do not). Each would have the household name field and the single checkbox
    field. Do I have to just use the max number?
    If we are to populate the assigned household fields from a Google
    Spreadsheet but the form will be accessed from a MailChimp Campaign and the
    recipient will be populated from the MailChimp link, how to call another
    URL to populate the household fields?
    br, tom
    Tom D. Davidson
    P.O. Box 1732, Laramie, Wyoming 82073
    tom@tomdavidson.org | ph. 307.363.2866 | fx. 303.223.0064
  • Profile Image

    Answered by Cesar on September 15, 2013 at 06:57 PM

    Hello,

    What about the quantity of the fields? Each respondent has 3 to 5
    households to check in on (we might have more than five, but we currently
    do not). Each would have the household name field and the single checkbox
    field. Do I have to just use the max number?

    Hello, you can have all fields located on the same form. If you will be prepopulating the fields it works better to have the max allowed fields already listed in your form. In any case you will only receive submission data of the fields that are filled in, empty fields do not show on your submissions. In case you need to increase the amount of fields you need you can just continue to add on to the form and append more parameters to your URL.

    If we are to populate the assigned household fields from a Google
    Spreadsheet but the form will be accessed from a MailChimp Campaign and the
    recipient will be populated from the MailChimp link, how to call another
    URL to populate the household fields?

    You are only able to use one URL fields to populate all your neccesary fields on one form. In which case you would need to crossreference your households with your recipients on a single URL. That would entail that you would need to somehow crossreference your google spreadsheet with mailchimp and from there generate the URL parameter.

     

    Hope this helps. If you need further assistance, do let us know. Thank you.

     

    This is some related information you may find usefule for your project.

    http://connect.mailchimp.com/integrations/google-docs

    https://zapier.com/zapbook/google-docs/mailchimp/