Hi, when referencing tables my google sheet turns unreadable, because instead of client name I see the client Id.
Iโm attaching an Image of how my sheet look with my original data, and how appsheet changes the client name for the Iโd.
Is there a way to keep the sheet readable?
Thanks!
Hi Gaston. How are you referencing these other tables? Are you using ref columns in this case: https://help.appsheet.com/en/articles/961426-references-between-tables?
Hi,
Yes, tables are using ref type.
This is my map.
What I need is the spreadsheet to be readable. For example, after I reference by ID, instead of โJohnโ in โEjecutivoโ column, I see the ID, so when someone else get into the spreadsheet they see 45EEHCC instead of John. I think this is not possible because itยดs the ID whats linking one table to another, right?
Should I build some lookups for the spreadsheet to read the correct data?
Thanks
Use the client name as the key column.
Oh! Ok!
I read so much about recomendations on generating IDs that I was always around that.
Using each item as the ID solve the problem
User | Count |
---|---|
39 | |
32 | |
30 | |
16 | |
14 |