Enum list with Reference

AppSheet AppSheet Q&A
1

Hi. I am trying to create a field where I can ‘tag’ a record with multiple references based on the values in another table. e.g. A record in table A relates to 3 of the 6 records in table B, so I want to tag that record with references to those 3 records in table B.

I thought I could use ENUM with Item Type ‘Reference’ and then select the table I want to reference. But this does not work. No records from Table B come up unless they are already being used in Table A.

Any suggestions?

2

For me it sounds like you don’t have a formula in the Suggested values and you have the option “Auto-complete other values” set as ON. Remove that option and add this kind of formula to Suggested values.. TableName[KeyColumn].

1 Like
3

Thank you Aleksi

4

You’re welcome!