Hi.
I have an EnumList Column called [Treatment Type] in Create Works Order Table and I want to create a simple Format Rule with conditional expressions that displays each of the options differently. Every expression I try just returns Cannot Compare List and Text.
Any help would be great, thank you.
Solved! Go to Solution.
@MauriceWhelan
Then the only chance is the way I have proposed. You cannot apply the format rule otherwise. Check if this is what you want:
@MauriceWhelan
I donโt think you can format each item of an Enumlist separately, because AppSheet will treat it as a single concatenated string at the end. However, provided you build a small table for those [Treatment Type] values (not sure how many of them you have) and construct your Enumlist as REF type, if you apply a formatting rule for each of the item in that small table, the Enumlist will reflect those values. This is the quickest way I can think of.
May be @Steve and/or @Aleksi might propose a better solution.
Many thanks for this suggestion @LeventK.
Youโre welcome @MauriceWhelan, my pleasure
Hi @LeventK
Can I just check the steps that I have carried out with you?
But when I look at that value in the drop down list it is unformatted.
Have I missed something in my set up?
Many thanks.
I donโt think format rules work within the drop downs. Only outside of them.
@MauriceWhelan
Have you set the expression in Valid_if to get the ref values?
SELECT(
RefTableName[KeyColumn],TRUE)
)
In my sample app itโs set like this:
Hi @LeventK
Thank you for that. My bad. My select function was slightly wrong. I was using [Treatment Type] column instead of [Record ID]. Made the change and it is working perfectly now.
Many thanks again.
Youโre welcomeโฆGlad to hear that you have resolved the issue
Differently in what way?
This should be easy to correct. What is/are your expression(s)?
I just want the text values to be different colours.The 3 options are CSP, ReDip, Standard.
I have tried SELECT(Create Works Order[Treatment Type],[Treatment Type]=โCSPโ)
I also tried with IN() expression.
@MauriceWhelan
How is your Enumlist content is set up? Hardcoded, or are you using a SELECT(โฆ) expression in Valid_if or Suggested_Values property?
At the moment they are hardcoded values.
@MauriceWhelan
Then the only chance is the way I have proposed. You cannot apply the format rule otherwise. Check if this is what you want:
Exactly what I am looking for. Thanks a million for that.
Youโre welcome @MauriceWhelan, my pleasure. Could you please mark my post as solution?
User | Count |
---|---|
41 | |
31 | |
29 | |
16 | |
14 |