I have created a Business Central document page with a grid component and several columns above it. These columns are not part of the grid's data table but are instead defined as global variables on the page. Additionally, I have attached two list parts to this page.
When I enter values into the columns above the grid, I noticed that the values are reset for every record in the grid.
I would like for the values entered in these columns to remain the same for all records in the grid, regardless of which record is selected.
Can you provide guidance on how to achieve this? Any help would be greatly appreciated, and I would be happy to provide additional details about the attached list of parts if needed
Thanks and Regards
Govinda Kumar
This is technical issue so better send page/parts source code.
Hi Aleksandrs,
Thanks for your suggestion. Let me give you a bit more context about my pre-allocation page. Essentially, it's a form that I use to import data from an external source. It has two main sections, Performers and Productions, consolidating the imported data, and a Find/Replace feature that works well and can handle a huge number of records.
One of the main purposes of this page is to let users select records from the grid and match them with available data in Business Central. This process includes matching/unmatching performers and productions. To make it easier for users, I've added the criteria selection section above the grid to either work with productions or performers.
The issue I'm currently facing is that whenever I select a new record from the grid, the criteria selection resets. I was hoping to find a solution that will keep the criteria selection the same for all records.
I hope that helps provide a better understanding of my pre-allocation page and what it does.
regards.
Hi, Why don't you use BC standard search/filter features on the page/grid with update button where you show another page and user enters field, new value (maybe some selection criteria) and presses update button and code does the job?
If you could export your objects and attach them I might have a look.
Hi Aleksandrs Judovs
I have four columns that I use to find and replace data in the grid. The logic works perfectly and I have tested it. However, I have noticed that when I select a record in the grid, only the page part for that specific record disappears. I would like to make the page part disappear for all records in the grid, not just one selected record.
regards
Hi,
What is the purpose of 4 windows on left top? Do you want to filter / sort / update data represented in the grid?
What exactly you wanted to achieve with this page?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,228 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156