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

[JenniferLegate]

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

[skyehansen · Accepted solution]

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]

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]

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.

[JenniferLegate]

It does work! Thank you so much!