Populate catalog variables from custom table

[Rob Bendorovich]

Hello,

I have a custom table with 5 columns. The 1st column, Group(Entity) Name is configured as a Lookup Select Box on the Catalog Request. When the correct group name is selected, I would like to have the other column data (Entity number, Contract Signed, and Expiration Date) that matches the Group name populate the associated catalog varaiable fields.

See example below - if Alamance Eye Center is selected as Group(Entity) name, would like to have highlighted fields automatically populate the associated variable fields on the Catalog Request.

Would appreciate any assistance in making this happen.

Thanks!

[AnirudhKumar · Accepted solution]

May I suggest an easier way to do this?

Change your Group(Entity) Name field from Lookup selectbox to reference type

Next, open the fields that you want populated. You will see tab called Auto-Populate. Pick the first field in the Dependent question, and in the Dot walk path field set the appropriate values.

No need of writing any script😊

[Rob Bendorovich]

Perfection! Appreciate you, AnirudhKumar!