AnsweredAssumed Answered

Conditional Formatting or Pop Up Alerts

Question asked by brian.curran on Oct 23, 2012
Latest reply on Oct 24, 2012 by brian.curran

Title

Conditional Formatting or Pop Up Alerts

Post

     Hi,
     I have a layout that is based on the People table which contains contact details and there is also a portal based on a Join to the Sites table, which shows the Sites that people belong to.

     In this join table and portal there is a checkbox set for the 'Role' field. What I would like to do is either conditionally format a field on the People record whenever a checkbox is ticked or have an alert pop up.

     For example:

         
  •           Primary contact
  •      
  •           No. 2 contact
  •      
  •           Billing
  •      
  •           Maintenance
  •      
  •           Key Holder

     If Billing is ticked, I want to check the 'Phone' and 'Email' fields to see if there are any values.
     If Key Holder is ticked, I want to check whether there is a value in the 'Mobile No.' field.

     If the fields are empty, then either highlight the fields or maybe create a pop up alert, any suggestions would be great.

     Thanks
     Brian.

Outcomes