When a coach edits a member’s profile using an edit form inside Glide app — all fields (like name, phone, membership, etc.) can be changed, but when they try to edit or add the member’s email trough the edit form, the change doesn’t save. What do i do, without this feature the app is basically useless
Glide will not allow you to change a users email via a user interaction workflow.
To do so, you must either:
- Change it manually via the Data Editor,
- Use a server side workflow (manual or webhook trigger), or
- Use the Glide API
Care should be taken when changing a users email address. In particular you should be aware that:
- Depending on your access settings, if the user is signed in at the time they will be logged out
- Any User Specific data associated with that user will be gone
- If their email address is used as Row Owners in any tables, they will lose access to that data
2 Likes
but how do i make edit form trigger that manual workflow? i tried using form container trough “show new screen” action but it wont work. can u give an example with columns i need to connect and the forms/screens i need to use please?
Use a onSubmit action, and select “Trigger Workflow”
You will need to create the manual trigger workflow first.
I tried that — I made a manual workflow triggered from the edit form’s onSubmit. It loops through the Members table, checks if the email is empty, and then sets the Email column to the value from the Edited Email column. Can u help me set it up to work properly please, here are screenshots.
You don’t need a loop.
Add two Items to your Manual Workflow configuration, like below:
Then pass both the old and new email address to the workflow in your onSubmit action.
In your workflow, create a (single) Query to your Users table matching “email is Trigger->oldEmail”.
Then do a Set Column Values via the Query.
If the email is going to be empty to start with, then pass some other unique value, such as a RowID.
2 Likes
thanks a lot. i did as u said and it works both ways now, for empty and old emails. thanks a lot sir, i truly appreciate your help!
1 Like
btw what if the admin edited user’s other data (for example phone number) but didnt edit the email, even though the member already had an email. would that rewrite the new email column to be empty and then with workflow rewrite old email column?
Can you show me your current flow?
I get the feeling that it’s probably a bit clunky. If I can see what you have now, most likely I can help you streamline/improve it a bit.
I apologize for my late response, i had some irl work to do, which caused me to be away from my laptop for a while. Here is my workflow and edit form linked to it. I tried setting up the query to filter email columns but then realized i would need row id in order to let admins rewrite the users without any email
