AnsweredAssumed Answered

Auto Generate Records Based on Field Calculation

Question asked by oman on Jun 27, 2014
Latest reply on Jul 17, 2014 by oman

Title

Auto Generate Records Based on Field Calculation

Post

     Hi,

     I have three tables: Objects, Maintenance Issues, Recurring Events.

     I'd like to auto-generate new Maintenance Issue records based on an "Overdue" field within the Recurring Events table. The overdue field is a number calculated from its duration length and last date completed.

     Is there a way for the database to automatically go through all Objects that have overdue Recurring Events and automatically generate new Maintenance Issue records for each overdue event?

      

     Thanks for all your help!

Outcomes