Open a new month and retain the data for the previous month

Ask for Help
1

I have an application that makes maintenance orders for maintenance technicians, and I want to open a new month for users while keeping the data for the previous month

thanks for the help

2

You may need to explain exactly what you mean by “open a new month”.

Normally with this sort of thing you would be using a form to add data which would capture that date/time that each item is created, so there would be no need to open anything.

If you want to hide older data from view, that’s just a matter of applying an appropriate filter.

3

Thanks for paying attention
I want to hide the data, but I need it to be available somewhere else to search
Orders that start on 1/5 have a number that starts with 1-2-3 and so on until the end of the month

4

Okay, so you need to number your orders, and reset the order number at the start of each month, yes?

A word of caution - actions in Glide are not atomic, meaning that if you’re doing something like incrementing a number when a form is submitted, there is always the chance that you may end up with duplicate numbers if two or more users happen to submit a form at almost exactly the same time.

The only reliable way to avoid the above issue is to delegate the assignment of numbers to a 3rd party, such as Make or Zapier.

The video in the below doc shows how that can be done using Make:

3 Likes