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! Go to 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
User | Count |
---|---|
16 | |
11 | |
9 | |
8 | |
4 |