You read my mind with my question: how to select fields to add them to the page! Great video, really good explanation and way better than the theory from the 'books'.

Thank you, Erik. I am also looking forward to the new version of your book. And... could you video about the permissions of BC, including the setup on BC and programming in AL?

Nice overview, these are poorly documented and I tend to get confused with TableRelation/Lookup/Drilldown/AssistEdit and their different behaviors and triggers - most of the time I need to either publish a quick test page to try them out or find an older page utilizing all of them, just to recall the difference. Lookup is the only one where the trigger gives you a reference to the current field value, etc.

Thank you for sharing this. It is very helpful and complete.

@Hougaard

3 жыл бұрын

Glad it was helpful!

Have a good Time, Eric. Thank you for your effort trying to teach us BC Developing. Wish you will add some videos which makes this free video kourse more structured and easy to follow.

@Hougaard

2 жыл бұрын

What? (what free video course?)

@user-gg3yh4xb6v

2 жыл бұрын

@@Hougaard your video guides , as seemed to me.

Thank you Erik. This was very helpful. I have one question. I created a table and want to use this table for my lookup. I am finding that I can only see PKID when selecting the dropdown. Is there a way to span fields so they are viewable in the dropdown? I want to include a description field.

@Hougaard

6 ай бұрын

kzread.info/dash/bejne/f3-nrpSIhKyXf9I.html

Thanks Erik, for this video :)

To bad you cannot create lookup for fields that are in the base tables. You can only add tablerelations to it.

Sir, I am big fan of you . I would like to get your book (Microsoft Dynamics 365 Business Central Field Guide) . I am looking for the latest version of the book for Business Central 2021 Wave 1. Is there any updated version of your book available for sale ? Please reply . Thanks.

@Hougaard

3 жыл бұрын

The Field Guide for v18 is in the works and will be release about the same time as v18. You can find it on leanpub.com/dynamics - You an also purchase now, and just download the updated version when that comes out. The paper version is available on amazon and the v18 book will be available on amazon later in April.

Hi! You have mentioned, that you cant access header field from line field... That is the issue im facing. I want to create a line, then write some value into a field of this line, then store this value into its header. Then next time im creating another line, i want to look up from header what was the value, increment it by 1, write value into a field of this line, then store a new value into its header back again... Writing global variables seems not to work aswell, since values are removed from stack. How would you go about that?

@Hougaard

Жыл бұрын

You can access the record of the header, you cannot access the header page and functions on that page.

@artemkeller2571

Жыл бұрын

@@Hougaard how would you do that? Trying to figure it out for two days by now :(

@Hougaard

Жыл бұрын

@@artemkeller2571 SH.get(SL."Document type",SL."Document No."); SH.field := updatedvalue; sh.modify();

@artemkeller2571

Жыл бұрын

@@Hougaard thank you! I will definitely try it out tommorow!

Hi, do you have any Idea how i filter the lookup with two filters on one Property? i want to show all the records where "Asset Type" empty or my "Posting No.".... "Asset Type" = filter( ' ' | "Posting No.") does not work unfortunately. 🤔

@Hougaard

11 ай бұрын

In code or in a property?

@realeques

11 ай бұрын

@@Hougaard in a property but I'm now aware that it's not possible so I did it in the onlookup trigger unfortunately I now don't have a drop down menu anymore 😂

@Hougaard

11 ай бұрын

@@realeques Yeah, that's the challenge!

Really very nice video on Lookups, Need one help, If we like to popup a lists with non database value like Current Month, Previous Month and Next Month as Month, Year format. How can we achieve that in Page

@Hougaard

3 жыл бұрын

Check this video kzread.info/dash/bejne/dJmKqLZriNC5Xaw.html

how can in make changes to an existing field on the page like adding new triggers to open another page after selection of an item?

@Hougaard

8 ай бұрын

Sounds like adding an Action in an pageextension?

@user-ku9er7ph2i

7 ай бұрын

Thanks it worked

Love form India

Thanks a lot for the video Erik! Do you by any chance know why Currpage.LookupMode property returns "false" on the lookup page which results from TableRelation? Seems like there is no way to tell the page is currently in lookup mode when it is from TableRelation. Yet when I run the page using a Page variable with setting Page.LookupMode(true) - then CurrPage.LookupMode returns "true" correctly.

@Hougaard

11 ай бұрын

No clue :)

Creating these filter expressions in Al is the worst. I always end up creating these filters in cside in the classic client and copying and pasting it back in vscode.

@Hougaard

Жыл бұрын

That seems futile...

Thanks for the video! Is it possibile to add a lookup with filters on a flowfilter field? I'm trying to do this on Chart Of Accounts page, having a lookup on dimension value table (filtered also when looking up). So i'm using a new flowfilter field to looking up on a DimensionValue."Code", but the problem is that i couldn't find a way to filter that table with a constant value (i.e. DimensionValue."Dimension Code" = CONST('JOB')) while looking it up. And so when i try to lookup it shows me all the table, ignoring my filter.

@Hougaard

2 жыл бұрын

Add the lookup code to the page, then you can do whatever you want.