Conditional Formatting or Pop Up Alerts
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.
- Primary contact
- No. 2 contact
- 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.