Hello all, new to AppSheet - trying to implement the below DB Model in AppSheet:
In AppSheet, I have set up the relationship / reference between Contracts and Nomination as follows (Contract is input by the user as
TEXT type, and is a primary key in the Contracts table)
- Related Nominations
Now, I am working on setting up the relationship / reference between Nominations and Loading (Nomination ID is AppSheet generated using
UNIQUEID() in INITIAL VALUE, and is a primary key in the Nomination table)
- Related Loading
REF_ROWS("Loading", "Nomination ID")
- Nomination ID
This is causing the error(s):
Column Name ‘Nomination ID’ in Schema ‘Nomination_Schema’ of Column Type ‘List’ has an invalid ‘Initial Value’ of ‘UNIQUEID()’. The type of the Initial Value does not match the column type. Consider using ‘’ instead.
Column Name ‘Nomination ID’ in Schema ‘Nomination_Schema’ has a ‘List’ type. Only virtual columns are currently allowed to have the List type.
Key column ‘Nomination ID’ in Schema ‘Nomination_Schema’ cannot use an app formula. The app formula will be removed.
Is there any way for a key column to use
UNIQUEID(), and use that key column as a
REF to another table?