JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
is there a way to have the form auto fill some of the field once a unique number is entered that is associated with the informationAsked by Ahmed_AlGhamdi on January 04, 2016 at 11:46 AM
for example if a form user scan a barcode for barcode field, then the form is auto filled with the product part number, description, location. and all that information is pulled from a spread sheet that is somehow can be loaded to the website?
just to clarify with another example for my requirement
if I have a unique identifier for each of my customers, would I be able to use that unique identifier as a trigger to auto fill a form with their information if it stored on a db or excel file in jot form? if yes, what function or app that can perform this task?
Thank you for contacting us. Unfortunately at this time, we do not have a barcode reader widget available.
We do however have QR Code Reader Widget that can be added to your form:
You view a sample form with the widget here: http://form.jotformpro.com/form/52085457226962
If you do not need a barcode reader, you can use the UPDATE FIELD condition. Once the users enters the proper code for an item, it would automatically update the other fields. This would require you to create many condition for each item.
The other way would be to use the source code and link your fields to a database so it will automatically update does fields.
Please let us know if any of this options works for you.