I have a Studentslist table and orders table
in the "new student form "that I fill the โfirst nameโ and โlast nameโ and I have a Column "full Name " with a formula CONCATENATE([First Name], โโ, [Last Name])
in orders form, I have a ref type for column "Full Name " dropdown โ ref to full name in sudentslist table
A Ref value should be the key column value of the row referenced. The yellow triangle indicates the Ref value youโre using doesnโt match a value in the key column of the target table.
i dont know what i didโ but it disaperโ
but now when i see the rec in google sheet in the column name i see a num or the key uniqueid
Tnx for the link
In my case can i make the custumer name a key value ?
but a key value sould be unique and names not always unique
There is other way to do it ? other method ?
User | Count |
---|---|
32 | |
31 | |
30 | |
19 | |
16 |