Conditions

[av_one_full first min_height=\’\’ vertical_alignment=\’\’ space=\’\’ row_boxshadow=\’\’ row_boxshadow_color=\’\’ row_boxshadow_width=\’10\’ custom_margin=\’\’ margin=\’0px\’ mobile_breaking=\’\’ border=\’\’ border_color=\’\’ radius=\’0px\’ padding=\’0px\’ column_boxshadow=\’\’ column_boxshadow_color=\’\’ column_boxshadow_width=\’10\’ background=\’bg_color\’ background_color=\’\’ background_gradient_color1=\’\’ background_gradient_color2=\’\’ background_gradient_direction=\’vertical\’ src=\’\’ background_position=\’top left\’ background_repeat=\’no-repeat\’ highlight=\’\’ highlight_size=\’\’ animation=\’\’ link=\’\’ linktarget=\’\’ link_hover=\’\’ title_attr=\’\’ alt_attr=\’\’ mobile_display=\’\’ id=\’\’ custom_class=\’\’ aria_label=\’\’ av_uid=\’av-dy04o\’]

[av_heading heading=\’Conditions\’ tag=\’h1\’ link=\’\’ link_target=\’\’ style=\’blockquote modern-quote\’ size=\’\’ subheading_active=\’\’ subheading_size=\’\’ margin=\’\’ padding=\’10\’ color=\’\’ custom_font=\’\’ custom_class=\’\’ id=\’\’ admin_preview_bg=\’\’ av-desktop-hide=\’\’ av-medium-hide=\’\’ av-small-hide=\’\’ av-mini-hide=\’\’ av-medium-font-size-title=\’\’ av-small-font-size-title=\’\’ av-mini-font-size-title=\’\’ av-medium-font-size=\’\’ av-small-font-size=\’\’ av-mini-font-size=\’\’][/av_heading]

[av_hr class=\’default\’ icon_select=\’yes\’ icon=\’ue808\’ position=\’center\’ shadow=\’no-shadow\’ height=\’50\’ custom_border=\’av-border-thin\’ custom_width=\’50px\’ custom_margin_top=\’30px\’ custom_margin_bottom=\’30px\’ custom_border_color=\’\’ custom_icon_color=\’\’ av-desktop-hide=\’\’ av-medium-hide=\’\’ av-small-hide=\’\’ av-mini-hide=\’\’ id=\’\’ custom_class=\’\’ av_uid=\’av-9xhyw\’]

[av_textblock size=\’\’ av-medium-font-size=\’\’ av-small-font-size=\’\’ av-mini-font-size=\’\’ font_color=\’\’ color=\’\’ id=\’\’ custom_class=\’\’ av_uid=\’av-k9d1m1dz\’ admin_preview_bg=\’\’]

The ‘Conditions’ functionality in Report Builder allows you to set certain formatting options based on the value of the data.

For instance, lets say you have a ‘Date’ field in your app, and you want to show the ‘Date’ Field with a red background if it is greater than todays date.

Select ‘Conditions’ from the ‘Home’ ribbon bar, and ‘Add Condition’.

[/av_textblock]

