Solved: Creating dropdown of multiple column values within... - Page 2

Nick_Neumann · 03-03-2020 09:57 PM

In my app, I have a column for the price (A Table) of an item, and 4 other subsequent columns with markup values based on that price by percentage (5%, 10$, 15%, 20%, 25%). Each row is a different item therefore has a different price there for have different markup values. I would like to create a dropown that copmresses all of the markup values into one column. So if the price of an item is $100, I would like the 4 different markup values to be in one dropdown. As of now, I have the price column and 4 different markup value columns which takes up a lot of space. I’m hoping there is some sort of Valid_if function that would allow me to do this.

Suvrutt_Gurjar

hI @Nick_Neumann,

Good to know it works. For adding percentage values to the dropdown your valid_if expression couldbe something like

LIST(CONCATENATE("5 % - ",[A Table]*1.05),CONCATENATE("10 % - ",[A Table]*1.10), CONCATENATE("15 % - ",[A Table]*1.15), CONCATENATE("20 % - ",[A Table]*1.20), CONCATENATE("25 % - ",[A Table]*1.25))

Please note that the above expression will change the return value type and hence column base type from price to text. This is so because now we have prefixed a text string to those markup values, thereby converting the return value to a text string.

Thus please do change the base type of the enum column from Price to Text.

View solution in original post

Creating dropdown of multiple column values within row