Send email for user approved 'yes'

When the user creates an account, the APPROVED field appears as “no” in the database.

I am creating an action in the workflow of the “create account” button that sends an email when the user is set to ‘yes’ in the database, for this within the workflow we have:

Step 1: Sign the user up
Step 2: Send Email > Only When: Current user’s is approved is yes

However, the email is not sent, as the system understands that when it was created, the approved status was ‘no’.

There are two ways you could do this

  1. In the yes/no field in the DB, set the default value to yes
  2. Before sending the email, change the user’s approved value to yes

Since you have an approved field, I’m guessing you’re only selecting users that could sign up to your platform. If this is the case, why not add the action to change the value to yes upon approving?

If you don’t shortlist/select certain users that could sign up, why do you have an approved field?

I’m also thinking that having an admin page that shows all your users via a repeating group…then having an ‘approve’ button on each user where you could change their status to ‘yes’ and then also include in the workflow to send an email. I think that would be a good solution since admin pages help a ton.