Serial Number Query from google heet
Budget: $10 – $30 USD
I have a list of serial numbers, which are written on column A of a google sheet.
And on the other columns there are several information connected to this serial number on column A, for example some dates, names etc on the same row.
I need a simple query. When a user enters his serial number on our website into a blank form field and click search, if the serial number is in our google sheet column A, informations on the other columns with the same row will be given on the screen. First row is the headers, so information will be displayed like "Serial: ...., Date: ....., Username:.... etc." given that here Serial, Date and Username are on the top row.
I will need to change these informations on the rows and also the headers, so query should take the headers and the information according to the google sheet.
And on this search form field on the web page, I also need a button to access the camera of the device (if web page is accessed from a mobile phone, camera of the phone) and read a QR code for easier data entrance for the user. Because these serial numebers are on the products with a QR code on the side.
If the serial written on the box is not in column A, then a specific text (which can be modified later) can be written on the screen like "your serial is not in our database"
I do not want the google sheet to be readable by everyone, and only the information on the same row of the given serial number should be displayed, not other serials and information should be shared.
Headers will be changing, information will be changing, and new rows will be added to the sheet occasionally.
I want this to be integrated on any webpage, so I need a good solution to my needs.
Solution must not be taking the data from google sheets, but otherwise, data entrance should be easy.
Thank you.
And on the other columns there are several information connected to this serial number on column A, for example some dates, names etc on the same row.
I need a simple query. When a user enters his serial number on our website into a blank form field and click search, if the serial number is in our google sheet column A, informations on the other columns with the same row will be given on the screen. First row is the headers, so information will be displayed like "Serial: ...., Date: ....., Username:.... etc." given that here Serial, Date and Username are on the top row.
I will need to change these informations on the rows and also the headers, so query should take the headers and the information according to the google sheet.
And on this search form field on the web page, I also need a button to access the camera of the device (if web page is accessed from a mobile phone, camera of the phone) and read a QR code for easier data entrance for the user. Because these serial numebers are on the products with a QR code on the side.
If the serial written on the box is not in column A, then a specific text (which can be modified later) can be written on the screen like "your serial is not in our database"
I do not want the google sheet to be readable by everyone, and only the information on the same row of the given serial number should be displayed, not other serials and information should be shared.
Headers will be changing, information will be changing, and new rows will be added to the sheet occasionally.
I want this to be integrated on any webpage, so I need a good solution to my needs.
Solution must not be taking the data from google sheets, but otherwise, data entrance should be easy.
Thank you.