Original Requestor - Override Field

[Maggie_Gilbert]

Hello,

I have calculated fields in my request form to capture the name of the person who put in the request and their home team. When this form was setup in implementation, we put a "Requestor Team Override" field that is visible to admins only, in the event we need to update the requestor team. I would like to also add a "Requestor Override" be able to also override the Original Requestor name, but I'm not quite sure what the code would look like to do that.

Here is the calculation for the Requestor Team field:

IF(ISBLANK({DE:Requestor Team Override:name}),IF(ISBLANK({convertedOpTaskOriginator}),{owner}.{homeTeam}.{name},{convertedOpTaskOriginator}.{homeTeam}.{name}),{DE:Requestor Team Override:name})

Calculation for the Requestor Team Override is a Typeahead field, with reference object type set to "Team"

The calculation for the "Original Requestor" field is:

{convertedOpTaskOriginator}.{name}

Any ideas on how to create an admin only field that overrides this "Original Requestor" field?

Thank you!!

[IvanBebek-iX]

Hi @Maggie_Gilbert 

Following the above example and guessing you want to keep similar functionality I think it could be something like this

IF(ISBLANK({DE:Requestor Override:name}),IF(ISBLANK({convertedOpTaskOriginator}),{owner}.{name},{convertedOpTaskOriginator}.{name}),{DE:Requestor Override:name})

I have wrote this pretty much blind and not aware of the system specifics you might have, please review and let me know if this works / is doing what you need? 

Best regards,
Ivan