Enumlist from enum

Phil_Waite · 02-01-2020 08:43 AM

Hi,

I have a user input table with an enum drop down that has 4 values that are the same as 4 column headings in my main table called Full List Table

The column in the editable table that holds this enum is called [Entry To Change]

Outlet Rating
Outlet Type
Price List
Route Code

I have another drop down enumlist that shows a list based on which ever has been selected in the previous one.

In the Valid IF box it can use IF([Entry To Change]=“Outlet Rating”, Full List Table[Outlet Rating]…etc

How can I simplify the expresion to Full List Table[what ever has been selected in Entry To Change] as a dynamic enumlist.

Thanks

Phil

MultiTech

If I’m understanding your setup correctly, you’ve got the right idea. A SWITCH() would look cleaner:

SWITCH([Entry To Change],
“Outlet Rating”, Full List Table[Outlet Rating],
etc.)

But if you’re looking for a way to dynamically change the value inside the formula square brackets:

You can’t do that; that’s a part of the overlying “code” of your app. (At least I can’t think of any way to do what you’re thinking - the SWITCH() is what I would do.)

A completely different approach would be to use a reference system:

Phil_Waite

Hi, Thank you. Switch worked fine.

Very slow to save the form though. Maybe even too slow as a function. Still waiting for the “change value in certain columns on the fly” funtion to appear on appsheet. Will open up my app so much.

Phil