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

Forum|Forum|11 months ago
April 10, 2025
1 reply
519 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

Workfront

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}

skyehansenAccepted solution

New Participant

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}

JenniferLegateAuthor

New Participant

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

New Participant

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.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded