Trigger Fields to Update
Hi everyone! I have a field that is set to calculate that if a field has the current date that it shows "Enrolled" and if it is a previous date it shows "Dropped". Whenever I import, it only touches the fields that are getting updated with the new date. However, I need a way for Filemaker to trigger all fields to update them and realize that they have a previous date. This only occurs the next day when the calculate field needs to be updated because the current date has changed. Make sense? Any ideas?