Update Column Titles in Dashboard After Parameters Are Entered

Kinetic ERP
,
1

I have a dashboard that updates the column titles based on the current date for a rolling 12 month period - for example, Assume that today is 1/5/2026. Current month would be Jan 26, previous month would be Dec 25, then Nov 25, etc. However, I have a BAQ/dashboard with a date parameter that is passed in and I want to update the titles based on that parameter date.

The problem I am running into is that I can’t seem to find an event to hook it to. I tried to add it to the existing Get event that fetches the BAQ data. I also tried to do an event next. Then I also tried to override the native event and create my own new event. None seem to allow me to hook my column title update event up after the BAQ runs. Any ideas what else I could try? I also tried a column changes event and hooked it to the date column in the BAQ as well as view changed/changing events. I even tried to do a trace but I can’t seem to find any useful event to tie it to.

2

It sounds like you have the BAQ set up in the provider model section of the grid, which populates the grid without triggering an event.

What you want to do instead is bind the grid to a data view with no BAQ in provider model, and set up an event to populate that data view manually with a kinetic-baq call in the event.
You will need to provide your own events for refresh, etc. (I usually put the BAQ get in an event with a blank trigger, and call it from form_onload and a refresh button)

1 Like