Hey On a Dashboard we have a calculated field from the BAQ. This is simple in that is calculated formula is If Field = True, ‘open’, ‘closed’ When i add a tracker, i can select this field as a filter and manually type open, closed or delete the contents to filter the datagrid. How can i change th…

The easiest way to do this is to make the adjustment in the BAQ. Let me find a post that explains how to do it.

This one is doing basically the same thing. [image] Selectable dropdown value for uBAQ Epicor ERP 10 I can’t see the titles to know this for sure, but it looks like you are referencing the same query that you are trying to get the drop down in? You’re supposed to make a …

This ones probably a little better explanation. [image] Dashboard Tracker ComboBox weird behavior Kinetic ERP Here’s how to make a BAQ automatically give custom drop downs. This will work for the tracker filters, even if you don’t use any update functionality. [image] […

but to do that, the BAQ would need to be updatable right? Even if it doesnt need to be?

Correct. Just check the box that says updateable, Then use “Advanced BPM Update Only” so it doesn’t yell at you. [image] Then in your dashboard, you don’t need to turn on any of the updateable stuff. But the drop down will still work.

that worked. not 100% as we need but close enough :slight_smile: what i couldnt get to work: when the dashboard loads, it no longer auto populated the datagrid i couldnt preset the data to the tracker fields i needed the combo so how open, closed & nothing (empty field). The combo does this but …

[image] HeadScratcher: when the dashboard loads, it no longer auto populated the datagrid [image] HeadScratcher: I needed the combo so how open, closed & nothing (empty field). The combo does this but the BAQ wouldnt show all on the empty field. These are related. There are posts out t…

I tried the code approach, i was getting an error about csm not existng. Anyway, i updated the BAQ advanced field with % and then added that to a matches filter and it works just fine. Thanks for all of your help :slight_smile:

If you want to figure it out, post your code and your errors. csm Most definitely exists, so it’s fixable. If not, I’m glad you got to something acceptable.

Dashboard - Change textbox to combo

Epicor ERP 10

Banderson (Brandon Anderson) August 6, 2024, 8:21pm 3

This one is doing basically the same thing.