I am using an ID col as the Key, and the ref is the first name col, but then on the referenced sheets instead of first name in that col i get the ID. Should the ID columns be the reference AND the key?

Did anyone get a straight answer for this? its very frustrating and makes no sense to me. My google sheets now display unique IDs instead of the company name which is the label. so when I go to analyse the data within something like Google Data Studio I get no useful information as its all letters a…

Mike_Venner: i really don’t see why I cant have the label displayed back in my spreadsheet as opposed to the unique ID. Why not use the label column as your key column? There are good reasons not to, but if it bugs you so much and you aren’t able to work with separate key and label columns, you …

Everyone says you should have a separate column for the unique IDs so that’s what i done. I have a unique ID and a column for company name as well as a load of other columns. the company name is the label and the unique ID column is the key. it all works fine in the app but the google sheet displays…

You could just add another column to your sheet for the name if you really need it and hide the one you dont need in the app.

There are things in the appsheet that generate rework. For example, in a table where there is an ID column “uniqueid ()”, and a Name column “Ref”. Where the “Ref” column refers to another table whose Name is defined as type “Name” and marked as LABEL, why not automatically transfer it to the spreads…

DiegoSoares: why not automatically transfer it to the spreadsheet in the correct way? It is transferring it the correct way, you just aren’t understanding the system correctly.

Marc, I understand that within the “programming logic” and databases, this can be on the right way. But we must remember that the AppSheet is a “No-Code” platform, in which it was proposed to “facilitate” the creation of Apps, both for more experienced users, as well as more lay users, like me. And …

Just because some low/no-code platform is meant to be easier than typical coding development does not mean that anyone can just walk in with zero knowledge and build a complex app. There will always be knowledge barriers. Just like with using any other software. Yes, you are correct, the issue with…

Ok Marc. To conclude this healthy “discussion”, just as you were a layman, and I am, please explain to me, why should it be the way it is, for me to accept and adapt to it? If you want to answer, of course.

I am using an ID col as the Key, and the ref ...

AppSheet AppSheet Q&A

anonymous8 May 7, 2021, 6:28pm 35

Thank you steve. I will do this reading.

Topic		Replies	Views
Using id as key. With ref. that id gets back to sheet. Don´t want that! Getaround? AppSheet Q&A expressions	9	39	November 19, 2023
Ref column names AppSheet Q&A expressions	2	26	December 24, 2019
KEY and Label Confusion AppSheet Q&A expressions	6	32	May 31, 2020

I am using an ID col as the Key, and the ref ...

AI Suggested topics