Pre-Filled information for Consent Form

  • Dave G
    Asked on March 26, 2019 at 11:08 PM

    We manage buildings and need to provide tenants with a notice to enter for maintenance work, even if the work is requested.  I want to have all of the information pre-filled in the form and simply have the tenant approve the request with a signature.  

    The information I will need populated in individual fields includes: building name, tenant name, unit #, maintenance requested, date and time of entry, etc.  

    I want to give only one option and that is to approve the entry or not.  

    Secondarily, I would like all form data to export/save to a google sheet.

    I don't know how to do any of this and would appreciate some advice.  Thank you.

  • Nik_C
    Replied on March 27, 2019 at 3:03 AM

    The information I will need populated in individual fields includes: building name, tenant name, unit #, maintenance requested, date and time of entry, etc.  

    You can add all the necessary fields by using our basic fields:

    1553669598Screen Shot 2019 03 27 at 7 Screenshot 10

    Where your "date and time of entry" you can set with a Date field, and the rest of the data you could collect with Short Text Entry field.

    Regarding Approve and Deny, I assume you would do this once they submit the form, so the option shouldn't be visible for the submitter?

    If that's the case, you could insert a Single choice button:

    1553669814Screen Shot 2019 03 27 at 7 Screenshot 21

    And hide it:

    1553669971Screen Shot 2019 03 27 at 7 Screenshot 32

    When the form is submitted, you can edit the submission and set that field to what is needed:

    https://www.jotform.com/help/325-How-to-Edit-Submissions-Made-on-Your-Forms

    And here is how you can integrate the form with Spreadsheet: https://www.jotform.com/help/228-How-to-Integrate-Forms-with-Google-Sheets

    Let us know if you have any further questions.

    Thank you!