Looking to set question names so they don't change when questions change

  • Profile Image
    EvanWalton
    Asked on January 13, 2020 at 07:05 PM

    Hey y'all! Thanks for the awesome service - I recorded a quick video for you going over what I'm trying to do, hopefully it is an easy fix that I'm simply missing. I've tried a couple of the support articles but can't seem to find it.

    https://drive.google.com/open?id=1asIGrHVLPe8_M5jPdZXgGhfvWv1DpDBS

    Can't wait! Thanks in advance. 

    Ev

  • Profile Image
    Kiran
    Answered on January 14, 2020 at 03:07 AM

    I understand that you want to integrate Jotform to a Google Sheets using Zapier by mapping specific fields. Please note that there is a direct integration to Google Sheets is available with JotForm.

    https://www.jotform.com/help/228-How-to-Integrate-Forms-with-Google-Sheets

    However, please note that the field names on the form can only be used to send the data to Google Sheets header. 

    Also, when connecting to a Google sheet in your Drive using Zapier, the same fields on the form shall be used/displayed in the field mapping.

    Hope this information helps! Please give it a try and let us know if you need any further assistance. We will be happy to help. 

  • Profile Image
    EvanWalton
    Answered on January 14, 2020 at 12:24 PM

    Hi Kiran, thank you so much for the help. Can you please explain these two paragraphs further? I'm not sure I understand. 


    "However, please note that the field names on the form can only be used to send the data to Google Sheets header. 

    Also, when connecting to a Google sheet in your Drive using Zapier, the same fields on the form shall be used/displayed in the field mapping."

  • Profile Image
    BJoanna
    Answered on January 14, 2020 at 01:51 PM

    What you are trying to achieve is not possible. Only the field Lable can be used to send the data to Google Sheet. 

    Lable:

    1579026694lable.PNG

    Google Sheets header:

    1579026757sheet.PNG

    If you edit the field label the integration will break. 

    However, as a workaround, you can hide the original label with CSS and add a custom one with CSS. This will allow you to update the label that is visible for your users and keep the original to not break the integration. 

    Here is a demo form - https://form.jotform.com/200135749312044 

    On my demo form, the original label is Test. I hide it with this CSS code:

    #label_4 {

        visibility : hidden;

    }

    Then I added a custom label with this CSS code:

    #label_4:after {

        content : "Date 01/20";

        visibility:visible!important;

    }

    As you can see only "Date 01/20" is shown on the form. I can now edit the CSS code to update the field label that is visible to the user by editing the content : "Date 01/20"; of the CSS code. 

    How to Inject Custom CSS Codes

    Feel free to clone my form. 

  • Profile Image
    EvanWalton
    Answered on January 14, 2020 at 05:50 PM
    That is perfect, thank you!!
    ...