Saved Search Email Alert from URL Parameters

dan.angland · 2024-07-30T10:05:56.295Z

Hi everyone, I’m building a job board using repeating groups that draw from URL parameters to create the main job search functionality.

I’ve set up a ‘Saved Search’ function that saves the current URL (with all parameters) into a List of Texts.

What I can’t work out is how to create a recurring workflow that finds the jobs added that day that match the saved search, then emails the jobs to the user.

here’s the live website

Thanks, Dan

Zeroic · 2024-07-30T11:15:23.359Z

Looks great! You can add another table to your DB called User preferences.

Within this, you can have fields called Region, Department, Job Type, Management, yearly/hourly salary.

Get the User Preferences entered by your users and link it to the respective User records.

Run a daily Schedule API workflow on a list of jobs added on that day. Inside this workflow, have another Schedule API workflow on a list of Users whose Preferences match this, and this latter workflow should have the action to send the email to the user.

Keep in mind that the list of users should also be marked as distinct, else you’ll have multiple emails being sent to the same User (in case multiple jobs match the User’s User preference)

Let me know if this helps

dan.angland · 2024-07-30T20:25:49.737Z

Thanks for your feedback.

Would that mean the user only has one set of preferences that they’ll receive emails for?

I think most people will have multiple ‘Saved Searches’ wont they?

For example someone may save a search for all Marketing jobs, but may also save a search for Sales jobs with the keyword ‘marketing’. Those would need to be separate.

Could the User Preferences you’re suggesting maybe hold multiple sets of preferences? And could they be extracted from the user’s Saved Search URL list?

johnny · 2024-07-31T04:46:17.946Z

Hey @dan.angland,

I actually just built something like this for OperationSTART a few months ago, but rather than storing the email preferences on Bubble, I saved it on Customer.io. Honestly, not sure why I did that, probably because it was easier and had built-in unsubscribe/preferences management, but here’s something similar you can do on Bubble.

Store user’s email preferences

I’d store the user preferences in Bubble for the type of alerts your user might want to receive. For example, a specific department or region’s job alerts.

Send the emails on a schedule

Depending on how you built your search functionality, I would use the user email preferences in your recurring email scheduling, then search for the specific parameters.

I don’t know how your database is setup, but for OperationSTART, I have an option set and then a field in the user for their preferences for the type of opportunities and interests to receive new postings for.

And when I schedule it, I do this:

I have a curate flow where I create a new thing in a data type called Weekly Digest, so users can get a copy of the digest in the app
I then reference that newly created item to send the digest in the email

The end result ends up looking something like this:

Screenshot 2024-07-30 at 21.45.56749×775 190 KB

Zeroic · 2024-07-31T20:02:49.149Z

dan.angland:

I think most people will have multiple ‘Saved Searches’ wont they?

For example someone may save a search for all Marketing jobs, but may also save a search for Sales jobs with the keyword ‘marketing’. Those would need to be separate.

Got it, so you can probably create a list of User preferences for each User instead of a single one and save each search there