web
You’re offline. This is a read only version of the page.
close
Skip to main content
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...
New 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
    RE: Change the value of Option Field automatically after few days

    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,105 Moderator on at
    RE: Change the value of Option Field automatically after few 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.

  • Dynamics Business Central Profile Picture
    Dynamics Business C... 50 on at
    RE: Change the value of Option Field automatically after few days

    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,546 Super User 2025 Season 2 on at
    RE: Change the value of Option Field automatically after few days

    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,105 Moderator on at
    RE: Change the value of Option Field automatically after few days
    [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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,602

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 3,033 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,738 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans