Posting number to a sheet as a string cuts/eliminates any leading zeros
I am using randomly generated numbers in a google sheet to create customer/user IDs to track things. My script creates random 10 digit numbers- and it works great BUT when the number in the sheet has leading zeros, and I pull that into typebot, typebot gets it with the leading zero- then when I put it BACK in the sheet, the leading zeros get cut off by default. So it seems typebot will GET as a string but POST to the sheet as a number maybe... (or the sheet interprets it as a number...)
Then when I try to find the value in the sheet to modify row values, it is searching with the identifier with the leading zeros but in the sheet the number doesn't have leading zeros so it never finds the row. I am going to limit my range to only leave non zeros as the first number (start at 1000000000) for the range, but I still think this is kind of a bug. Not sure it needs to be addressed, but maybe an option to get the data as a string or get it is a number. What do you think Baptiste? Not a big deal if this is not a priority. Just found it and wanted to report it.
1 Reply
I guess I mean an option to POST to the sheet as a string or a number. I don't know if the issue is how the sheet column is formatted maybe that would fix it...