I need help with creating a new app does anyone know if it is possible to do the following:
My app is for creating and tracking work orders (maintenance items) I have 1 table which
is a list of jobs (many jobs are “Standard jobs” ie. they are done over and over every x days. Another table is a log of each time a job is completed. Here is the hard part…
Is their a way to say for a particular job this needs to be done every x days so automatically reference the log of all completed jobs and look for the last time that job has been completed and once the time period has passed tell me that this jobs is due to be completed again?