Jump to content
  • 0

Reminder email trigger - stuck


roattw
 Share

Question

I have a form that has an option for Pending Info (checkbox) that users can select if they dont have enough info at the time the form was completed.  

This form is stamped with user level auth so the record is associated with that user, so later they can login and just see thier entries.

I would like a triggered action to EMAIL the user who submitted the form if they used the Pending Info checkbox.  To serve as an email reminder to do back and update the record. 

Their email address is part of their user account info table.  Username and password is used for login, but email is also collected.

I put a virtual hidden field on the form to receive on entry the auth table field email (Virtual1) and also pass that on exit.

I think I have the email set for Pending info checkbox but Im not sure how to have it sent to specific user who submitted the form.

2019-12-29_17-21-43.png.ad9e497bedd6d78342c51d05d840b6ce.png

Link to comment
Share on other sites

6 answers to this question

Recommended Posts

  • 0

Hi @roattw,

You can use #inserted in the Select From block instead of the Table (Patients_Encounters_Pre121219). If you use the Table itself, every time the Triggered Action runs, it will send an email to all records where Pending_Info is equal to "Y".

You can refer to this video for more information:

https://www.caspio.com/webinars/send-sms-emails-using-triggered-actions/

 

Happy Holidays! :) 

 

-kristina 

Link to comment
Share on other sites

  • 0

Hi, Roattw!

 

Can you share your final solution? I have the same problem that you have.  I have a table with reminders that are "owned" by different users. I would like to create a task that sends a table variable to each user with only their own records. 

User one is emailed the table of her own records, user two is email the table with his own records, and so on.

 

Link to comment
Share on other sites

  • 0

Hello @kcastagnaro,

If I got your question correctly, you may test this solution. 

1) Let`s say we have a table with users` info


42Eh7kK.png

 

2) The second table stores some data and each record stores User_ID as a secondary key. So, these 2 tables have a relationship based on User_ID.

 3cY5KIp.png

 

3) This is a Task example to send individual emails:

do3CRK4.png

The user with ID=1 receives the following email:

BwMHytp.png

And the user with ID=2 receives the following email:

eJwOnd5.png

 

Task design explanation:

  • The first table variable is "Variable_For_Message". Here we select the fields from the Assigned_Records table that we want to use in the email body. The key point here is to set any false condition. In this example this is Where 1 = 0. 

               This is needed to set up a table variable structure, but to leave the table variable empty. It is empty thanks to the condition is never met.

  • In the second table variable (that`s "List_Of_Emails") we need to select email addresses from the users_emails table. Also, we need to select the field that is used in relationships between our tables, to join the tables on this field, and group by selected fields. 

 

  • In the For...Each loop we are going to populate the "Variable_For_Message" table variable -> To send email -> The clear the table variable using the 'Delete From'.  As a result in each iteration the table variable is populated with correct data that is related to the specific user. 

             In the 'Insert Into' block we need to select from the Assigned_Records table and set the condition that compares User_ID in the table with the #record.user_ID(so the User_ID of each iteration). Then we also need to match all the fields:

5fibc3P.png

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...