Hi, I want to have several apps (each of them...

security
(Christoph Bücker) #1

Hi, I want to have several apps (each of them with data in an own google drive folder) have in addition read/write access to a common data file in another folder. For all file security filters apply.

Should this be possible? It was possible to assign the common file in appsheet in each of the apps, but it turns out that there are access problems of my users.

Regards

(Steven Coile) #2

Certainly possible, though yes, permissions might be a problem. In the common table’s configuration, ensure Access mode is as app creator. If set to as app user, every app user must be granted access (via Google Drive) to the worksheet individually.

(Christoph Bücker) #3

Thanks Steven, Access mode is set to app creator, so this should be fine. The problem arised during syncing, saying that there is no write access. The common table is in a folder of another app. The users do not have access to this additional app.

(Steven Coile) #4

@Christoph_Bucker Yeah, I’m at a loss: I’d expect it to work.

(Christoph Bücker) #5

@Steven_Coile Thanks anyhow. Good to hear it should work.

(Steven Coile) #6

@Christoph_Bucker Is the table (in AppSheet) corresponding to the common worksheet configured to allow updates, adds, and deletes?

(Steven Coile) #7

@Christoph_Bucker Are you using a slice atop the common table? If so, does the slice allow updates, adds, and deletes?

(Steven Coile) #8

@Christoph_Bucker Are you using a formula to determine what updates are allowed to the common table?

(Christoph Bücker) #9

I am using security filters based on this common table. A slice is defined as well and Updates are allowed.

(Steven Coile) #10

@Christoph_Bucker I’ve run into problems before with using formulas to determine table update permissions when the data being updated changed the result of the formula, resulting in my update access being revoked mid-sync.

(Christoph Bücker) #11

No, I am not using a formula for the update mode.

(Steven Coile) #12

@Christoph_Bucker Do you have the exact error message returned?

(Christoph Bücker) #13

Unfortunately not, I only received a call from the user. I solved the issue by now by copying the common file to each of the individual folders and linked to this copy. But this is of course not that what I finally want to accieve. I assume I have to test it further the next days. I understand it should work, so I will give it a try.