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)
REF_ROWS("Nomination", "Contract")
Nominations (Many)
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)
REF_ROWS("Loading", "Nomination ID")
Loading (Many)
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?
Hi @leeca
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.
You may consider changing the Nomination ID Type as Text, because UNIQUEID() returns Text.
Basically, you should have:
Table1 (Parent Table):
Table2 (Child from Table1):
In practice, you donโt need to create the virtual column
`REF_ROWS(โLoadingโ, โNomination IDโ)
It will be created automatically when saving, after you picked the source table in the Ref column of your Child Table.
Column Name โNomination IDโ in Schema โNomination_Schemaโ has a โListโ type. Only virtual columns are currently allowed to have the List type.
A Virtual Column can have List Type ; a real column can have either Enum Type, or EnumList Type (if you are looking for โListโ kind of type).
Key column โNomination IDโ in Schema โNomination_Schemaโ cannot use an app formula. The app formula will be removed.
Here, because key-column are supposed to be absolutely unique, you cannot use a formula that may affect its value. So, you can only set a Initial Value Formula (andโฆtypically UNIQUEID() )
For further informations, please have a look to
Can you please let us know if you succeed into this realization ?
Thanks
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |