I want to have the option of selecting from 2 different lists depending on a criteria. In the table [Complete List] I’d like to be able to have 2 lists available from which I could select some data.
For example, if Country = BFA, HTI or SEN, in column ‘Activity’ from table ‘Complete List’ I want to be able to select an activity from the column ‘CodedActivityFR’ in the table ActivitiesListFR.
Similarly if Country = KEN or TZA, in column ‘Activity’ from table ‘Complete List’ I want to be able to select and activity from the column ‘CodedActivityEN’ in the table ActivitiesListEN.
I can’t figure out a formula in the ‘Activity’ column that would allow me to select from a list drawn from 2 different tables depending on the ‘Country’ criteria.
Is that even possible in Coda?
Any assistance with this will be much appreciated.