I'm trying to set updates permissions for a table using Current_User slice guidance. I have used two suggested formulae from various sources in the community but I get the following error (edit for clarity) during sync:
The following formula versions makes the edit behavior work correctly in the app but, as stated, give the error above when syncing:
Additional details: If I take the formula out and generally turn on Updates/Adds/Deletes everything works. I'm using SQL as my data source.
Thank you for any suggestions or direction.
Solved! Go to Solution.
Welp, I figured this out. Posting the solution here in case it will help any other newbies such as myself in the future.
I was testing this in the app preview mode and was switching users using the "Preview App as..." feature. I should have read the help text on this feature:
So, of course all of the different expressions I tried worked as advertised once I actually deployed it to a test user and tried it. Lesson learned!
Replying to say that I still can't get this to work after tons of research and experimentation. The following expression provides the same result: The app behavior is correct (allowing or disallowing edit access), but I get the same error on sync.
Welp, I figured this out. Posting the solution here in case it will help any other newbies such as myself in the future.
I was testing this in the app preview mode and was switching users using the "Preview App as..." feature. I should have read the help text on this feature:
So, of course all of the different expressions I tried worked as advertised once I actually deployed it to a test user and tried it. Lesson learned!
User | Count |
---|---|
14 | |
11 | |
9 | |
7 | |
4 |