Can I use part of the Name field in Update/Calculate Field Value Condition

  • Profile Image
    Asked on October 16, 2015 at 12:23 AM


    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?



  • Profile Image
    Answered on October 16, 2015 at 05: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.

  • Profile Image
    Answered 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: 

    Let us know if we can assist you further.