Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / How to set Forward and...
Microsoft Dynamics NAV (Archived)

How to set Forward and Backward Buttons in navision pages like Nav 2009 r2?

(0) ShareShare
ReportReport
Posted on by Community Member

hi all 

i have an small issue i am creating profile calender for every employee for that i want to create a matrix page 

i alredy done a matrix page design but here is problem with year field in page see this below image

see this year properties

year-properties.png

here minvalue,maxvalue is declared in properties window

and see this image in nav 2009 r2

year.png

here forward and backward buttons to move the year in between 1 to 9999

here is my doubt is how can i design this one in Nav 2015?

here i can get current year but how can i move it from forward and backward ?

is there any lookup possibility?

Can any one suggest me please.....

Regards,

Ramesh.

*This post is locked for comments

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    RE: How to set Forward and Backward Buttons in navision pages like Nav 2009 r2?

    Thanks archer,

    I have a small Doubt in this you specify a Date Variable in below of above post where you can use this Date Variable.

    once again thanks before this post you suggest me use Date and Integer Tables i am trying this code

    DateG.RESET;

    DateG."Period Type":=DateG."Period Type"::Year;

    DateG."Period Start":=010101D;

    NewDate:=DateG."Period Start";

    //DateG."Period End":=01019999D;

    FOR i:=1 TO 30 DO BEGIN

     IF Flag THEN

      NewDate := CALCDATE('<1Y>',DateL);

      //DateG."Period Start":=010101D+;

      DateL:=NewDate;

     year:=DATE2DMY(DateL,3);

     MESSAGE(FORMAT(year));

     Flag:=TRUE;

    END;

    But here i used For loop so it gives me last date at last.

    Regards,

    Ramesh.

  • Verified answer
    keoma Profile Picture
    keoma 32,675 on at
    RE: How to set Forward and Backward Buttons in navision pages like Nav 2009 r2?

    to get a dropdown with year values you could do following:

    add a field in the page with source YearValue, datatype integer (global var.).

    set properties for that field:

    NotBlank=Yes

    TableRelation=Integer.Number WHERE (Number=FILTER(>=1970),Number=FILTER(<=2020))

    Drilldown=Yes

    result:

    6746.year_2D00_dropdown.png

    Integer is a virtual table with object id 2000000026, Date is also a virtual table, has object id 2000000007.

  • Community Member Profile Picture
    Community Member on at
    RE: How to set Forward and Backward Buttons in navision pages like Nav 2009 r2?

    Hi archer,

    Can you please explain little bit more and any sample code for that one and object ids in nav 2009.

    Regards,

    Ramesh.

  • Suggested answer
    keoma Profile Picture
    keoma 32,675 on at
    RE: How to set Forward and Backward Buttons in navision pages like Nav 2009 r2?

    to fill the field with filtered record values you could use virtual tables integer or date. with that you get then a dropdown for selecting. to get that kind of control as in nav 2009 develope an control addin.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,407 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans