topic Re: Using a variable input field value to return the corresponding value of another field in App Development

Using a variable input field value to return the corresponding value of another field

zach_paz — Sat, 16 Nov 2024 20:05:16 GMT

HI!

I've searched the forums to solve this question, but cannot seem to get it working. Your help is much appreciated!

I have two fields with the following values:

Code	Code Name
1	Car
2	Bus
3	Plane

I would like to use an input field value to designate the code. In this case, the variable is called "vCode". I would like to return the corresponding field value for what matches the "vCode" input field box.

Input Field Value: "vCode"= 2

Result: Text Box: Bus

This would be similar to a vlookup in excel.

Thanks in advance!

Zach

Re: Using a variable input field value to return the corresponding value of another field

Vegar — Thu, 12 Sep 2019 22:51:49 GMT

You can achieve it using set analysis

Only({< Code = {'$(vCode)'}>} [Code Name])

Re: Using a variable input field value to return the corresponding value of another field

zach_paz — Thu, 12 Sep 2019 23:36:02 GMT

Works great. Thank you very much!

Re: Using a variable input field value to return the corresponding value of another field

taml — Fri, 30 Oct 2020 00:01:58 GMT

Thanks @Vegar for the solution and @zach_paz for pitching a perfect question.