Jump to content
  • 0

Automatic Email When Field Condition Met


YourSolutions
 Share

Question

Hi There,

I want an email with the contents of the report automatically sent to an individual(s) when a condition is met in a calculated field. 

 

For Example:

Calculated field is greater than a certain value = Send email to person A

OR

Calculated field is between value X and Value Y = Send email to person A & B

 

Each person has a unique email address.

 

Any advice would be greatly appreciated!

 

Many Thanks!

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

  • 0

Hi,

If you want this to happen in a DataPage level, you will need to write a several codes for that. It's possible but kinda tricky.  Some can be complicated though, so if you're not a hardcore web developer/programmer, you will definitely have hard times figuring it out (but if you wan to try you can see these links though: https://www.codeproject.com/Questions/785941/How-to-send-email-in-HTML-using-javascript ,  https://www.smtpjs.com/  , https://stackoverflow.com/questions/48283396/sending-email-from-javascript-with-smtp-server  , try also googling other links/tutorials).

There is another way to do that.It's a bit different to what you want but I think I will do.  As I was exploring Caspio Bridge, I saw this Triggered Action functionality. It works in the Table/Database level. When there is an activity in your Table,  say you updated a value of a field, you can select several options like send SMS, Email or even populate another table. This is also a bit tricky to configure but as per my experience, Caspio offers wide range of support, How-To, video tutorials and Online Training.  

 

Try these links : 

https://howto.caspio.com/tables-and-views/triggered-actions/

Hope this helps. Thanks.

Link to comment
Share on other sites

  • 0

Many Thanks for your reply, I will take a look at the various resources you have made available to me.

 

I am not an experienced programmer / coder so I was really hoping for a simpler method.

 

Would it not be possible to run an IF Function, for example:

IF the "calculated field" value is > than or equal to 90%

THEN send an email to Address X

ELSE IF "calculated field" is between 60 and 89

THEN send an email to Address X and Address Y etc;

 

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...