50
There is requirement that, the option filed having a two value Solved and Unsolved and default will be Unsolved, so once click on action button in page after three/mentioned days the value should automatically change to Solved without opening the page, please help me out with this
Thanks in advance
Inge M. Bruvik (NorthW) Thank's for quick replay
Sorry as i'm new to Business central i wouldn't explain correctly so, Here the scenario there are two pages for one table one is administrator and other is user the administrator will click on action button and that sends a mail to user that this should mark as solved by you or it will automatically change to Solved within 3 days
[/quote]Ahh ok,
That makes sense. Then you only need the action button in the admin page.
Have a second field, that is a date field, hidden and non-editable. When the field is switched it adds today's date to your date field. Have a Job Queue batch that runs once a day and looks for records with a date older than three days, and switches them to solved. If the date field is blank, then the original action wasn't taken and the record should be skipped.
If the User takes action on the record, it should clear the date field so the system doesn't mark it as solved.
Inge M. Bruvik (NorthW) Thank's for quick replay
Sorry as i'm new to Business central i wouldn't explain correctly so, Here the scenario there are two pages for one table one is administrator and other is user the administrator will click on action button and that sends a mail to user that this should mark as solved by you or it will automatically change to Solved within 3 days
If you want it to be done without opening any page you will have to make a batch job that updates the status. And run that batchjob in a job queue.
But there might be something i do not understand here. Because in order to have a action button you have to place that action button on a page.
#1
André Arnaud de Cal...
294,261
Super User 2025 Season 1
#2
Martin Dráb
233,004
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
