can someone give me a hint regarding table referencing or column referencing to be specific

[marvaddi]

in googlesheets i have two sheets.
1) "main" - has a column named [website name] the type is 'text'

2) "transaction" - has a column named [website] has a type 'Enum' (the contents of this column is the SAME as the one in [website name] under "main" sheet, just worded differently)

now, in appsheet, under "main view" i'm able to fill a form and manually type the [website name] (some of the site names are duplicates)


under "transaction view" on appsheet, when filling a form, for [name] i want to have a dropdown list of the contents for [website name] under main. and exclude the duplicates!!

im having issues with linking the table and referencing that column! plz help

[Gustavo_Eduardo · Accepted solution]

The [Website] column (currently Enum type) should be changed to Enum or Ref for better integration.

For the [Website] column of the “transaction” table, use a Valid If formula to generate a unique list of website names from the “main” table.

SORT(UNIQUE(main[Website_Name]))

3.Adjust Column Type
• If [Website] in the “transaction” table is Enum, the dropdown will display the options but store plain text.
• If [Website] is Ref, it will create a reference to the “main” table (useful if you need relational data).

This method ensures that the dropdown dynamically updates as new entries are added to the “main” table. Let me know if you need refinements!

[marvaddi]

wait wait wait wait... i put the formula in the formula section not in the valid if!! sorry, this worked well, thank you so much

[Gustavo_Eduardo]

🙌

[marvaddi]

thank you so much for the swift reply!! but it didnt quite work unfortunately 

"The [Website] column (currently Enum type) should be changed to Enum or Ref for better integration." ---> this column in transaction table is already set to Enum type.

im following your direction but i still am getting erros.
here the recap:
main:[website name], the  type is 'Text' (this is normail, as i want it, i will be manually entering website names)

now for the transaction i followed your steps (maybe)
transactions:[website], type is ENUM. Formula = SORT(UNIQUE(main[Website_Name]))
when i click save i get two erros and a warning:
error 1
Column Name 'website' in Schema 'transactions_Schema' of Column Type 'Enum' has an invalid app formula '=SORT(UNIQUE(main[Website_Name]))'. The type of the app formula 'List of Text' does not match the column type 'Enum of Text'.

error2:
Column Name 'website' in Schema 'transactions_Schema' has a 'List' type. Only virtual columns or inputs are currently allowed to have the List type. (im not sure why i got this error, it seems that it always kicks me out of enum and puts me in type "list" when i save)

warning:

Column Name 'website' in Schema 'transactions_Schema' of Column Type 'Enum' should have a list of allowed values or allow the user to add other values.

im really not sure what im missing or if i misfollowed your directions. i also tried the "ref" type and it throws a bunch of errors as well.