Grabbing information based on lookup field.

Hello, 

I am trying to do something like this:

Grab information to current page, based off of value in Lookup field.

Example would be, on the current page when the User (Contact) lookup is filled in, also grab the contacts Address (String value), Phone Number (String value), and Account name (Lookup value) and fill it in on the current page. 

I am fairly sure I need to run a client side ESQ, and a few joins to get the information I am looking for, but I have not been successful yet. 

Any help is appreciated!

Like 0

Like

1 comments

Please investigate how to work with ESQ

https://academy.bpmonline.com/documents/technic-sdk/7-11/use-entitysche…

Then check the article by the link below. It shows how to select aggregate data.

https://community.bpmonline.com/questions/esq-query-find-role

Then check the next article. There you'll find how to fill in a lookup value. 

https://community.bpmonline.com/questions/update-query-change-lookup-va…

If you want to set a text or integer value, you need to use the following syntax:

this.set("fieldname", value); in a replacing client module.

Please find more information about modules in the article by the link below.

https://academy.bpmonline.com/documents/technic-sdk/7-11/adding-calcula…

Show all comments