Jump to content
  • 0

auto email activates on every 4th update only


NiceDuck
 Share

Question

Hello,

I  would like to share some workflow again for those who dont have a triggered action feature.

With this workflow, you will be able to make the auto email function of your details page activates only depending on the number of times it was updated.

Again, this feature could easily be done by using triggered actions however. It is not available for some of us.  well, without further adew, here it is...

first, you will have to make an integer field on your desired table. lets name it "update counter". make sure that this field has a default value of 0. For how will you do that, it is up to you or reply here if you dont know how.

second, go to your details page where you want to implement this feature.  you will have to create two virtual fields .

on the first calculated value (virtual1),  you will have to make it load the value of the "update counter field". If you would like, you can also set it to hidden if you want.

Then,  set the "update counter field" as a calculated value. This will be our incrementor (you'll get the idea). It can be done by adding 1 to the value virtual field you created from the previous step. use the SQL code beloew:

********************************

[@cbParamVirtual1] + 1

******************************************

Then we will use the other virtual field (virtual2)  as a calculated value and use it  as a condition statement where if the equation above is = 0, it will return the desired email. Otherwise, it will return nothing: you may use this SQL code.

********************************

case 
when [@field:update_counter] % 3 = 0
then [@field:email]
else ''
end

 

*replace the [@field:email] with your email field or your desired email.

************************************

Finally, go to the Search and Report Wizard - Email Options   use the "virtual2" at the "to" field of your email. with this. 

 

with this workflow, the email on the "To" field of your "acknowledgement" or "notification" email will be null unless the counter has the proper value. Thus it will not send an email

I hope it helps anyone.

Quack



 

forum.png

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

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