Tuesday, June 22, 2021

A Quick Tip on Using Bubble (Highlighting)

Imagine you have a repeating group filled with "to-do" records that include a due date along with a "Finished" field and you want to highlight those records that are still incomplete and past their due date. Here's how to do that:

  • To change the font color of the due date field in the list of to-dos, double-click the “Due date” element in the first row of the to-do list repeating group to display the element's property editor.
  • Click on the “Conditional” tab in the properties box, go to the "When" field  and build the expression “Current cell's Todo's Due Date < Current date/time and Current cell's Todo's Finished is 'no'”.
  • In the “Select a property to change when true” dropdown, pick “Font color”. Then select to change the font color of the due date to red when the condition is true.



No comments:

Post a Comment