Comma issue when saving Table data into GoogleSheet
Hi Frevvo support team,
We are developing a form with table control. The table data will be saved in Googlesheet once the form has been submitted. We noticed that the delimiter is ',' for table data. For example, we have a table :
And the Deliverable Name would be saved in one column in GoogleSheet as
However, it is possible for us to have a comma inside of one Deliverable Name. So we have problem of saving Deliverable name with comma due to the delimiter is comma as well. For example, we have a table like:
And the data saved in GoogleSheet cell is as
In this scenario, we are not able to identify the exact number of Deliverable names have been entered, and we are not able to identify the exact content of each Deliverable name.
Could you please help with this scenario?
Please let me know if you have any confusions.
Kind Regard,
Maxine
Please sign in to leave a comment.
Comments
0 comments