I’m facing an issue with SeaTable permissions. I need to set up access so that a user can import data from Excel or CSV into a specific table in a database.
Currently, access to the table is granted through “Share Base - Custom Sharing Permissions” with read and edit rights. However, the user does not see the dropdown arrow next to the table name that allows importing data.
If I grant full access to the base, the import option becomes available, but this is not ideal because the base contains 10 tables, and I only want to allow import permissions for one specific table.
Is there a way to configure the permissions correctly to enable importing data into a specific table without granting full access to the entire base? Any suggestions or workarounds would be highly appreciated!
Hi @romasvl,
What about a universal app ? Using an app, you can create pages only for the tables you want to give access to, and there are also permissiond based on roles (for each page/table, you can define who can modify, add, or delete rows).
Good day, thank you. Unfortunately, this is not a solution because, when creating a table in Universal App, there is still no option for me to even import data into this table. Only exporting is possible.
I’m quite surprised that there isn’t even a discussion on this topic. It seems that none of the users have ever needed their employees to upload or import any datasets into a table for analysis. This is very strange. Perhaps you didn’t fully understand my task?
Hi again,
You’r right, I probably don’t fully understand your use case, sorry about that.
I thought by importing you just meabt being able to paste data into a table, which you can do with a table page in an app, but copying 1000-50000 rows won’t be pretty user friendly.
Considering this, the only solution I can think of is developping (and hosting) your own html/js page, with some client/server mechanism to interact with you SeaTable’s table and eventually a spreadsheet library such as jspreadsheet for example to display some of the input data to ensure everything went right during getting data from the file. If you want, I can give you some more information, I already set up such a web page.
