Notification email for every user subscribed for a dataset query

Hi Wix Team, Guys,

I need a best and optimal solution to implement and send notification email system for a dataset query subscribed by user.

Example Use Case:

  1. A user comes to my website and search for a term using a search box/dropdown based query.

  2. User get some results and he now want to subscribe this query and want to get email alerts for any new data entry that corresponds to this query.

  3. So he turns on a radio button to subscribe to the query.

  4. The website should then check every time for this specific query and maybe 100’s of other queries subscribed by other users and then should be able to send emails to the subscribed users to the every new entry that corresponds to the subscribed query.

So what is the best method to implement this … Thanks…

Hey
As the Triggered Email system can only send mail to currently logged in users you can’t use that for this project.

Use SendGrid as the samples that exists here on the site under Articles.

Then when a user ticks that they want to subscribe make some field in the data collection for them have the value True maybe.

Then create a external module using http-functions that accept the GET protocol and add some kind of cron job that will run that function every 30 minutes or every day or what you prefer.

In that function, search all members queries that they want to subscribe, if match is found execute sendGrid notification email.

Done!

Kind of a lot of coding but doable.

Thanks Andreas… Yes I will start with send grid step by step… :grinning::v:

BTW @Wix Team,

It would be great if I can Use Wix CRM database to read and write infos like this. If I can read and write to wix CRM database then I can save each query to their corresponding user when they click a subscribe button and read it daily to do the above mentioned email notification system…

Thrishti Labs Hi; It has been a long time, this issue has been brought up. But I wonder, I’m looking for a solution on the same issue right now. If you could or found a solution, can you share it?