Good day,
I have a table called Candidate Data where two columns are important: Candidate Name (trinidafrank23gmail.com) that is a text column and Date of Submission (April 25, 2023). I also have another table called "Individual Requests Tracker" where I want to disclose Date of Submission to Date of Submission (from Date of Submission). I was wondering if there is a way to reflect the field "Date of Submission" on the Candidate Data Table " to the Individual Request Tracker Table field "Date of Submission (from Date of Submission)"? What is happening right now is that it creates a new record which should not be. I only want specific records from that Candidate Data, then to match with Candidate Name and Candidate Email ID in Individual Requests Tracker? Is there like a possible script or automation that I can develop?
Thanks