Creating dropdown of multiple column values within row

[Nick_Neumann]

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,

You could create a combined Markup column of Enum type and base type as “Price” with valid_if expression of

LIST([A Table]*1.05,[A Table]*1.10, [A Table]*1.15, [A Table]*1.20, [A Table]*1.25)

As a better elements naming practice, you may also wish to rename the [A Table] column to some other name such as Item Prices or something similar. The reason is “Table” word is generally associated with a spreadsheet or database table.

[Nick_Neumann]

Suvrutt_Gurjar:

LIST([A Table]*1.05,[A Table]*1.10, [A Table]*1.15, [A Table]*1.20, [A Table]*1.25)

Suvrutt, Thanks for the reply! This seemed to work perfectly except when I go to actually use the dropdown and save the chosen value, it gives e an error saying “This entry is invalid”!

Screen Shot 2020-03-04 at 9.14.19 AM|678x408

[Suvrutt_Gurjar]

Hi @Nick_Neumann,

Is it possible that you can share the screenshot of the column settings for the new enum column?

[Nick_Neumann]

Suvrutt,

Thanks again for responding again, and by you asking me that, I realized I actually didn’t change it to an Enum type. That did the trick, thank you!!! One more question though, How would I adjust the List expression to include the % in the dropdown. So it would read, “5% - $105”, “10% - $110”, etc. within the dropdown?

[Suvrutt_Gurjar · Accepted solution]

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.

[Nick_Neumann]

Suvrutt_Gurjar:

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))

Worked perfectly. Thanks again Suvrutt!