Free accounts-limiting table changes

AppSheet AppSheet Q&A
1

To encourage a potential new AppSheet customer I have given a copy of one of our apps to this new user. As a new user testing out the platform, they have a free account.

It seems that using an expression to limit table updates 'DATA > TABLES > “Are updates allowed?” does not function as it does with a paid account.

Is this intentional or is there potentially a bug or something else I should consider?

Typically, I use a SWITCH statement to determine user rights. In this app copy, this does not work. Even a simple statement such as IF(USEREMAIL()=“this@email.com”,“ALL_CHANGES”,“READ_ONLY”) does not work. Any expression seems to make the table READ_ONLY.

The expressions evaluate correctly in the builder but the table is still READ_ONLY.

2

Please post a screenshot of the expression that does not work.

3

I use this or a very similar expression in the majority of my apps.

SWITCH(LOOKUP(Useremail(), People, UserEmail, Role),
“Admin”, “ALL_CHANGES”,
“Transmission Supervisor”,“UPDATES_ONLY”,
“Crew Leader”,“UPDATES_ONLY”,
“General Foreman”, “UPDATES_ONLY”,
“READ_ONLY”,
)

PAID ACCOUNT

3X_4_4_446a830b3ba2c87c8895e8c33c9a1079ef187396.png
3X_4_4_446a830b3ba2c87c8895e8c33c9a1079ef187396.png928×560 124 KB

FREE ACCOUNT

3X_9_8_9850ae25032469005e47751cff11acd2815aee10.png
3X_9_8_9850ae25032469005e47751cff11acd2815aee10.png976×565 56.8 KB

4

The obvious possibilities are:

  1. The email address given by Useremail() does not occur in the UserEmail column of the People table.

    OR

  2. The Role column of the matching row in the People table does not contain a role listed in the SWITCH() expression.

Have you tried testing he expression?

3X_f_a_fa0afd9ed0c20355280beb6964c238ba68573a87.png
3X_f_a_fa0afd9ed0c20355280beb6964c238ba68573a87.png220×193 2.46 KB

5

While I definitely appreciate your input Steve, I have ruled out both of the possibilities you list AND I have tested the expression multiple times. Each time, the expression evaluates as expected.

1 Like
6

Is the user interacting with the table from a view attached to a read-only slice?

7

In the two images I posted, the views depicted, and the app in general, the only differences are the email addresses and the user name. Basically, I copied the app to a gmail account I setup for this person. Then I added their new account to the Person’s table. In the Person table, I duplicated the row that listed my information and substituted my name/email with their name/email.

8

Ah! Did you also give them a copy of your spreadsheet? Or is their copy of the app using your spreadsheet? If their app is using your spreadsheet, their app is subject to the sharing permissions of your spreadsheet. If your spreadsheet isn’t shared with them and doesn’t allow them to make changes, they will have read-only access. Could this account for the behavior?

9

Nice try!

When I copied the app, I also copied the data. The new app and user are using their own data which resides in the new user’s google drive.

10

Please contact support@appsheet.com for further help with this.