I have a newsletter tracking app that stores emails from various e-commerce brands.
Whenever we receive a new email, a webhook workflow is triggered, sending me the email subject, brand name, date, email body HTML, and other information through the webhook.
I have a drop-down field called promotion type in the email database which has basically options like (using option sets) % off, $ off, coupon, etc.
Now I want to check if the subject line contains the word % discount, then I want to map the promotion type as % off option.
I am new to Bubble so it would be nice if you could explain the steps in detail. I posted the same question earlier as well but couldn’t understand the solution.
I would create a custom workflow that takes in a text and returns an Email Promotion Type option set. In that custom workflow, you can do your pattern-matching / case statements. For example: if the text contains % off return option set Percent Off.
That will be your new step 1. Your previous Step 1, where you save that data, you can just say Email Promotion Type=Results of step 1
Firstly, I would expand the Option set table with a field called “Regex” based on your Promotion Type and patterns you want to search.
After that, I will run all the promotion type (regex expression) through a API workflow on the Subject line and if results from a particular regex is received, that promotion type should be used to update the email object.
Apology but couldn’t understand the solution. I am new to bubble. If you have some free bandwidth can you please explain in a bit detail, a short loom video will be very helpful.
I have been trying this for a week now but haven’t been able to complete this workflow.
