Users just love Lookup FlowFields in AL and Business Central

[@nemanjavelickovic9062]

Hey Erik, thanks for the nice educational video. Visual Basic was very nice introduction to programming, but when I revise old code, these forms look so ancient. Keep with the great work, all the best!

[@bendolman6419]

Impeccable timing EH! Was about to look into putting Job Numbers on the Sales Invoice List page and this was almost a copy and paste solution 🤘

[@bendolman6419]

EH (or anyone else), I'm getting a "The supplied field number '45' cannot be found in the 'Job' table" when clicking on the Job Number FlowField link, when I specify "DrillDownPageId = 88". Any advice appreciated 🙏

[@MagnusPettersson-d5o]

So how can editable flowfields be used nowadays? It was, or are maybe still used on Budget entries but are there other use cases for them?

[@npu3paka2]

This looks simple and very effective.

[@bernochristensen]

Hi Erik think you have some great videos, could you in near future look at the new Copilot prompt type?

[@Hougaard]

There's already a video on that :)

[@bernochristensen]

@@Hougaard missed that will find it right away 😊

[@bernochristensen]

​@@Hougaard Found it and you steered right around the issue of getting actual AI generation of content which I have the most interest in and find most challenging and hoped to pick up some tips on :)

[@cptnraptor]

I still think it's a weird... politeness? courtesy?... to older developers that these pages are still called * Subform, given that in the AL development environment there is no schema update when renaming pages. It's probably more a compatibility reason it's not renamed, but none the less MS could just hit a big red button and say "Nah it's * Subpage now, we're big enough not to care about your broken dependency"

[@ant1d0te]

Cannot figure out what would be the benefit to have several flowfields in one table having the same formula?

[@Hougaard]

To get more than one field.

[@ant1d0te]

@@Hougaardstill do not see any meaningful business value in this, do you hve an example by chance?

[@MagnusPettersson-d5o]

It's not "exactly" the same formula but ex: to show several fields from one Item record like Description, Description 2, Gross Weight, Net Weight, Unit Volume, Durability etc...

[@nemanjavelickovic9062]

The business value is, I guess, visible when there is a lot of entries, and the field is only needed for one particular case. It will save you space, and maybe will improve response time from the SQL @@ant1d0te

[@mauriciovillatoro9361]

I give up on FlowFields, too many issues.

[@Hougaard]

What issues?

[@mauriciovillatoro9361]

@@Hougaard Hi Erik, "I'm comparing them with The Virtual fields. With that being said, I had these issues: You can’t do nothing (*, +, /) with the returning value; you cannot make the field a normal field again, it needs to stay as FieldClass = FlowField; it cannot be used to filter a record (at least I couldn’t find a way to do it); you need to keep them in mind to recalculate them when working with records; you cannot use variables to filter them. (My apologies if these are just a lack of knowledge on my part)."