Setting up authorisation workflow for new user registration

Hi all,

New to Bubble and loving it! But, need some assistance.

I have setup a new website which has three different user levels each with their own access levels.

For ease of explanation let’s say Super Admin (all access), manager (access to manager and user areas), and users.

What I am trying to do is setup a workflow so that when a user registers to access the portal the manager who manages them gets an email notifying them the user has registered and a link that the manager can click that will then grant the user the access (or activate their account). The user must then get an email notification saying their manager has granted them access and their profile is active.

When a user registers they select their manager from a drop down input field in the registration form. I want to setup a workflow that then auto-fills a data field in that users profile in the back-end. We have 8 managers managing different users. So a user will specify their manager and that particular manager will get the email asking to verify the user and grant them access.

I hope that makes sense.

Any help would be very much appreciated.

Thanks