Is there a way to limit a field on an updateable dashboard, where users can only enter values that exist on the udcodes table?

Hi Steven, You use a BPM directive on the updateable query to run a check on the entry before update… Here’s where update bpms preprocess and post process may be input: [image] Nancy

Is there a way to maybe it display or prefill the UDCodes so that the user doesn’t have to worry as much about mistyping the value?

Hi Steven, Yes I think so. It’s been awhile since I’ve done it in the updatable. I reviewed one I did last year and I think you need to tell the updatable query what the field is by using the field attributes editor. Here’s an example where dropdown list of buyers is provided in the updatable das…

This is also in classic and I am going to check if it is in 24.1, but on the update tab there is the advanced Column Editor at the bottom. it has the ability to reference User Codes [image]

Check out this link - very informational about BAQs and Dashboards. [image] BAQ Calculated fields insights presentation Kinetic ERP Hey Everyone, This is a recording done after the fact of my insights presentation due to the technical difficulties I had during the present…

Updatable dashboard field updates using udcode table

Kinetic ERP

LarsonSolutions (Bruce Larson) June 16, 2024, 3:09am 6

Check out this link - very informational about BAQs and Dashboards.

Topic		Replies	Views
Is there a way to limit Updatable field on Dashboard to only use UserCode data Epicor ERP 10 updatable-field-limi	1	561	March 12, 2020
Updatable dashboard in Kinetic Kinetic ERP e10	9	2865	July 31, 2023
Updating UD Fields in Updatable BAQ, Bypassing BO Epicor ERP 10 epicor , bpm , dashboard	5	1999	March 6, 2024
Updateable BAQ Dashboard Kinetic ERP ubaq , updateable-dashboard	4	747	December 19, 2022
Updatable Dashboard Epicor ERP 10 baq , dashboard , updatable-dashboard	1	654	January 25, 2024

Updatable dashboard field updates using udcode table

Related topics