Use UNIQUEID() as REF

[leeca]

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)

Contracts (One)

• Related Nominations
  Type: List
  Formula: REF_ROWS("Nomination", "Contract")

Nominations (Many)

• Contract
  Type: Ref
  Formula: None

---

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)

Nominations (One)

• Related Loading
  Type: List
  Formula: REF_ROWS("Loading", "Nomination ID")

Loading (Many)

• Nomination ID
  Type: Ref
  Formula: None

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?