Using App Variable Data To Search Data Resource

I have a data resource with the following fields:

  • title
  • code

Example title: Allied Bank Collective
Example code: ABC

In settings, my users can select which ‘title’ they want, from the entire collection, which is stored in an app variable.

I need to use the ‘code’ from the associated variable, as the label for a button.

So, the app variable says: Allied Bank Collective

I need a way to pull the associated ‘code’ which matches the title: Allied Bank Collective

So, the button would show: ABC … since that is the associated code.

Solved my own question just by poking around some formula functions.

LOOKUP(FIND_BY_KEY(data["DATASOURCE"], "title", APPVARIABLE), "code")

Replace title and code with your own fields.

1 Like