I need some help.
I created two fields. The first one is ‘Requested by’ and the second is’ Requested by email’.
I created two corresponding value lists for these fields.
First, the names of the people making the purchase order requests and second, their email addresses.
The ‘Requested by’ field holds the name of the person who is making the purchase order request and the’ Requested by email’ field is the email of the person who is making the purchase order request.
I would like to automate the ‘Requested by email’ field to automatically fill in the email address of the person making the purchase order request.
So, in other words, I need the corresponding email address to automatically enter when the name in the ‘Requested by” field is selected.
This email field will be used for sending a copy of the purchase order to the person who created the purchase order.