+7Does anyone here know if it is possible to color code a field based on the value entered in the field?
Like my example below where I want to add conditional formatting based on the value the user entered.
If it is below a certain value, green. if above, red.
The example above is hypothetical. The actual use case involve custom fields that are looking at values in a separate table for validation.
Best answer by NovPeterR
Hi
Not on a detail page field like the Price one in your screenshot. Conditional formatting in IFS Cloud only works on list (table) columns. The docs up to 26R2 still describe it that way.
If the data can sit in a list, it works:
*Only you (24R1+): List Settings > New Formatting. Pick the column, condition and color. It's stored in your user profile.
*All users (25R1+): Page Designer > All Elements > Lists > your list. Toggle additional attributes, add a conditional format, set the case (condition) and the formatting, then save and publish.
*Custom fields are supported.
*Make one rule for green and one for red. Conditions inside a rule are AND only.
For your real case with limits in another table: the condition can't query another table. Get the limit onto the same record as a read-only custom attribute, then compare the two fields in the Page Designer rule:
*Green: Cf_Value <= Cf_Limit
*Red: Cf_Value > Cf_Limit
Swap in your own attribute names. Keep the limit as a custom attribute, not a Page Designer computed field. Computed fields aren't supported by conditional formatting.
If it has to be on the detail page: there's no standard way to color the input field itself. The closest you'll get is a separate read-only badge next to it (say "Within limit" / "Over limit") with an emphasis color. Badges are always read-only, and emphasis is documented as a developer (Marble) property. Check that your version's Page Designer lets you set it before you plan around it.
Best,
Gleb
Thanks
Looks like the badge solution would fit our purpose the best.
/Peter
Hi
Not on a detail page field like the Price one in your screenshot. Conditional formatting in IFS Cloud only works on list (table) columns. The docs up to 26R2 still describe it that way.
If the data can sit in a list, it works:
*Only you (24R1+): List Settings > New Formatting. Pick the column, condition and color. It's stored in your user profile.
*All users (25R1+): Page Designer > All Elements > Lists > your list. Toggle additional attributes, add a conditional format, set the case (condition) and the formatting, then save and publish.
*Custom fields are supported.
*Make one rule for green and one for red. Conditions inside a rule are AND only.
For your real case with limits in another table: the condition can't query another table. Get the limit onto the same record as a read-only custom attribute, then compare the two fields in the Page Designer rule:
*Green: Cf_Value <= Cf_Limit
*Red: Cf_Value > Cf_Limit
Swap in your own attribute names. Keep the limit as a custom attribute, not a Page Designer computed field. Computed fields aren't supported by conditional formatting.
If it has to be on the detail page: there's no standard way to color the input field itself. The closest you'll get is a separate read-only badge next to it (say "Within limit" / "Over limit") with an emphasis color. Badges are always read-only, and emphasis is documented as a developer (Marble) property. Check that your version's Page Designer lets you set it before you plan around it.
Best,
Gleb
+7Hi
Not on a detail page field like the Price one in your screenshot. Conditional formatting in IFS Cloud only works on list (table) columns. The docs up to 26R2 still describe it that way.
If the data can sit in a list, it works:
*Only you (24R1+): List Settings > New Formatting. Pick the column, condition and color. It's stored in your user profile.
*All users (25R1+): Page Designer > All Elements > Lists > your list. Toggle additional attributes, add a conditional format, set the case (condition) and the formatting, then save and publish.
*Custom fields are supported.
*Make one rule for green and one for red. Conditions inside a rule are AND only.
For your real case with limits in another table: the condition can't query another table. Get the limit onto the same record as a read-only custom attribute, then compare the two fields in the Page Designer rule:
*Green: Cf_Value <= Cf_Limit
*Red: Cf_Value > Cf_Limit
Swap in your own attribute names. Keep the limit as a custom attribute, not a Page Designer computed field. Computed fields aren't supported by conditional formatting.
If it has to be on the detail page: there's no standard way to color the input field itself. The closest you'll get is a separate read-only badge next to it (say "Within limit" / "Over limit") with an emphasis color. Badges are always read-only, and emphasis is documented as a developer (Marble) property. Check that your version's Page Designer lets you set it before you plan around it.
Best,
Gleb
Thanks
Looks like the badge solution would fit our purpose the best.
/Peter
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
