TOPIC:

Trigger emails on table update. 3 years 1 month ago #230369

  • tyekynan's Avatar Topic Author
  • tyekynan
  • Offline
  • Senior Breezer
  • Senior Breezer
  • Posts: 148
  • Karma: 1
  • Thanks: 3
I have 2 tables. One table with contracts and another table with users that want to be notified when new contracts are loaded as long as the criteria meet their needs.

Is it possible to have something trigger an email when the criteria are within their range?

Example:

Table A:
Resort | Points | Price

Table B:
Name | Email | Desired Resort | Desired Points | Desired Price

When we upload a new row to Table A that meets the values of a person in table B I want it to trigger an email to that person to let them know a new contract has been listed that is within their range.

Help! Can content builder do this?

Please Log in or Create an account to join the conversation.

Trigger emails on table update. 3 years 1 month ago #230384

  • DarkoCujic's Avatar
  • DarkoCujic
  • Offline
  • Developer
  • Developer
  • Posts: 2154
  • Karma: 67
  • Thanks: 265
Hey,

unfortunately, we don't have a system like the one you need. I can't even recall if I've ever seen a similar request and/or solution.

You can contact our official partner GWS Desk and get a quote from them.

Regards,
Darko
Satisfied with our support? PayPal tips
===========
Need to renew Pro Support? Buy Here!
===========
Satisfied? Consider a membership!
===========
Like us on Facebook
===========
Support Crosstec and get ALL EXTENSIONS and professional support for just $5. Here!

Please Log in or Create an account to join the conversation.

Trigger emails on table update. 3 years 1 month ago #230424

  • tyekynan's Avatar Topic Author
  • tyekynan
  • Offline
  • Senior Breezer
  • Senior Breezer
  • Posts: 148
  • Karma: 1
  • Thanks: 3
Could it be done with zapier and breezing forms?

Please Log in or Create an account to join the conversation.

Trigger emails on table update. 3 years 1 month ago #230432

  • DarkoCujic's Avatar
  • DarkoCujic
  • Offline
  • Developer
  • Developer
  • Posts: 2154
  • Karma: 67
  • Thanks: 265
Hey,

really not sure about Zapier as the most that we've done with it was a simple integration.

However, looking closely at your issue, I think it can be done with a custom ContentBuilder plugin ( crosstec.org/en/support/online-documenta...ted/567-plugins.html ).

You'd need a "on form submission" plugin that would check the users table (table B)for the values that were entered and send emails accordingly.

You can find how a similar plugin is done by downloading ContentBuilder: Edit Logging for Joomla!® 3x from crosstec.org/en/downloads/free/extensions-for-joomla.html and opening it in a source code editor.
Your plugin has to have a constructor, onBeforeSubmit and onAfterSubmit. The entire magic should happen in the onAfterSubmit. All the submitted values should be in $values that’s automatically passed to the function. I’d have to think a lot more (and look at the existing forms and tables) to give you the exact code, so I’m just going to write out some pseudo code:
1) get, sort and sanitize $values
2) do a query on table B from your opening post to check if there is a row that matches the criteria
3) if there is, get its email value and simply send a mail docs.joomla.org/Sending_email_from_extensions

That's how I would do it.

Regards,
Darko
Satisfied with our support? PayPal tips
===========
Need to renew Pro Support? Buy Here!
===========
Satisfied? Consider a membership!
===========
Like us on Facebook
===========
Support Crosstec and get ALL EXTENSIONS and professional support for just $5. Here!

Please Log in or Create an account to join the conversation.

Trigger emails on table update. 3 years 1 month ago #230480

  • tyekynan's Avatar Topic Author
  • tyekynan
  • Offline
  • Senior Breezer
  • Senior Breezer
  • Posts: 148
  • Karma: 1
  • Thanks: 3
Thanks for the tips. If I give this a shot and run into any problems I will post back. If I get something working, I will also post back in case someone is looking for the same thing.

Please Log in or Create an account to join the conversation.

Trigger emails on table update. 3 years 1 month ago #230488

  • DarkoCujic's Avatar
  • DarkoCujic
  • Offline
  • Developer
  • Developer
  • Posts: 2154
  • Karma: 67
  • Thanks: 265
Excellent, feel free to ask if you get stuck.

Regards,
Darko
Satisfied with our support? PayPal tips
===========
Need to renew Pro Support? Buy Here!
===========
Satisfied? Consider a membership!
===========
Like us on Facebook
===========
Support Crosstec and get ALL EXTENSIONS and professional support for just $5. Here!

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
Moderators: ForumSupport
Time to create page: 0.083 seconds

BreezingForms Pro 1.4.7 for WordPress Released!

Available in the membership section.

September Discount!

Massive discounts on all subscriptions!

Get Your Subscription Here

Quick Links

Downloads

BreezingForms

ContentBuilder

BreezingCommerce

Templates

Documentation

BreezingForms

ContentBuilder

BreezingCommerce

Apprendre BreezingForms (French Community)

Apprendre et maîtriser BreezingForms par des tutoriels et exemples, le tout en français

breezingforms.eddy-vh.com

Questions et réponses sur les forums de l'AFUJ

AFUJ

Special Offer

Summer Sale! All subscriptions at a special price!

Includes prio support, all of our current and future Joomla!® extensions and Joomla!® templates for the duration of your membership.

Get it from here

3rd Party Discount - 25% Off

We help you to keep your costs under control. If you are a new member and purchased a form building tool from a different form vendor, then you'll get a 25% discount on our subscription plans.

How to receive the discount:

Send us a quick email to sales@crosstec.org with a proof of purchase (for example a paypal receipt), await payment instructions and enjoy your membership!