Build in duplication log and server time

Good Afternoon,

I have two questions regarding my company's forms.

1. We have a syndication with Google Sheets and it is one hour behind. I noted that the form itself has the correct time, however, when I go to "view form submissions", the time is off by one hour.

2. The form is for agents to claim listings on our website. Is there any way to build login that looks for past submissions that contain the same address and include this information in the email that gets forwarded?

ie - 1st submission would be: 5 East 14th 

      2nd submission would be: 5 E 14th Street   

      The logic could be does past submissions[address] contain this.forms['address']. I don't want it to look for an exact match because the address could be written different. If is does find a match, the email would reflect a possible duplicate submission and alert a manager to check the spreadsheet.

Thank you for any assistance.

No need to open multiple threads for the same matter, we already assisted you here: https://www.jotform.com/answers/1778302 

Please post your follow up reply there.