Thanks for the effort in explaining. Like someone else mentioned i still dont know what a label is how are they being used by the app or in expressions, keys are easy though they are like the unique ID values you get for each item in sharepoint.
Hi, Guys I do need your help. My app is not allowing me to edit the status of the order, I just realized that this is in a computed key with the block number (It is about stones). I don't know what to do. Help me out.
@@AppSheetTraining yes. But I kinda solve it, I created a column with an ID number. However I don't know how to make it generate numbers. It's always with rownumber, but it's not a good key. How can I add an ID to every entry that's not necessarily the row number?
A key would be a unique value : similar to a Social security number (in AppSheet use an initial value of UNIQUEID()) A label would be text that best describes a row: think along the lines of First/Last Name ( something human readable.) A car table would have: a UNIQUEID() as a Key Honda Civic as Label A Client table would have: a UNIQUEID() as a Key McDonald's(Company Name) as Label A Users table would have: Email as a key (only 'user tables' we suggest not using a UNIQUEID()) Full Name as Label
I've been working on referencing tables on appsheet and all the time i get it through trial and error. I know keys and labels play a role. But what you're trying to say is, When two tables of same keys, it won't allow you to reference those two tables, right?
Basically, if Table 2 has a column that stores the key value of a row in Table 1, AppSheet can visualize the relationship between those tables. Labels come into play because key values are often not easy distinguishable because they are random letters/numbers or timestamps. The label is a more recognizable field that AppSheet will show instead of the key value when showing you the table relationship
Hey Benjamin. I am desperate to learn how to create multiple user logins and have an individual password for each person. I am a contractor that sub-contracts out work to multiple contractors throughout the city. I need to collect data from them (which is recorded on google sheets) individually and its imperative I know who each person is. Could you make a video please about how a beginner in coding and app sheets like myself could create a simple login page? It would be greatly appreciated if you could. I have searched high and low across the internet for someone that covers login/username/password set up, and I havent found one (in english) that explains it slowly, methodically and technically (meaning formula set up etc). I’m reading up on how the formulas are designed but It’s taking some time for me to learn this new computer language. If I can see how to set one up through visual learning it will make a lot more sense to me. If you can help it would be greatly appreciated! Thanking you in advance, John
You need to put an actutal video in appsheet with three tables. I think most people understand keys and references, bit the way how appsheet handles it might be different from how other mainstream apps handles it.
Thanks for the suggestion. Do you mean 3 tables that have hierarchical reference? Or 2 tables that use a shared 3rd table to represent a many to many relationship between them?
Great analogy - thanks for for the content
Thanks for the effort in explaining. Like someone else mentioned i still dont know what a label is how are they being used by the app or in expressions, keys are easy though they are like the unique ID values you get for each item in sharepoint.
Thats great Thanks. Could you add a demo in the APP for clarity?
Daniel, that's a great suggestion. I'll see if we can get a link to a simple demo app added to the description soon
I want 2 entries on same date with different name & i avoid same name on single date. How can I apply formula
Take my like and sub! APPRECIATE THIS A LOOOOT!!
Hi, Guys I do need your help. My app is not allowing me to edit the status of the order, I just realized that this is in a computed key with the block number (It is about stones). I don't know what to do. Help me out.
When you go to the Table does it say 'Edits' are allowed next to Adds/Edits/deletes?
@@AppSheetTraining yes. But I kinda solve it, I created a column with an ID number. However I don't know how to make it generate numbers. It's always with rownumber, but it's not a good key. How can I add an ID to every entry that's not necessarily the row number?
Still no idea 😂😂
A key would be a unique value : similar to a Social security number (in AppSheet use an initial value of UNIQUEID())
A label would be text that best describes a row: think along the lines of First/Last Name ( something human readable.)
A car table would have:
a UNIQUEID() as a Key
Honda Civic as Label
A Client table would have:
a UNIQUEID() as a Key
McDonald's(Company Name) as Label
A Users table would have:
Email as a key (only 'user tables' we suggest not using a UNIQUEID())
Full Name as Label
I've been working on referencing tables on appsheet and all the time i get it through trial and error. I know keys and labels play a role. But what you're trying to say is,
When two tables of same keys, it won't allow you to reference those two tables, right?
Basically, if Table 2 has a column that stores the key value of a row in Table 1, AppSheet can visualize the relationship between those tables.
Labels come into play because key values are often not easy distinguishable because they are random letters/numbers or timestamps. The label is a more recognizable field that AppSheet will show instead of the key value when showing you the table relationship
Hey Benjamin. I am desperate to learn how to create multiple user logins and have an individual password for each person. I am a contractor that sub-contracts out work to multiple contractors throughout the city. I need to collect data from them (which is recorded on google sheets) individually and its imperative I know who each person is. Could you make a video please about how a beginner in coding and app sheets like myself could create a simple login page? It would be greatly appreciated if you could. I have searched high and low across the internet for someone that covers login/username/password set up, and I havent found one (in english) that explains it slowly, methodically and technically (meaning formula set up etc). I’m reading up on how the formulas are designed but It’s taking some time for me to learn this new computer language. If I can see how to set one up through visual learning it will make a lot more sense to me. If you can help it would be greatly appreciated! Thanking you in advance, John
Yes, you need to demonstrate how to set key and label in the app itself..
You need to put an actutal video in appsheet with three tables. I think most people understand keys and references, bit the way how appsheet handles it might be different from how other mainstream apps handles it.
Thanks for the suggestion. Do you mean 3 tables that have hierarchical reference? Or 2 tables that use a shared 3rd table to represent a many to many relationship between them?
Label is a more understandable/meaningful value of a key.....I guess. Similar like an ID and its description. Is my understanding correct?
That’s exactly right! It makes more sense to humans, Keys make more sense to the system
first this guy needs to properly learn to explain concepts