In Classic we can right click a part number and open with any of the built-in forms, or any of the custom forms we made and added to Context Menu Maintenance. Not so easy in Kinetic.
This is the process that worked for me:
First create the BAQ to return the values you want to see in the dashboard. Don’t apply the part number filter here. Leave it wide open.
-
Create a new App Studio Dashboard using the wizard.
-
Add the BAQ and a grid view. Dont add controls or filters.
-
Add a dataview called TransView. Dont make any changes, just save it.
-
Add a textbox to the grid header, call it PartNum. Epbind it to TransView.PartNum.
-
Set the grid BAQ Options like this: Notice the single quotes around the part num. The JobAsmbl_PartNum is the value I am trying to match in my BAQ. If your BAQ uses Part.PartNum instead, make sure you change this.
- Edit the window_event, Event: window after. Add a condition:
With the expression: context && context.initialValueIn && context.initialValueIn.ValueIn
7. Add a row-update on the True branch:
With the expression: “%session.context.initialValueIn.ValueIn%”. Notice the double quotes here.
- Add the event to refresh the form when editing the part number field. This is a DataView: TransView Column Changed (PartNum). And the next event is pointing to the refresh event that the wizard created for you.
-
Save, Commit, Publish.
-
Add menu item (process) for new App. Use Menu Maintenance.
-
Using Context Menu Maintenance, add context menu item for Part Entry form to point to new menu process item. Note here that the process ID is the Menu ID from the previous step.
Now the part field has a new context menu item “KineticRunBefore”. This should open and filter the dashboard based on the part number you right clicked on.
Inevitably this process won’t work for you. This is Kinetic after all, and if you haven’t given your daily blood sacrifice, you are getting anything! When the process fails, don’t try to get your borked app working. Cut your losses and delete it. Starting fresh often results in a cleaner form in the long run. I started this process over at least 5 times, creating 5 dashboards before I finally got it going.
Good luck!
Nate
