How to create format rule by setting the condition from a datatype of "Enum List"

Hi, I'm struggling with the following.. perhaps someone can help me ?

I'm displaying an Enum List of answers/statements. A user needs to click certain answers that I consider "required". I have 2 columns , one defining a list of statements, the other a boolean list defining whether the answer is "required". See example below. 

[statements]          [required]

Statement A         TRUE

Statement B         FALSE

Statement C         TRUE

 

When displaying the list [statements], I'd like the "required" statements to appear Bold or add an icon next to them. I was able to achieve this in a very convoluted way which only works for a very basic static list. 

If this condition is true: 

OR(

IN("Statement A",[statements]),

IN("Statement B",[statements]),  etc...)

 

The list of [statements] however is ideally a dynamic list (built with SELECT function) and may change based on user's previous answers. So, a rudimentary solution such as the one depicted above doesn't quite cut it for me. ... I would need something that would achieve the following:

For each item in the [statements] list check [required] column and apply formatting based on that.

Any help would be greatly appreciated! Been only using Appsheet for a week, and already building very useful apps. I'm a big fan ๐Ÿ™‚

Thank you, URos 

Solved Solved
0 10 2,018
  • UX
1 ACCEPTED SOLUTION

In this post, @dbaum has explained the approach. Please take a look and please revert if you need any more help in this regard.

Formatting of Enum Buttons - Google Cloud Community

Edit:  Also the [Required] column is Yes /No or TRUE/FALSE type. In (Y/N) columns, you can simply use the column name, such as [Required] in this case to check if it is TRUE or FALSE. You do not need further arguments such as [Required]=TRUE or {Required]=FALSE

View solution in original post

10 REPLIES 10
Top Labels in this Space