Is it possible to do a lookup to two different tables based on a criteria?

1

Hello Codans,

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.

1 Like
2

Hey @Gerardo_Ducos
good question!

There is a recent thread with (as I understand) a quite similar request with two solutions. Maybe this gives you a hint in the right direction?

3

Hi Daniel, thanks for that. It worked fine with the second Switch option.
Special thanks to Saúl who also proposed a solution directly in the doc.

Cheers

2 Likes
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.