Column as dropdown or text

[ehnz]

wondering if it is possible to use the valid if with an expression to allow the column to have dropdown values from another table, or allow free text - depending on the answer to a previous column? For example, if I select yes in question 1 then i can enter free text in question 2, if i select no in question 1, then i can only select from a dropdown list in question 2

[Kirk_Masden]

ehnz:

use the valid if with an expression to allow the column to have dropdown values from another table

I know that this is possible. I’m not sure about the rest. I’ve written about using values from another table in an Enum or Enum list here:

Converting text to unique lists for use as tags Tips & Tricks 💡

If you put a “list” into the “Valid if” part of an Enum or Enumlist column, the content of that list can then be selected by the user. An advantage of using the “Valid if” part of the in this way is that the contents of the enum (what the user sees as choices) can as data is added to or erased from the app. In the app I’m working on right now, I wanted such lists to be made from a record called “Tags” into which the users can type whatever they wish and then the contents would be parsed automa…

[Bahbus]

ehnz:

or allow free text - depending on the answer to a previous column? For example, if I select yes in question 1 then i can enter free text in question 2, if i select no in question 1, then i can only select from a dropdown list in question 2

For this part you would create a separate column for each possibility and use conditional Show Ifs on them to determine which ones display and when.