We need to make this action to reset to NO value at the end of every month.
will this do the trick.
@ns_soft_studio1
It seems correct
i think you gave us the solution the first time we asked and for that we thank you, but we think because they will alter that value during the month to โyesโ and they need to see what is done and what is not before the butoon resets to โnoโ this is a beeter solution, we are still confused how to resolve this.
they have a monthly obligation to check lifts in period of one month about 400 of them, as part of maintenance and they need to do that every month, and to have what is done in that month and what is skiped so they can do that in the next one, so for us its a bit difficult to make that happen for them.
one question will it do it automatically when the time comes or they need to press the action button.
They need to press the action button. Provided you need an automatic action to be taken, then I may advise using Scheduled Report feature for that.
HI again, this is what we need this thing to do, at the end of every month we need to reset enum value from โyesโ to โnoโ automatically, and it needs to be able for service men who are doing the monthly inspection to change that to โyesโ and it needs to stay โyesโ until the automatic change at the end of the month happens, can you help with this we are still lost how to resolve this issue. is there a solution?
The best way to set the enum fieldโs value to โNoโ automatically at the end of each month is to create a Report (also known as a โScheduled Ruleโ). The Report will run on the day and time you specify. The Report can invoke a Data Change action that sets the enum fieldโs value to โNoโ.
See https://help.appsheet.com/en/articles/953605-workflow-and-reports-the-essentials and https://help.appsheet.com/en/articles/961724-reports
After the Report sets the enum fieldโs value to โNoโ , your users can use the application to set the value of the enum field to โYesโ. Once the user sets the fieldโs value to โYesโ, the field will retain that value until the next time the Report runs at end of the month.
User | Count |
---|---|
38 | |
27 | |
23 | |
23 | |
13 |