Help with a simple Select List Formula

1

I’m having trouble creating a filtered select list.

image
image764×362 34.7 KB

This table lists Payment Methods with associated Payment Accounts

image
image750×282 23.2 KB

This table is where I select the Payment Account for the Payment Method. Currently all of the Payment Accounts appear in the dropdown list.

I cannot figure out the formula to filter the Payment Account table by the Payment Method so that I only see Amex Blue and Amex Gold and do not see Citi Blue and Citi Gold when American Express is selected.

I tried the formula below but it’s not correct:

image
image746×274 22.4 KB

2

Hello @Sarah_Zwier ,

What you are trying to accomplish is not too complicated, but you need to set it up properly. If you share a dummy doc, I am sur someone in the community (or I) can help you.

Greetings,
Joost

3

Here is a public link to the doc. Is there a better way to share it on here or is it just a matter of providing this.

4

Hey @Sarah_Zwier ,
I fixed it for you (gave you some options) - and I tried to explain it (bottom of the page). These type of things are confusing for new users. You have to play with Coda a lot - at some point you will start to see the light, the frustration will vanish and it becomes fun to build these type of documents.
Greetings,
Joost

5

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