close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 or 2018 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Trigger emails based on recordset field value

Thread began 2/16/2016 11:20 am by iain331081 | Last modified 2/18/2016 6:54 pm by Ray Borduin | 365 views | 5 replies |

iain331081

Trigger emails based on recordset field value

Is it possible to trigger emails based on the value of a recordset field value, rather than the submission of a form?

Use case is an email to go to people who haven't updated their details in the last month.

It might be the sort of thing that required a cron job, or maybe something that wasn't completely automatic but could be triggered by an admin submitting a simple form to trigger the emails, which is still a great timesaver compared to emailing people individually.

Sign in to reply to this post

Ray BorduinWebAssist

You can add a recordset to the page and filter based on whatever criteria you want so that only people that should be emailed are returned in the results. Then trigger off the recordset not empty and send to the recordset loop results.

A cron job is probably the best way to initiate the send rather than having to visit that page daily for it to send.

Sign in to reply to this post

iain331081

Thanks Ray. I'm not that familiar with cronjobs, but know where to add them in the site's cPanel, and the basic format of something like:

0, 9, *, *, * to run it every day at 9am, and the path to the script to run after that.

In this case, what would the path need to point to?

Sign in to reply to this post

Ray BorduinWebAssist

I'd just google: "cron job run php page" there should be a couple of techniques

Sign in to reply to this post

iain331081

I think what was throwing me was that there is a page with the SQL query and then the WA pages that control the sending of the emails.

But presumably any path would just need to be the original page with the SQL query that had the references to the other files.

Sign in to reply to this post

Ray BorduinWebAssist

That is correct. It would run just like manually visiting that page on regular intervals.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...