July 18, 200322 yr If this possible to have filemaker set filedtype text in red each time it check if a due date field is smaller or equal rhan today. Kind of: If [duedate] than Today set the fieldtype to red ??
July 18, 200322 yr No, but you can create that calculation field with Due Date as its result, and put it on the layout on top of the Due Date field, set it with a clear fill pattern, and format its text as red. When the calculation is valid, the red field will display over the normal Due Date field. When it's not valid, you'll only see the normal one.
Create an account or sign in to comment