Pre-populate sign-in form

  • Profile Image
    Asked 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?

  • Profile Image
    Answered 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:

    Prepopulating Fields to Your JotForm via URL Parameters

    Let us know if you have further questions.

  • Profile Image
    Answered on January 29, 2018 at 10:43 AM
    Thanks 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 do that?
    Steve Hasselberg, Laboratory Manager
    Campbell University School of Engineering
  • Profile Image
    Answered 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.