Are updates allowed?

AppSheet AppSheet Q&A
1

Hello friends, I ask for help,
I have already searched a lot and I have not been able to:

Is it possible for several people to have access to a view, and only be able to edit the records they made by themselves?

2

https://help.appsheet.com/en/articles/1128148-limiting-users-to-their-own-data

3 Likes
3

Would be:

if(
[xxxxx] = Useremail(),
“ADDS_AND_UPDATES” , " ADDS_ONLY"
)

4

It has NOT worked! Not even that…

IF((“VISITA”[Email] = [_THISROW].[Email])=VERDADEIRO, “ADDS_AND_UPDATES”,
“ADDS_ONLY”)

5

Because you trying to compare list “VISITA”[Email] with ordinar value [_THISROW].[Email] and next compares “result” with VERDADEIRO(?)

http://help.appsheet.com/en/articles/2355953-if

http://help.appsheet.com/en/articles/961337-yes-no-expressions

1 Like
6

One way to do this would be to have a column, say [created_by] with initial value = USEREMAIL().

Then in the Edit action’s behavior>>only if this condition is true, set something like

[created_by] = USEREMAIL()

This way a record can be edited only by its creator.

You could maintain a list of superusers table, say supervisors, with one column, say user.

In that case the expression would be

OR (
 IN(USEREMAIL(), supervisors[user],
 [created_by] = USEREMAIL()
)
2 Likes
7

You cannot use Are updates allowed? in the table’s configuration to control access to individual rows. Are updates allowed? applies to the table as a whole. Instead, you’ll need to configure Only if this condition is true for the Add, Delete, and Edit actions of the table.

8

Muchas Gracias User Settings

eres el mejor!!!