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

  • Profile Image
    Hangchanleakna
    Asked on July 05, 2018 at 03: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 ? 

  • Profile Image
    Nik_C
    Answered on July 05, 2018 at 06: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!

  • Profile Image
    Hangchanleakna
    Answered on July 06, 2018 at 06: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.