Hi everyone!
Iโm trying to create a bot to notify actualization of my data base and send a PDF attach in the same email.
Iโve got the email report but I donโt receive any PDF even I configured it in the task โsend an emailโ.
I donโt know how to do it and only find information about the workflow process but not about do it through the bot tool.
Could anyone help me, please??
Thank a lot.
Daniel
In the task, unselect โDefault Contentโ to get some choices
Finally, Iโll get it. I had the option unselected but I think there was other bot selected.
Do you know if I can change the text generated from and answer to the email? I meanโฆ I know how to fill a text with the answer but in the Yes/No question the result start with a Y. o N. and generate a text difficult to read. Do you know how to omit it and change for the standard answer I write?
Thank you a lot for your answer.
Send me an example of your text and Iโll give you a more specific answer. But basically youโd use CONCATENATE() with something like IF([Column Name]=TRUE,โYesโ,โNoโ)
Thank you Simon.
An example could be something like this (Itโs in spanish so thatโs a translated example):
In the form app there is a question about the vaccination status of the patient like: โHas the patient started the vaccination schedule?โ
If answer is Yes, I want to write in the text report โThe patient has started his vaccination process with ---- (information in other question)โ.
If answer is No, I want to write in the text report โThe patient has not started vaccinationโ.
Thatโs not the exactly question because of the language but I think itโs helpful. Now in my text report I get:
If yes: Y: The patient has started his vaccination process with ---- (information in other question).
If not: N: The patient has not started vaccination.
And I want to get out the โYโ and โNโ.
Iโll try with the concatenate functionโฆ "IF([Vaccination process]=TRUE,โThe patient has started his vaccination process with <<[(vaccinations started)]>>โ,โThe patient has not started vaccinationโ).
Iโll tell you something when I fix the bot to send reports jajaja I donโt know what happen since yesterday but I got the PDF report in good conditions and later I lose itโฆ
<<IF(
[Vaccination process]=TRUE,
CONCATENATE("The patient has started his vaccination process with ",[Other Column Name]),
"The patient has not started vaccination"
)>>
User | Count |
---|---|
42 | |
28 | |
25 | |
22 | |
13 |