Hi, I wanting to create a widgit that I can put in a Jotform form, used for inspecting assets at different locations.
- I want to be able to scan a barcode (1D) using an iPhone camera, or input the number.
- From there, I want it to connect to a database hosted on a sharepoint website (which is updated regularly) and matches the barcode number with the barcode number on the database.
- Information in the database would be fields such as make, model, location, year last tested etc
- Information from the database relating to the asset is then brought into the form, and the user answers questions relating to the asset (such as overall condition, upload a photo of the asset).
Is what I want to do possible? How is this best done? Using html? Or PHP?