Automatic append data from an external source into Jotform/widget via a hyperlink

  • oconnorservices
    Asked on February 1, 2021 at 9:21 PM

    I am using Zoho helpdesk for my task list. I would like to be able to click on a hyperlink that will automatically fill a field/widget in Jotform. the field is the 'spreadsheet to form' widget

    Is this possible?




  • oconnorservices
    Replied on February 1, 2021 at 10:09 PM

    If this is not possible can you also give me some of the fields to prepopulate. I can then do the rest (sorry I could not get it to work) https://www.jotform.com/help/71-prepopulating-fields-to-your-jotform-via-url-parameters

    eg: Fields 'Work Order', 'FREQ', 'Operation Description'


    Thanks heaps


  • Mike_G JotForm Support
    Replied on February 2, 2021 at 2:08 AM

    We would like to apologize for any inconvenience. I'm afraid that it is not possible to prepopulate the Spreadsheet to Form widget via URL parameters directly.

    A workaround would be is to prepopulate a Short Text field via URL parameters and pass its value into the Spreadsheet to Form widget conditionally.

    1612249640 6018fa2881521 zt210202 020630 Screenshot 10

    How-to-Insert-Text-or-Mathematical-Calculation-into-a-field-using-a-Condition

    Please give it a try and let us know if you need any further assistance.