In classic I used dynamic combo boxes all the time in my dashboards. We often start with a user-provided value like part number from a text box. This is used to populate and filter the subsequent combo boxes. For example, when the user types in a part number and leaves that field I trigger an event …

I believe Hannah has a thread about doing something like this in Kinetic. I’ll see if I can find it in my squirreled away notes.

Guess it was Kevin L https://www.epiusers.help/t/dynamic-combo-bpm-form-proof-of-concept-kinetic-classic/103993 one of the other super smarties I crib from all the time.

Reading that solution makes me want to cry. This is all so terrible. Just terrible.

The version I did used dataviews to populate the combos. You can use a ColumnChanged event from the first combo epBinding to trigger a dataview-filter-set on the next dataview bound to the combo. Somewhere in there: BAQ Combo customization - how to convert from Classic to Kinetic - Kinetic ERP - …

Hannah’s link is the one I’d try first.

[image] hmwillett: The version I did used dataviews to populate the combos. So would I create a dataview for each unique combo box?

My BAQ that populates one of my combo boxes is a simple parameter driven BAQ: select [PartRev].[RevisionNum] as [PartRev_RevisionNum], [PartRev].[RevShortDesc] as [PartRev_RevShortDesc] from Erp.PartRev as PartRev where (PartRev.PartNum = @part) In classic I would define the parameter with this…

I created that dv for the revision combo box. called dvPartRevs. I created the event myPartNum_onBlur. I added the dataview-filter-set to this event (only fires if PartNum is not empty). I set the dv to dvPartRevs and the filter to PartRev_PartNum=‘{TransView.myPartNum}’. I can see that my part numb…

[image] NateS: So would I create a dataview for each unique combo box? Yes, and then reference the each here: [image] [image] NateS: In classic I would define the parameter with this line: qeds.ExecutionParameter.AddExecutionParameterRow(“part”, MyPartNum.Text, “nvarchar”, false, Guid.…

So I have found it cleaner and simpler to just use a text box, and then click Enable Search under advanced options. You can then configure a baq search in your on search click behavior, and preload the search filter with your parameter. Yeah I know, its not a combo.

Dynamic Combo boxes in Kinetic

Kinetic ERP

jbooker (Josh Booker) June 3, 2025, 12:00pm 16

PS - I wonder if this flag allows/disallows the built-in grid filter controls for the column?

Topic		Replies	Views
On Leave Event in Kinetic? Kinetic ERP e10	72	10648	September 9, 2022
Data Entry Form in Kinetic Kinetic ERP bpm , customization , dashboard	78	19870	November 4, 2022
BAQ Combo Box as Filter in Custom Kinetic Dashboard Kinetic ERP bpm , customization , baq , application-studio	2	7024	December 4, 2024
Cascading BAQCombos on a Dashboard Epicor ERP 10 baq , dashboard	7	2632	February 14, 2023
Filtering epiUltraGrid with a BAQComboBox Epicor ERP 10 customization , baq	17	5078	April 8, 2021

Dynamic Combo boxes in Kinetic

Related topics