How might I copy a Contact table subrelationial field to the Submitter?

Some time ago, I tried and failed (twice) to create an appscript or javascript that would copy a Contact table subrelational field I called User Name (first last) to the Submitter field.

1) Submitter A submits Item A into Project A. The Submitter is captured by Contact Record subrelational field 'User Name' (first last).

1a) Other times, Submitter B submits Item A on behalf of User A. In this case, Submitter B selects User Name from its drop-down list.

2) User B submits Item B with a subtask transition) into Project B from Item A.

2a) Item A's Submitter is the appropriate owner of some states in Project B--not Item B's Submitter.

3) The goal is to change the submitter for Item B, therefore, to User Name, assuming it's always a match. Speaking of that, there must be a script way to obtain the correct Submitter name from the Contact record, so that I'm not scripting a mechanical copy.
  • Thank you everyone; you all mentioned mapping and it worked. I'll keep the script in mind if a tech submits a ticket for a user, and then submits into Project B.
  • If you can follow this:

    I think it's likely I mapped Submitter to Submitter some years ago, but then removed the mapping because we have many external users to avoid license saturation, and they can only submit to Project A.

    In the probably rare case that Help Desk ticket is submitted by an External user who cannot own items and can therefore only submit Help Desk tickets, only the Issue Resolved (Oncall Certification) button is visible, not the ‘Issue Resolved’ button, because an External original Submitter can’t own the User Certification (WR) state.

    Because of that, I can’t bring the original Submitter over.

    I think the solution is to have only the Secondary Owner ‘Dept Members’ own User Cert (WR), as they do now in SBMTEST, with no Primary Owner. Unless an Oncall member changes the Business Unit (upon which the Dept Members are dependent), the Submitter would be part of that department, and see the Approve and Reject buttons.

    The Submitter would still get notified, because Notification can be based on Submitter instead of Owner. The name of the Submitter won’t show up as the owner of the State in the State Change chevrons on top of the form, but instead of ‘(None)’, I can have the placeholder user ‘Submitter’ display as the owner. It’s still better than having the name of the Tech show up as the owner.

    The best scenario is that I demonstrate to my manager that our licenses never approach saturation, and make all the External users regular users.