Can I split Text from Google Spreadsheeet while remain the text in the form the same ?

  • Hangchanleakna
    Asked on July 5, 2018 at 3:10 AM

    hi , i create a box with ID and Name in only one box in jotform , and i received in google spreadsheet is ID and name in one column. i can split the ID and name into 2 columns in  spreadsheet .  but in jotform i want to remain with only a box the same in jotform. 
    is it possible to keep it the same in jot form and split from 1 column to 2 column in spreadsheet ? is the next update will be refreshed and link each other ? 

  • Nik_C
    Replied on July 5, 2018 at 6:42 AM

    It should be possible but it's not good to modify the integrated spreadsheet since it could break the integration.

    If you still want to try, you can split columns in Spreadsheet by following this guide: http://smallbusiness.chron.com/split-columns-google-docs-spreadsheet-53906.html

    If it works, you could import the whole sheet into another sheet and do the split there: https://support.google.com/docs/answer/3093340?hl=en

    If you need any further assistance, please let us know.

    Thank you!

  • Hangchanleakna
    Replied on July 6, 2018 at 6:25 AM

    HI , 


    THANKS YOU SO MUCH . BUT I WON'T TRY THIS WAY. MAYBE JUST LEAVE IT THERE. 
    tHANKS YOU SO MUCH. YOU'RE AWESOME.