email automation

[jokaa]

Dear All,

I created an automated email into my application and set it to pull the topic's name into the subject and the email's text as well:

If I check the preview of the email, it works fine:

However, when I try it and it actually sends the email, it pulls the date instead of the name of the topic:

Do you have aby idea on how to fix this?

Thank you in advance!

[AleksiAlkio]

Without seeing your data, it sounds your row contains that date in "Topic" column.

[jokaa]

Hi, I ended up rephrasing the email as it pulled random data (eg for Topic it pulled the date, for member it pulled the timestamp).
Now the issue I am facing with this email is that it doesn't send the email at all at deployed stage. 
Originally it should pull the email from a request form, in preview it seems to work fine:

If I test the expression, it finds the emails as well

But for some reason it tries to send the email to a timestamp:

Do you maybe know how to fix this?

Thank you in advance!

[AleksiAlkio]

Any chance that your column structure doesn't match with the spreadsheet or the opposite. Please double check that they match exactly.

[jokaa]

Hi, I double checked, the column structure does match with the spreadsheet:

This is how the automation looks like:

It checks whenever there is a session created on the Sessions tab the topic of which matches with the topic in the Session Requested tab

and then it should send an email to the email address captured on the session required tab:

the email is captured correctly

if I check the email part of the automation, it also catches the email address correctly:

then when it comes to sending the email, it wants to sent it to a time stamp

I have no idea what else to check 😕 

[AleksiAlkio]

Any chance that the Ref table "Members" has a date column set as a label? That I'm not able to check from your screenshots.

[jokaa]

Hi, the members tab ha no date column:

[AleksiAlkio]

How about in "Topics" table that the "Topic" column refres?

[jokaa]

this is how the topics table looks like

[AleksiAlkio · Accepted solution]

It sounds like that every time when you trigger this Bot, it reads the time and use that for the email address. I think it would be better to file a support ticket and ask devs the check what's the reason. This sounds weird.