I'm trying to create a 3-step, or 3-page, Production Order for commercial production. One page would be for client info, one for script details, and one for editing details for each commercial.
I have it set to automatically take the user to the next step once they hit submit. So each step (Parent Row, script, each edit) gets its own line on the sheet.
However, the AE is having to select their name and enter their client's name on every page to get it to match up back on sheet view. Is there a way to auto-populate the "Client Name" field and Contact List dropdown from the previous entry?



