Hi Guys!
Need your help!
I have used the UNIQUEID() formula for my key columns in appsheet.
So where a key column of X table is being used as ref in Y table, at few instances it has generated a scientific value. Because of which linking between the table for few entries is not working properly.
I need help with 2 things:
How do i prevent it from happening in the future?
What can I do to correct the previous mistakes?
There are many posts on this issue in the community. Please check one such below.
Solved: Item ID interpreted as number in scientific e nota… - Google Cloud Community
Thanks Suvrutt. I didn’t know about this. Now I will have to change this one by one.
You are welcome.
If there are say 20-25 such key values, you could do it manually.
If there are 100s of key and if you are confident of working with backend Google sheet, you could try using say SUBSTITUTE() formula to replace an occurrence of E in key with say B or any other letter or digit.
Please evaluate if the following helps you. But if it is a parent table etc. mass manual key generation may not help much as you will also need to change wherever the key is referenced in child tables.
Manually generate UNIQUEID() key values - AppSheet Help
Please exercise due caution in all the steps considering your app design. We, from the community may not be of much help for any broken references etc. We are just suggesting some possible options.
I understand. Thank you Suvrutt! Got myself into it so will have to figure a way out!
You are welcome.