it looks like this time my approach to move my data and tools from Airtable to Seatable is going to be real. I also want to take the chance to switch from a hand full of wide spread tools over different languages and user interactions (nodejs commandline, python commandline, electron) to something that is as closely integrated into seatable as possible.
The first task I’m trying to tackle here is one to merge several pdfs into one and do OCR on this merged pdfs at the end. The URLs to these PDFs are stored in Seatable. Each URL is in a single row in an orders table. Each order has a date.
The goal is to have the user select a date and have all URLs transfered to n8n in a way where it could further do the merging and OCR (likely via AWS textract, but that’s a different story then).
I wonder what a good way would be to have this user interaction integrated into seatable. I could imagine having a view where orders are grouped by the date. But would there be a way to have user interaction on those groups? Like a button that runs a script? It would also be great to be able to have some feedback for the user - maybe the return code of the n8n webhook.
Sorry if this questions sounds dumb but i’m only starting to use Seatable, so I need to get used to all the stuff available.
When you talk about users, do you mean people with a SeaTable subscription, or also external people?
You could work with one view, you’re right, but I would recommend the universal app.
With the universal app, you can make information/data available to certain user groups without requiring them to have access to your base. You can also include a button here.
You can find more information about the Universal App here.
Ok, I may be back quicker than I thought. The Universal App looks great but it looks like a glorified CRUD tool to me. Seems like it enables me to display data in various ways and also use forms to enter data. I don’t think it does what I need to do though.
Not sure if my question was clear enough so I try to rephrase it. I would need the user (SeaTable user) to select a date and ideally be presented with the amount of orders available for this date (so far Universal app could probably be helpful). Then after selecting the date some kind of script would need to run to that sends the data from the orders that happened on this date to n8n in some way - probably webhook would be the way to go here.
I could imagine a python script that takey the date as an input and then runs on seatable python runner. The question is how this user interaction could be working. Is this something that can be done with the universal app and I’m just not seeing it? Maybe I just missed it.
After some playing around I slowly start to realize how Apps can work. I created a task table with limited access rights where those kind of tasks can be stored and then used for further automation. Need to play with that a bit more to see how further processing could happen, but that’s a good start. Thank you for that.
One question: Is it really not possible to have hidden fields in forms. I would like to use default values in the form. I noticed I can set them and also lock them but hiding them from the user would even be better.
Unfortunately, it is not possible to hide the column directly.
However, you can add a condition to the corresponding column that is not fulfilled → so the column is not displayed.
