Hello. I recently created an app to schedule work orders for a pest control company. I have it set up so that when I create a reoccurring service setup the system generates all the orders at once. For instance, if the service is quarterly it will happen four times per year 90 days apart so the system will create all four work orders at once. If it happens monthly it will create twelve orders and so on. Is there a way to get the dates to automatically advance on each order based on the days in between orders? For instance, if I generate four orders for a quarterly service is there a way for the four orders to have the work dates automatically generate 90 days apart? Right now when they generate, the work dates are the same for each order, please help.
Could you update how you are generating those 12 monthly or 4 quarterly orders, one could possibly suggest. Could you update if there are 4 records- one each for each quarter and 12 records for the monthly orders - one each for each month? What is the date for the first order- 1 month or 1 quarter from the date of order booking?
Whatever work date I select for the first order in the setup, I’d like the other dates to generate based on the first date. For instance, if I choose 1/1/2023 for the first date and the setup is quarterly, then the other three dates should be 4/1/2023, 7/1/2023, and 10/1/2023, but the way it is now all four dates show 1/1/2023.
Thank you. Creating an expression would depend on how the order records are. As already requested, if you could share, the structure of one master order with all monthly or yearly repetitions, a better approach could be suggested. Are there 12 records for 12 monthly orders and I presume there is a column for selecting monthly / quarterly?
Yes, you are correct however, I do not know what you mean by “share, the structure of one master order with all monthly or yearly repetitions”. How do I do that?
Are you able to share screenprint of how the order table data looks for one order monthly or quarterly ? Of course please ensure you share pseudo data and not real data.
Also a screen shot of order table column summary of Appshert (column names, types and screen print) will help.
In general, the addition of month and 90 days can be somewhat easily achieved by using date functions available in AppSheet.
But precise approach will depend on how your orders are structured and what identifies say month 2 from month 1 and month 3 from month 2 order and so on, so that days could be accordingly added.
Hence the request for order structure. Or else please take a look at date functions in Appsheet and you could arrive at a suitable expression.