-
EvanWaltonAsked on January 13, 2020 at 7: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
Page URL: https://form.jotform.com/200127135043035 -
Kiran Support Team LeadReplied on January 14, 2020 at 3: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.
-
EvanWaltonReplied 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."
-
BJoannaReplied on January 14, 2020 at 1: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:
Google Sheets header:
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.
-
EvanWaltonReplied on January 14, 2020 at 5:50 PMThat is perfect, thank you!!
...