web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Change the value of Op...
Small and medium business | Business Central, N...
Active Discussion

Change the value of Option Field automatically after few days

(0) ShareShare
ReportReport
Posted on by Dynamics Business C... 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 

  • sVerme Profile Picture
    sVerme 120 on at

    Create a Job Queue with a codeunit.

    Filter on the Unsolved values, and check the dates, modify if more then 3 days ago

  • Inge M. Bruvik Profile Picture
    Inge M. Bruvik 1,161 Moderator on at

    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.

  • Dynamics Business Central Profile Picture
    Dynamics Business C... 50 on at

    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

  • Ben Baxter Profile Picture
    Ben Baxter 6,824 Super User 2026 Season 1 on at

    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 Profile Picture
    Inge M. Bruvik 1,161 Moderator on at
    [quote user="Dynamics Business Central"]

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,055 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,063 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 1,014 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans