Hi all
Our agency serves a small town of 2,000 people. We still provide vacation checks to our residents. If they go on vacation, they can submit a form to us and we will either do a drive by or go around and check windows and doors, depending on their request.
I would really like to be able to enter these vacation checks in M43 and then use the data lake access to run a daily report against any active vacation checks. For instance, create a new report type called “Vacation Check” and set the event start date/time as the start date of the vacation check and set the event end date/time as the end date of the vacation check. Then create a data lake report that pulls out any requests that are active based on when the report is run.
The challenge, so far, is M43 does not allow future dates in the start/end dates for reports, at least as far as I know.
Has anyone else run into this type of need and found a way to do it with M43?