Question

Updating secondary table dependant on maintenance standard based schedule from first table

  • 26 March 2020
  • 1 reply
  • 1 view

Hello all,

fear i'm out of my depth here. Trying to build a workflow to manage some maintenance for gardens ect and the differing levels of gardens and grass obviously have differing maintenance frequencies.

For existing areas eg for the 8 weekly maintenance areas, their due date would come up and that would trigger the workspace to create centroids (ie points) based on site name (if sharing the same site) and then update the assignments layer for arcgis workforce.

Now what im struggling with would be how id trigger those updates to the assignment layer depending on which maintenance schedule had elapsed that day? Just to give you an idea some are weekly, fortnightly, monthly ect.

 

James


1 reply

Badge +10

So you have a start date for each schedule? And on any given date you need to evaluate if the current date falls on a schedule day

e.g. start date is 16th March, on the 23rd March you would want weekly events triggered, on the 30th March you would want both weekly and fortnightly events triggered?

Reply