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 it.
The solution should work as follows:
Take a picture of some document with the glide-app, which stores the image. If I am correct the File-Picker-URL will be found in a Google Sheet, which I call 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.
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.
The Glide app should then access this data from sheet#3 again and display some values, feedback text and charts.
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.
The question is if I can do all of this with a NoCode-stack (if yes, which additional tools would you recommend to automate the task of filling the Google sheets with the relevant data?) or if there is some technical barrier, that would require 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!