Create a calculated field to pull in the user's access level of a user identified in another custom field on the same form | Community
Skip to main content
JenniferLegate
Level 2
April 10, 2025
Solved

Create a calculated field to pull in the user's access level of a user identified in another custom field on the same form

  • April 10, 2025
  • 1 reply
  • 520 views

Hey Community!

 

Looking for a little help. I have a new user request form where I "clone an existing user" type-ahead field, allowing the user to select an existing Worfkront user to clone to create the new user. I would like to automatically pull into a calculated field on the same form the access level of the cloned user identified in the type-ahead field.

 

Any thoughts on how this can be accomplished?

 

TIA! 

Jen

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by skyehansen

I think you would just have to put a calculated field on that same form, to pull in that information. You'd have to test, but example code might be something like 

{DE:Your typeahead field}.{accessLevel}.{name}

1 reply

skyehansen
Community Advisor and Adobe Champion
skyehansenCommunity Advisor and Adobe ChampionAccepted solution
April 10, 2025

I think you would just have to put a calculated field on that same form, to pull in that information. You'd have to test, but example code might be something like 

{DE:Your typeahead field}.{accessLevel}.{name}
JenniferLegate
Level 2
April 10, 2025

Thank you for your response. Yes, I would want the calculated field on the same form as the "Existing User to Clone" field.

 

Using your example code, I entered the following:

 

{DE:Existing User to Clone}.{accessLevel}.{name}
 
However, when I test, I get "N/A" in the calculated field, before and after entering a user in the Existing User to Clone field. 
skyehansen
Community Advisor and Adobe Champion
April 10, 2025

It's working fine for me. I think if you've checked the box on the field for "Apply to existing calculations,"  and still can't get it to work, you should just get your authorized service contact to submit a case to Workfront Support.