dropdown populates a text field but creates multiple instances in spreadsheet

  • Profile Image
    promptinreports
    Asked on March 23, 2013 at 04:24 PM

    I have a form I set up to take invoicing information.

     

    After some research in your guys forum, I found I can have a drop down "populate" a following text field using conditions.  Not a perfect solution but will work for now.

    Heres my concern:

    When I integrate the form with google speadsheets, there is now a colum for every hidden feild I had to create for the condition solution to work.  The is really messy.  Is there a way that when a person it selected from the drop down and the text field with there prepopulated email is revealed for that email text field to populate just one colum in the spreadsheet?

    http://form.jotform.us/form/30806979441159

  • Profile Image
    Welvin
    Answered on March 24, 2013 at 12:17 AM

    Hi,

    Unfortunately, that is how it works. Since fields are created, that will be carried over to Google Spreadsheet result. You have to do the calculation to what they have selected before they submit the data.

    I suggest you to let them write the email address if you don't want to have a multiple result on that sheet.

    Thank you.

  • Profile Image
    promptinreports
    Answered on March 24, 2013 at 07:49 PM
    There is no work around? Or maybe a better way to do this? Essentially what I need to a form where the person selects their name the email populates in the following text field and the spreadsheet reflects one column for the name from the drop down and one column for the email populated.I appreciate any help.Thanks
  • Profile Image
    jonathan
    Answered on March 24, 2013 at 08:08 PM

    @ promptinreports

    Hi, the nearest possible workaround is to use the form's source code.

    If you can use the form's source code and have it embedded on your own website, you can have the option to inject your own script codes to manipulate the pre-population of fields base on the conditions.

    Another way will be to manipulate the data results in your google spreadsheets using filter functions from google spreadsheet.

    i.e. create another column to filter all the Email columns to collect only the one that have value into the created filter column.

    Hope this help. Inform us if you have more inquiry.

    Thanks.