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

  • Profile Image
    oconnorservices
    Asked on February 01, 2021 at 09: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?




    Page URL:
    202957761797877

  • Profile Image
    oconnorservices
    Answered on February 01, 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


  • Profile Image
    Mike_G
    Answered on February 02, 2021 at 02: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

    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.