Can virtual column be formatted using a Format Rule just like a regular column?
If so, Iโm not sure what Iโm doing wrong here - Iโm pretty sure Iโve got the โmathโ right in the โif this condition is trueโ formulaโฆ
Please see attached imageโฆ
Any help would be appreciated!
Solved! Go to Solution.
@Tim_Martin
Basically for the format rules to appear correctly, the app needs to by synced to calculate the conditional expression. Therefore as the Form View fields will not be calculated till you save the form, itโs not possible to view the formatting rules in a Form View. However, on the contrary, provided you have an Enum or Enumlist items that you have formatted earlier, when the form is loaded they will appear as formatted as the app is synced and their conditional expressions are evaluated. To get what you want you can use Show Type/Text Qualifier VC, your formatting appears in the Form.
@Tim_Martin
Basically for the format rules to appear correctly, the app needs to by synced to calculate the conditional expression. Therefore as the Form View fields will not be calculated till you save the form, itโs not possible to view the formatting rules in a Form View. However, on the contrary, provided you have an Enum or Enumlist items that you have formatted earlier, when the form is loaded they will appear as formatted as the app is synced and their conditional expressions are evaluated. To get what you want you can use Show Type/Text Qualifier VC, your formatting appears in the Form.
ahhโฆthatโs right @LeventK. I forgot that rules only show in the detail views or as an enum/enumlist.
thanks!
User | Count |
---|---|
26 | |
25 | |
25 | |
23 | |
23 |