My app has a list of contacts in which you can select a โroleโ for the customer in the customer form. Contacts can have more that one role so the options are in an enum list. In the deck view I am trying to assign and icon to various rolesโฆ ie. โBillingโ โSales and Serviceโ โManifestโ Iโve encountered the problem before and have solved it by changing the column type to enum (yes/ not result) instead of enum list but in this case having multiple selections in the list is necessary.
Is there a way to assign an icon per role with the column type set as enum list?
[Role] Values are โBillingโ, โSales and Serviceโ, โManifestโ
Solved! Go to Solution.
Try IN("Billing", [Role])
.
Thanks Steve. I had read this before and had not found the answer there. When I try to use the expression [Role] = โBillingโ I get an error: Cannot compare List with Text in ([Role] = โBillingโ)
The values are coming from an enum list in the [Role] column.
Try IN("Billing", [Role])
.
That did it! Thanks. Would love to know the interpretation of the formula so I can learn.
The solution from @Steve was to check if the text โbillingโ is found IN the list in the column [role].
For example:
IN("Banana", [FruitEnumList])
: returns TRUE if the column FruitEnumList contains the value, โBananaโ.You can read more about IN and other expressions on the Appsheet support site.
What @Mike said.
hi @Steve. a slightly different need.
i want to show a Text Field only when the value โHourly Ratesโ is the selected one from the list in the Ref.
if i put IN(โHourly Ratesโ,HEADERS[Billing]) in โShow_If expression for column Requestor (Yes/No)โ it only gives Yes / No Buttons
does this make sense?
Ooops, wait! the Field i wanted had changed to type Yes/No. set it to text it looks like it is working.
thank you!
User | Count |
---|---|
33 | |
30 | |
30 | |
19 | |
17 |