Can I dot walk between sys_user and a custom field on cmn_location table?

Lon Landry3 · ‎02-24-2022

Need to populate catalog variable with item Requested for & custom field from cmn_location table.

shloke04 · ‎02-25-2022

Hi,

I would suggest there is a easier and no code option available OOB which you can use to auto populate this.

Please find the steps below:

Navigate to your Catalog Item and there is a Related List named "Catalog Data Lookup Definition" as shown below:

2) Click on New button as shown above:

3) Click on new button in Related List "Catalog Matcher Variable Definitions" as shown below:

Now Configure this as shown below:

Now click on New on the other Related List where you can set the values you want as shown below:

Catalog Setter Variable Definitions:

Now just set the variable values which you want:

Here I have set Email. Similarly you can set other variable from User Table

Result:

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

View solution in original post

Lon Landry3 · ‎02-25-2022

Thank you trying now!

shloke04 · ‎02-25-2022

Sure @Lon Landry

If you are stuck then do let me know and will assist you further.

Regards,

Shloke

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

Lon Landry3 · ‎02-25-2022

Or maybe I need to somehow populate cmn_location data in variable first? (somehow, back to square 1)

shloke04 · ‎02-25-2022

What I have understood from your requirement is as below:

1) Say once a user select Requested for value then we need to fetch a value from Location table and populate that in a different variable?

Is this correct?

If yes, then the above logic will definitely work and if it is not working can you please provide some screenshot similar to mine what you have configured and I can help you out here to get to a solution here.

Regards,

Shloke

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke