Update Records based on Dates in the Record
Looking to change fields in a record when the today is equal to a date field. Eg. Update status for a record to "Active" when today is equal to "subscription start" date field.
Forum Discussion
You can use an Automation to run a saved table to table import and import the table into itself merging on Record ID#. Create a field which calculates to "Active" and map that field into the status field.
You may also just be able to use an Automation to just filer a list of qualifying records based on that date and then do the edit. That method would have a limit of 1,000 updates.
You may also just be able to use an Automation to just filer a list of qualifying records based on that date and then do the edit. That method would have a limit of 1,000 updates.