I have an updateable dashboard with a column that is populated with a dropdown from a separate BAQ. The dropdown works great to update the OpCode, but this update does not trigger an update to the OpDescription which retains the old OpDescription. Is there a way to map the dropdown to write to both the OpCode field and OpDescription?
Screenshot of the query below:
Yes. For that field turn on Events and use the Update Table by Query BPM widget in the Field Change event to lookup the OpDesc.
This was very helpful. Unfortunately, I realized my BAQ is not going to work as it allows the Operation to be an Operation that does not exist on the job.
Is there a way to pass a BAQ parameters from a dropdown list? I would need to pass the Job and AssemblySeq so that the dropdown list is a valid list.
That will require that dashboard be deployed and then in developer mode you can filter an EpiCombo with values from other fields in that record.
Thanks, Jason! I’ll give that a try.