Is it possible to manually create a list in a...

(Simon Robinson) #1

Is it possible to manually create a list in a column e.g. A, B, C, D

then in a different table reference that list and be able to choose A or B or C or D via an ENUM?

Since you can’t make the column of list type unless it’s a virtual column.

Don’t really want to have to create a table with one column for each possible variation.

When I’ve tried to do this the ENUM just give me one option - “A, B, C, D”

(Steven Coile) #2

You could create a table to contain those Enum values. Call it, e.g., Enums, with three columns: Context (Text, required), Value (Text, required, label), and ID (Text, key, app formula =UNIQUEID()). Use Context to differentiate collections of values, and Value to define the values within a context. To use, reference in another column’s Valid_If: SORT(SELECT(Enums[Value], ([Context] = “Choose A, B, C, or D”))).

(Simon Robinson) #3

Not sure if that will work.

So its an App to record the dosages of medication that someone takes.

So you select Mediation A and it needs to give you the dosage options of 10mg, 20mg, 30mg.

Whereas if you choose Medication B it might give 10mg, 50mg or 100mg.

I thought I’d be able to the dosages into one column :confused:

(Aleksi Alkio) #4

Why don’t you then use a dependent dropdown?

(Simon Robinson) #5


Wouldn’t i need to each dosage to be on a different line for that to work?

(Aleksi Alkio) #6

Yes, you would need to have one row for each Mediation and dosage.