Hi everyone,
Just recently I attended a NoCode workshop, where glide was introduced. I was really surprised by how powerful it is and am considering to test an idea with a NoCode solution.
It should work as follows:
- Take a picture of some document with the app, which stores the image. Glide e.g. would use the File-Picker-URL, which will be found in a Google Sheet. I call it sheet#1.
- An OCR-solution from another platform vendor will then get access to sheet#1, extracts the text and writes it to another sheet#2. Probably this step needs some coding or help from my third party OCR-vendor, as I don’t think I will find something working with NoCode for that step.
- Then I would like to copy the entries to sheet#3, further manipulate those entries, which means preprocessing/cleaning and joining some more data from a larger external database. Would e.g. zapier be of some use here?
- The app should then access this data from sheet#3 again and display some values, feedback text and charts.
Further requirement:
Each user will have their own personal sheets, where the image-URLs as well as all the data will be stored. Of course all the three sheets that are automatically created for each user, must be uniquely associated with that user at all times for later retrieval of the recorded data. For safety and privacy reasons a secure log-in would be preferable.
I already know that glide will not work, as I would have to set up all the screens for each individual user, for all the users to have their own sheets to store and retrieve the data. The question is if I can do all of this with some NoCode-stack out there (if yes, which tools would you recommend?) or if some technical barrier can’t be overcome and requires me to go for a (partly) coded solution anyway. Before diving right into it, I would like to know if my concept would be even feasible on that level. Therefore I would be glad if somebody who has been in the community for a while could tell me right away, if what I want to achieve is doable. If there is something else I should spend some initial thoughts on, before getting stuck during the process, without really finding a way around it, I am also happy to receive any remarks on that.
Thank you so much in advance and stay well!
Cheers,
s1m0n
