Change field on screen based on another field's value

Kinetic ERP
, ,
1

I am trying to solve the following:

  1. User enters a value into a field on the screen (FIELD A)
  2. User leaves field (OnBlur??) (FIELD A)
  3. Lookup is performed on a dataview using value of original field (FIELD A) as parameter to find row in dataview
  4. Value of field in dataview based on lookup is applied to another field (FIELD B)

In essence, I want to bind the value of FIELD A to the value of FIELD B; enter a value into FIELD A, exit field, FIELD B populated with value based on FIELD A.

2

This example would basically replicate the changing of ConProjMgr on a Project and seeing the ConProjMgrName updated corresponding to the value entered in ConProjMgr

3

Maybe I’m misunderstanding but it sounds like you want a row rule. When Field A is not null set column value of Field B to = Field A.

Or better yet, when Company <> ‘’, then run the action. That way it will clear also when you clear Field A.

4

I’m reading this slightly differently. It sounds like the Value of “A” is being used to query a different data source and pull back a different “value” for “B”.

So… “A” <> “B”… “A” is used to lookup the value of “B”.

If this is correct, I’m thinking of an example like Sales Order Sold-To Contact.

User picks a Sold-To Contact from the dropdown list. The “value” of this selection is the OrderHed.PrcConNum.

An event fires (ColumnChanged_OrderHedSoldToContact)…

image
image714×236 12.1 KB

This performs a rest call using the Erp.BO.SalesOrderSvc - ChangeSoldToContact which sends:

The updated value of PrcConNum (Field “A”) and pulls back new values for various display fields like SoldToContactPhoneNum (Field “B”) and SoldToContactFaxNum (Field “C”).

In this example case, I think the rest call service is sending the entire dataset back and forth in the Request/Response.

Anyway… if you can find an example of what you want… you can follow the event sequence in debugger (like I did above) and then try to replicate it in your own events in your use-case. Or… if you can give us more details on what you need, we can try to help in more detail. But it may depend on the SOURCES of values for A & B. Where are the values of “B” being sourced and stored? A BAQ and BAQ Dataview? An Epicor table which can be set via rest call (like the above example)?

5

After re-reading this, I’m withdrawing my suggestion. I don’t know what I was thinking lol. If they are both bound to the same field, you don’t have to do anything. Your request is obviously not that. It’s two separate fields that should update together. So yeah my intial thought doesn’t make sense.