Build in duplication log and server time

  • Profile Image
    BondAdmin
    Asked on April 01, 2019 at 02:00 PM

    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.

  • Profile Image
    Kevin_G
    Answered on April 01, 2019 at 02:45 PM

    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.