topic Re: Automated Email - Populated using HubDB & HubL in CMS Development

Automated Email - Populated using HubDB & HubL

ChrisChiha — Thu, 26 May 2022 04:03:40 GMT

Hello,

I am sending a daily digest to my partners that is being populated from my hubdb table, and is being triggered by a workflow. (The HubDB table is being filled daily from my Backend)

How it is currently working:

If the email address enrolled in the wokflow, is found in the HubDB table, then the row is fetched to the communication. The daily digest is working great right now, but now, even if the email address is not found in the hubdb table, the email is enrolled in the wokrflow.

I would like to know if it is possible to only send the email to enrolled people in the workflow, if their email address is present in the hubdb table.
I have a list of partners that are being enrolled in my workflow. Ideally, what i want to achieve; If the enrolled partner email is not found in the HubDB table column "email", i don't want the email communication to be triggered to him. is this possible?

Another question i had in mind:
Is it possible to trigger a workflow when a new row is added to the hubdb table ?

Re: Automated Email - Populated using HubDB & HubL

dennisedson — Wed, 25 May 2022 20:12:47 GMT

@ChrisChiha

This sounds like an interesting project!

Going to throw a few folks into this to see what comes of it

@tmcmillan99 , @Anton , @Josh , @ChrisoKlepke what do you all think?

@tmcmillan99 and @ChrisoKlepke are already having an interesting discussion on Custom Objects vs HubDB 😀

Re: Automated Email - Populated using HubDB & HubL

Teun — Fri, 27 May 2022 06:47:51 GMT

Hi @ChrisChiha ,

Do you have Operations Hub? If so, you can write a coded action that checks if a row exists and you can use the output to create a if / then branch to decide if you want to send the e-mail.

Re: Automated Email - Populated using HubDB & HubL

ChrisChiha — Fri, 27 May 2022 06:54:21 GMT

Hello @Teun,

Yes that's what i was trying to achieve, adding a custom code at the beginning of the workflow to check if the email is found in any of the hubdb table rows.

I have operations hub and marketing enterprise.

Do you have any sample or documentation that might help/guide me in writing this custom code?

Thank you!

@ChrisChiha

Re: Automated Email - Populated using HubDB & HubL

Teun — Fri, 27 May 2022 07:05:13 GMT

Hi @ChrisChiha ,

I wrote this real quick, so could be some errors, but it could look something like this:

You can then use the 'rowFound' property in the output to handle the following steps of your workflow (you might have to use the Copy to Property action first).

Re: Automated Email - Populated using HubDB & HubL

ChrisChiha — Mon, 30 May 2022 05:23:13 GMT

Hello @Teun ,

I was able to get this code working, but it is always returning True even when there is no match. The outcome is right (Giving me 0 matches), but the code is still considering as True. I guess the problem is with the If statement, as it is considering any log as "True", even if the log is showing no matches.

UPDATE:
It worked, just had to replace the if statement by the below. Thank you !!

if (response.data.total > 0) {
rowFound = true
}

Re: Automated Email - Populated using HubDB & HubL

Teun — Mon, 30 May 2022 06:17:58 GMT

Awesome! Happy you got it working!