Is it possible to have user profile in Appsheet?

Can users have their own profile/dashboard from where they can edit their details. 
For example : Vendors listing their service on the App which they can edit & update without having everyone else have edit access ?

Solved Solved
0 4 1,077
1 ACCEPTED SOLUTION

Aurelien
Google Developer Expert
Google Developer Expert

Hi @Pharank12 

I would recommend using a table USER with their information to manage your situation.

About update permission, I would go for a combination of:

1) Managing the table settings:

Aurelien_3-1681727802962.png

Aurelien_1-1681727680886.png

Aurelien_2-1681727787591.png

With this expression:

SWITCH(USERROLE(), 
  "Admin", "ALL_CHANGES", 
  "UPDATES_ONLY"
)

This ensures a kind of "super-admin" create items, and other users to just update information over this table

2) Using a per-row restriction, from the table view:

Aurelien_4-1681727861909.png

Aurelien_5-1681727889617.png

Note: this assumes the column "key" in my example is the user's email.

View solution in original post

4 REPLIES 4

Aurelien
Google Developer Expert
Google Developer Expert

Hi @Pharank12 

I would recommend using a table USER with their information to manage your situation.

About update permission, I would go for a combination of:

1) Managing the table settings:

Aurelien_3-1681727802962.png

Aurelien_1-1681727680886.png

Aurelien_2-1681727787591.png

With this expression:

SWITCH(USERROLE(), 
  "Admin", "ALL_CHANGES", 
  "UPDATES_ONLY"
)

This ensures a kind of "super-admin" create items, and other users to just update information over this table

2) Using a per-row restriction, from the table view:

Aurelien_4-1681727861909.png

Aurelien_5-1681727889617.png

Note: this assumes the column "key" in my example is the user's email.

Thank you for the immediate response 🙂 but I am facing difficulty while applying 2nd step

When vendor fills the form to upload the services it's not showing the column which has above filter applied.


@Pharank12 wrote:

When vendor fills the form to upload the services it's not showing the column which has above filter applied.


Did you change the Editable_If column?

It seems you applied a condition to the Show_If column?

I made changes in Editable_If column only but I guess need to make changes in the whole table.

Thank you for your help 🙂 Really appreciate it. 

Top Labels in this Space