Auto update a value in one component based one user selection in another component

[Peter_Hageso]

Hi there I want to use an eventhandler to auto update the value in component B named customer_region (A gets data from my customerDB eg cell customer_region), based on the selection in component A customer_name ( gets data my customerDB eg. celle customer_name. How is this done? I have a simple qurey that match customer_name and customer_ region.

Thanks

[ScottR]

Use a change Event handler for A that will then set the value for B using bFieldName.setValue('newValue')

[Peter_Hageso]

Hey ScottR,

Can you provide an example?

[ScottR]

In the inspect panel for the select component A, add an Event Handler that will run a query on Change

When that query is complete you should add an Event handler in Succcess for Control Component and set the value from the query you just ran.

[Peter_Hageso]

Hey ScottR,

I am not sure how the "set value" statement should look.

[Peter_Hageso]

I am not sure how to use the xxxx.setValue('newValue') could you provide an example.

/Thanks

[ScottR]

yourFieldName.setValue('somevalueherethatyouwantset')

[Peter_Hageso]

They value, that I want to set have to come from my query. eg. I have query that joins my customer tabel eg. customer_name with a tabel of possible municipalities eg. customer_municipality, I want to show the customer_municipality as the value in fieldB

/Thanks

[ScottR]

yourFieldName.setValue(yourQuery.data.customer_municipality)

Though I don't know what yourQuery.data looks like

[Peter_Hageso]

Here is an example

[ScottR]

So, for customer municipality field you can simply add
{{getDataCustomerMunicByCustomeName.data.customer_municipality}} as the source.

[Peter_Hageso]

/ Thanks

[ScottR]

This one:

For Value put in {{item.customer_municipality}}
For Label put in {{item.customer_municipality}}

[Peter_Hageso]

@ScottR

{{getDataCustomerMunicByCustomeName.data.customer_municipality}}

Great and where to put {{getDataCustomerMunicByCustomeName.data.customer_municipality}}?

[ScottR]

Just use the query name.data as the source and then add item as noted above