Hi
I have a survey record table where users input each conducted survey for a given area. This table has survey_area, (area code) date_start (date of survey), and frequency (surveying freq. in days) attributes. I would like to create a separate "survey planning" table to show upcoming surveys based on the latest survey and the frequency of each area. When a survey is done, planning table should show upcoming surveys for the next 2 years. Whenever the same area is surveyed next, the table should update all the dates based on the latest survey date. That's because a survey could be late or early and planning table should always show an up to date plan.
My logic is to create an attribute rule triggered after each insert to first check the planning table, delete all entries with the same survey_area attribute and create new ones from the latest entry based on the new survey date.
With a basic understanding of arcade, I can get the data, filter etc but I don't know how to delete and populate the planning table. Could you please help?
