- shasselbergAsked on January 29, 2018 at 06:01 AM
I would like to create a sign-in form for a makerspace. I would like the form to recognize a users id from (a mag swipe) and pre-populate certain fields based on a table look-up. Is such a thing possible?
- JotForm SupportAdrianAnswered on January 29, 2018 at 09:58 AM
Unfortunately, you cannot get input from a magnetic stripe card directly in a form.
You can pre-populate the fields via URL Parameters.
The following links might help you:
Let us know if you have further questions.
- shasselbergAnswered on January 29, 2018 at 10:43 AMThanks for the reply. I don’t thing getting the mag swipe (or barcode) data is difficult. There are many devise that will just read the data into the current field. The hard part, as I see it, is poplulating the form.
With the links you sent, it seems that you need to know what to populate the fields with. I want it to read an id, look up the user in a spread sheet, and then populate the form from other data I the spread sheet.
Will the prepopulate.jotform.io do that?
Steve Hasselberg, Laboratory Manager
Campbell University School of Engineering
- JotForm SupportAdrianAnswered on January 29, 2018 at 12:16 PM
Yes, you will need a device to get the ID from the card.
After that, you are gonna need an application that fetches the users data from a database (spreadsheet) based on the user's ID. This application would also create the prepopulated link with the corresponding data of the user.
You cannot do that with JotForm without some custom programming.