I have been asked by my boss to create a system to control tools being "borrowed" from a storage area, the idea is we capture the following info:
Date & time stamp
I then look up a list of user ID's and tool ID's, from there I populate who the user is and what too they have taken out. Same when they return the tool. The area is self-service and not manned.
Currently, I am doing this with Google Forms and Sheets, but the search api for sheets has limitations, mainly "lookup" returns junk data if the list is not sorted - if a tool has been taken out several times, there are a few entries and looking up the last person to take it is unreliable, despite trying many ways using the Google API calls.
I have access to intranet storage, so can I create a stand alone system using web pages and build GUI's for the pages with any tool that's available for free online till I know it works? I don't have a webserver, I hoped to use a link to the webpage and have it store the blobs locally. Not a lot of data in the lists.
In the old days, I would have written a desktop app in VB but we are not allowed to use non-approved windows software applications in this company.
What I have tried:
Searched Google high and low, nothing seems straightforward - no access to a webserver to deploy this, I want it to work in similar fashion to a VB app - local file storage etc.