I’ve got an app that includes Scheduled/Completed checklists. I’m looking for a way to mass schedule checklists for people in the future. I would like to make it where I don’t have to manually add each checklist one by one.
The first part of the form is pictured below. I was thinking I could add a Y/N column called “Recurring?”. Selecting Yes would show a “Number of Days” column. Using this Number of Days I could use an Action to add rows to my database X number of times. So if I said “Yes”, “7 Days”, it would create 7 copies of my record in the future using DATENOW()+1,+2,+3 etc.
Is this possible? Or is there another way to accomplish this?
Solved! Go to Solution.
@CorpIT
Yes it is possible. You need to create a scheduled report of Data Change type and create an action for this table > Data: add a new row to another table using values from this row. You will need a couple of expressions as well.
User | Count |
---|---|
18 | |
9 | |
8 | |
6 | |
5 |