So, I've created a form of sorts in Google Sheets. No, I don't mean a Google Form linked to a spreadsheet, I mean a literal form created directly in a Spreadsheet. Picture for reference:
I've already coded it so the input values get stored in all the tables needed, and the needed documents and other files get created when you push the "REGISTER" button, so it's already working as intended.
The problem is it can only be used by one person at a time. In the past, when I had this situation come up, I would just make enough duplicates of the spreadsheet and set it to be only usable by a specific user each, meaning I'd need as many duplicates as there were users. This ended up a nightmare when any of them found a problem with the code, as I ended up having to fix every single one of the duplicates manually.
So I want to know if there is any way to make this into an App AS IS or something that can be used by multiple users without having to create duplicates of the file, so that if any of them finds some trouble, I can just fix the original and have all users get the fix.
I know that there must be some other way to do this if I were to work this from scratch as an app, but unfortunately I literally had no idea how to code until a few months ago, when out of desperation I looked for ways to automatize entries into our databases, so it's completely out of my reach to do anything more advanced. So bear in mind that all I know about code, is what you can do with Apps Script in a Spreadsheet. And using AppSheets directly on the table won't work because this form feeds at least 4 different tables and creates other form-like spreadsheets using the input data.