Hello, i have some problems with my app. whe...

(Lucas Cuypers) #1

Hello,

i have some problems with my app. when my employees are working with it there are sometimes situations where they are working at the same moment in the app on the same row of data.

when this happens one of them will lose his data because when the latest syncs his new data it overwrite the new data of the other one…

is there a way to block people out when the row is in use or to make it read only until the other one has synced his data ?

or…

many thanks

(Aleksi Alkio) #2

Unfortunately nothing bullet proof method to handle that directly. One workaround is to have an additional column which contains the user email address for example. Only that person could then open that record. If someone needs to open it for editing, he needs to ask a from the existing user to change that email address. Not so clean way, but doable.

(Lucas Cuypers) #3

Thanks, would it be possible to use one of the field’s “Settings” that you can costumize for each user… USERSETTINGS({OptionName}) to give the next one in line permission to edit the row …

is it possible to change the change the updatemode of a slice

in a formula ?.. or where do you need to put the code to control that user A can open row 1,2,3 but not 4 because user B has not enabled it…

(Aleksi Alkio) #4

You can’t use user settings because that value is only in your device. You can create that functionality for example with Editable_IF.

(Lucas Cuypers) #5

Do you have editable if also for an entire row … i do see this for each column buth then you can stil open it and resave the same value’s right ?..

(Aleksi Alkio) #6

You want to show that record for all but only one user can modify it, correct?

(Lucas Cuypers) #7

yes

(Aleksi Alkio) #8

Because we don’t have a way to set the access level row by row like Editable_If, you need to create that functionality by yourself. The easiest way in this case would be the system Edit action button. If you add a rule like USEREMAIL()=[EMAIL] for that, you have that feature.

(Lucas Cuypers) #9

Oké thanks, i did solve it by using a token that gives the other person

access.

the token is a setting that can be changed for each device. i have combined it with a slice filter and some action buttons.

(Aleksi Alkio) #10

Okay… good that you found a way:-)