-
heinebergAsked 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!
Page URL: http://heinebergcsc.org/ -
BJoannaReplied 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.
-
heinebergReplied on December 28, 2017 at 3: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.
-
BJoannaReplied on December 28, 2017 at 3: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