How to Auto populate a Catalog Variable based on other Catalog Variable's choice option.

Blitz · ‎07-19-2023

Hello, A Script that can auto populate this Catalog Variable based on other Catalog Variable's choice option.

(Assume Name: position)

Data that will be Pull is: Title in (sys_user table)

Conditions:

Note: (Assume name: do_you_need_to_create_new_user)

If

then it will pull data from (requested_for) variable which is referencing the sys_user table

Note: This variable is in a variable set (variable set name: req_detail)

but the data will be pulled is the "Title" field value of the (requested_for) which is inside the sys_user table.

The Data must be stored here (auto populate):

As for the other condition

If

then pull data from (confirm_existing_acc_owner) which is referencing the sys_user table but same data will be pulled

Data: Title

Data will populate here

This Questions includes: Script Include, Onload Client Script, OnChange Client Script

Whatever changes in the options (Yes/No) the "position" variable must also follow (auto populate with the right Data).

Community Alums · ‎07-19-2023

Please go through the thread and make the adjustments as per your requirement :

Arun_S1 · ‎07-19-2023

@Blitz You can manage this with the help of Catalog Data Lookup Definitions.

Create a catalog lookup definition

Matcher which will query the sys_user record based on the selected requested_user

Setter to populate the details from the retrieved sys_user record to the catalog variables

Result:

Please mark the appropriate response as correct answer and helpful, This may help other community users to follow correct solution.

Arun_S1 · ‎07-19-2023

@Blitz You can also refer to this article about using Catalog Data Lookup Definitions

Please mark the appropriate response as correct answer and helpful, This may help other community users to follow correct solution.