-
dbisAsked on October 16, 2015 at 12:23 AM
Hello
Can I use part of the Name field (e.g. Last or First) in the "Update/Calculate field's value" condition.
I like the combined Name field but it has restrictions e.g. you can't coax the Google Drive custom name to split it. As we already have a lot of data for our form I was wondering if I could split the name into two hidden fields using the "Update/Calculate field's value" condition and do it that way.
However I can't find the syntax to do it?
Thanks
Sheila
-
Chriistian Jotform SupportReplied on October 16, 2015 at 5:11 AM
Hi Sheila,
Unfortunately, you cannot update a field with the First name value only using Full Name field. What you can do is to just separately add two text boxes for First Name and Last Name so you can get the value for each field.
Do let us know if you need further assistance.
Regards. -
CarinaReplied on October 16, 2015 at 12:14 PM
Hi Randy
Thank you so much for providing a workaround for Sheila, but unfortunately Text fields are not sent to Google Spreadsheets.
I would instead use the text-box fields for First and Last Name and then add some custom CSS code to make it look like Full name field.
You can test and clone the demo form:
https://form.jotform.com/52884892956982?
Let us know if we can assist you further.