[av_image src=\’http://appcan.help/wp-content/uploads/2020/04/image-3.png\’ attachment=\’484\’ attachment_size=\’full\’ copyright=\’\’ caption=\’\’ styling=\’\’ align=\’left\’ font_size=\’\’ overlay_opacity=\’0.4\’ overlay_color=\’#000000\’ overlay_text_color=\’#ffffff\’ animation=\’no-animation\’ hover=\’\’ appearance=\’\’ link=\’\’ target=\’\’ id=\’\’ custom_class=\’\’ av_element_hidden_in_editor=\’0\’ av_uid=\’av-k9d1n3h2\’ admin_preview_bg=\’\’][/av_image]

[av_hr class=\’invisible\’ icon_select=\’yes\’ icon=\’ue808\’ font=\’entypo-fontello\’ position=\’center\’ shadow=\’no-shadow\’ height=\’20\’ custom_border=\’av-border-thin\’ custom_width=\’50px\’ custom_margin_top=\’30px\’ custom_margin_bottom=\’30px\’ custom_border_color=\’\’ custom_icon_color=\’\’ id=\’\’ custom_class=\’\’ av_uid=\’av-k9d1ofaz\’ admin_preview_bg=\’\’]

You will need to select the ‘Column’ to show which field you want to apply the Condition to, and then select ‘greater than’ and enter ‘{Today}’ to identify the matching text.

Now, just set the font and background options you wish. In this example, the background is set to red and the font to white.
[/av_textblock]

[av_image src=\’http://appcan.help/wp-content/uploads/2020/04/image-4.png\’ attachment=\’490\’ attachment_size=\’full\’ copyright=\’\’ caption=\’\’ styling=\’\’ align=\’left\’ font_size=\’\’ overlay_opacity=\’0.4\’ overlay_color=\’#000000\’ overlay_text_color=\’#ffffff\’ animation=\’no-animation\’ hover=\’\’ appearance=\’\’ link=\’\’ target=\’\’ id=\’\’ custom_class=\’\’ av_element_hidden_in_editor=\’0\’ av_uid=\’av-k9d1n3h2\’ admin_preview_bg=\’\’][/av_image]

[/av_one_full][av_one_full first min_height=\’av-equal-height-column\’ vertical_alignment=\’av-align-top\’ space=\’\’ row_boxshadow_color=\’\’ row_boxshadow_width=\’10\’ custom_margin=\’aviaTBcustom_margin\’ margin=\’0px,20px\’ mobile_breaking=\’\’ border=\’\’ border_color=\’\’ radius=\’0px\’ radius_sync=\’true\’ padding=\’0px\’ padding_sync=\’true\’ column_boxshadow_color=\’\’ column_boxshadow_width=\’10\’ background=\’bg_color\’ background_color=\’\’ background_gradient_color1=\’\’ background_gradient_color2=\’\’ background_gradient_direction=\’vertical\’ src=\’\’ attachment=\’\’ attachment_size=\’\’ background_position=\’top left\’ background_repeat=\’no-repeat\’ highlight_size=\’1.1\’ animation=\’\’ link=\’\’ linktarget=\’\’ link_hover=\’\’ title_attr=\’\’ alt_attr=\’\’ mobile_display=\’\’ id=\’\’ custom_class=\’\’ aria_label=\’\’ av_uid=\’av-llg45\’]

[av_heading heading=\’Example Conditions\’ tag=\’h3\’ style=\’blockquote modern-quote\’ subheading_active=\’\’ size=\’\’ av-medium-font-size-title=\’\’ av-small-font-size-title=\’\’ av-mini-font-size-title=\’\’ subheading_size=\’\’ av-medium-font-size=\’\’ av-small-font-size=\’\’ av-mini-font-size=\’\’ color=\’\’ custom_font=\’\’ margin=\’\’ margin_sync=\’true\’ padding=\’10\’ link=\’\’ link_target=\’\’ id=\’\’ custom_class=\’\’ av_uid=\’av-kb3zqz97\’ admin_preview_bg=\’\’][/av_heading]

[av_hr class=\’custom\’ icon_select=\’no\’ icon=\’ue808\’ font=\’entypo-fontello\’ position=\’left\’ shadow=\’no-shadow\’ height=\’50\’ custom_border=\’av-border-thin\’ custom_width=\’100%\’ custom_margin_top=\’0px\’ custom_margin_bottom=\’10px\’ custom_border_color=\’\’ custom_icon_color=\’\’ id=\’\’ custom_class=\’\’ av_uid=\’av-hftjh\’ admin_preview_bg=\’\’]

[av_toggle_container initial=\’0\’ mode=\’accordion\’ sort=\’\’ styling=\’\’ colors=\’\’ font_color=\’\’ background_color=\’\’ border_color=\’\’ colors_current=\’\’ font_color_current=\’\’ background_current=\’\’ background_color_current=\’\’ background_gradient_current_color1=\’\’ background_gradient_current_color2=\’\’ background_gradient_current_direction=\’vertical\’ hover_colors=\’\’ hover_background_color=\’\’ hover_font_color=\’\’ alb_description=\’\’ id=\’\’ custom_class=\’\’ av_uid=\’av-kb3zqcbu\’]
[av_toggle title=\’Show ‘Pass’ / ‘Fail’ background in different colours\’ tags=\’\’ custom_id=\’\’ av_uid=\’av-7jiag\’]
If you want to add a background colour to a field, based on the field data, you can use a simple Condition.

For example, if you had a Field named ‘Result’ with data options of ‘Pass’ or ‘Fail’ and want to show a green background for Pass and a red background for Fail, you can set this using ‘Highlight Conditions’.

$\"\"$ $\"\"$
[/av_toggle]
[/av_toggle_container]

[/av_one_full]

AppCan Support