On User Profile Change Do

[Alexander_Strei]

Hey appsheet community,

happy to be part of the team I want my users to change their “group id” in their user profile. When they have changed it, I want to write the useremail + the group id into a “groups” table or update the entry when the group id has been changed again.

I played around with workflow and automation but can’t find a way to trigger this action when an entry is changed in the user profile.

Really looking forward to your answer. Thank you so much already.

Cheers, Alex

[Chris_Jeal]

Could this help?

help.appsheet.com

Before and After Values

You can see the value of a column both Before and After it was updated.

[Alexander_Strei]

Unfortunately that’s only possible for created tables and slices. I’d like to use the user settings table in the “data” section if possible.

[Steve]

What do you mean by “user profile”?

[Alexander_Strei]

Thanks for your answer. I’d like to use the user settings table in the “data” section if possible.

[Steve]

Unfortunately, workflows can only be applied to tables that are stored in a cloud-based data source, such as a spreadsheet or database. User settings are stored on the device itself, and not subject to a workflow response. The alternative is to implement your own alternative to user settings that uses cloud-based storage, but its not a trivial thing to do.

[Alexander_Strei]

Thank you very much for the answer Steve. I tried to come up with a solution where the new user is automatically added to a database and a view where the user can only change that entry (similar to the profile, so like a pre-filled form).

I have searched for the two questions, but couldn’t find anything, can you please help out:

• Is there a way to add a new user (USEREMAIL) automatically to a table?
• Can I create a view where only that entry can be changed?

Thanks. Really looking forward to your answer,
Alex

[Steve]

Alexander_Streihamme:

Is there a way to add a new user (USEREMAIL) automatically to a table?

Not without some sort of user interaction. To add the user, either an action must be performed (initiated by either a button press by the user or by some other data change) or a workflow must fire (prompted by a data change). There’s no trivial way to do this, but I did suggest an approach here:

FAQ: How do I do something automatically the first time someone uses my app? Tips & Tricks 💡

How do I setup/register a new app user automatically? How can I do something automatically the first time a user uses the app? This example assumes your app requires sign-in, and that you have a table named Users, each row of which describes a single user of your app. Such a table is a common way to store information about your app users and as an alternative to User Settings to store their individual app settings. The Users table is assumed to have a column named Email to store the email addr…

Alexander_Streihamme:

Can I create a view where only that entry can be changed?

Yep! This might offer some ideas:

Current_User (Slice) - How to conform your app around WHO is using the app Tips & Tricks 💡

One of the core basic functions, included in just about EVERY app I make, is the ability for the app to know WHO is using the app. If the app knows who’s using it, then I can easily control many different aspects of the app: Add/edit/delete permissions How data should be filtered What views are shown What buttons, or Actions, are visible Which workflows should fire off Which columns should be shown or editable etc. Requirements To accomplish this functionality in your app, you need the follo…