Reference Data Type issues

AppSheet AppSheet Q&A
1

Hi,

Sometimes, when i add a reference to a field, the value (list) in the application contains a different reference data.

Eg. In Candidates Table, I have a Job Title Reference to Requirements table (same column name Job Title). I have another field Customer, which is referencing a field in Requirements table (same column name). In Job Title, i am getting the correct value list. But in Customer list, i am getting Job Title list.

Please advise why i get this issue.

Thanks, Santhosh.

2

https://support.google.com/appsheet/answer/10106510?hl=en

Ref column always references the key column of the referenced table.

I am guessing Job Title is the key of Requirements.

If you have Customers table, make a ref to that table instead of Requirements.

2 Likes
3

Thank you TeeSee1.

1 Like