Using forms for check-ins and tracking?

  • Profile Image
    heineberg
    Asked on December 28, 2017 at 11:26 AM

    Hello,

    I'm wondering if there is an app or widget you could suggest that would allow us to use forms for our participants to check-in. And these forms, if possible, would recognize and compile participant names t o save in one spreadsheet. I understand that may be a stretch...

    We are a non-profit senior Center and for our funding grants we need to track activity and individual participation. I know this is not the intended use of the forms, but thought it may be worth asking if you knew of a way to get there with add-ons.  We love the reporting/analysis option, it would save us a great deal of time for this use as well.

    Thank you!



  • Profile Image
    BJoanna
    Answered on December 28, 2017 at 12:28 PM

    I am not exactly sure what are you trying to achieve. 

    I am not sure for what do you need check-in but, we have the Check In Check Out widget that you can check. 

    You can also use a basic Date Picker field to allow your users to check-in. 

    The form cannot recognize the user, but you can pre-populate your form with the users data and provide them a pre-populate link. You can create a separate pre-populate link for each of your users. This can be done with pre-populate app - http://prepopulate.jotform.io/ 

    You can download your data as Excel, CSV or PDF:

    How to Download Form Submissions as Excel/CSV/PDF

    It is also possible to integrate the form with Google Spreadsheet:

    How to Integrate Form with Google Spreadsheet

    If I did not understand some part of your question correctly, please explain in more details what are you trying to achieve. 

    Let us know if you need further assistance. 

  • Profile Image
    heineberg
    Answered on December 28, 2017 at 03:13 PM

    Thank you, the date picker field will work, but I need to integrate on the backend with a database. I should have asked it that way, does Jotform integrate with any database? Currently we use Obvibase. We need more than just a spreadsheet.



  • Profile Image
    BJoanna
    Answered on December 28, 2017 at 03:34 PM

    It is possible to send Submissions to Your MySQL Database Using PHP. Inside of this guide , you can find how to do it:

    How to send Submissions to Your MySQL Database Using PHP

    You can also use a Webhook: How to Setup a Webhook with JotForm