Data entry for for voice mail system.

  • Profile Image
    srgsng25
    Asked on August 10, 2016 at 06:03 PM

    We are building a voice mail intakes them for our homeless shelter incoming voice mails for a wait list system.  This will be a closed system where only 2 or 3 people are entering Data for the whole organization.  i am needing help with 2 aspects

    1 duplicate phone numbers we want to log how many times that person has called "this might need to be handled in the excel side with some data validation and dup validating

    2.

    updating of old data without a email like needs to be pretty easy as we don't have tech savvy people work for us "like email is a mystery"
  • Profile Image
    Chriistian
    Answered on August 10, 2016 at 11:39 PM

    To see how many times a person has submitted the form using the same phone number, you can go to your form's submissions page and filter the submission by searching for the phone number. From there you can see the number of submissions made using the same phone number.

    Then to export the data to excel, please follow this guide: How to Export Form Data to Excel

    We also have Google Spreadsheet integration that you can use to automatically send the submitted data to a google spreadsheet: How to Integrate Form with Google Spreadsheet

    To better assist you and to avoid any confusion, I have moved your second question to a new thread. You can check out that thread by following this link: https://www.jotform.com/answers/903449.
    Regards.