Hey,
I have setup email automation to summarize info from the app to app users. The problem is that the email body will return only 1 customers information back when it should return many. Ive done all the basic troubleshooting, and I am desperate for help.
Thanks!
Could you provide any more insight, I read that article and tried using start and end expressions but could not get what I needed. In my email body template, I am using this which works for 1 customer, but I need it for all the customers. If you could provide any more help, it would be greatly appreciated!
Full Name: <<[Full Name (DSHBD)]>>
Employee Contributions: <<[Employee Contributions (DSBHD)]>>
Matched Contributions: <<[Matched Contributions (DSBHD)]>>
Spread Cost: <<[Spread Cost (DSHBD)]>>
Total Contributions: <<[Total Contributions (DSHBD)]>>
It depends on what you need exactly.
Automation is a big topic, I could point you to many directions.
For example, you want multiple emails, one per user, or just one email with many users’ info?
I only want the emails to get sent to the [Payroll Contact Email]. In those emails that go to the [Payroll Contact Email], it just needs to contain the info in my previous message. In addition that customer info should only go to the [Payroll Contact Email] where the customers email address is part of the same row.
To easily break it down, the [Payroll Contact Email] should just get the customer info to their own unique company and not see data from other companies. Thanks for your for help!
Can you share your schema?
Ive tried following the provided templates from the Appsheet help center and I can still not get it to work.
https://support.google.com/appsheet/answer/11544497#customer-table-format
Any suggestions would help!
@SkrOYC
Please provide a screenshot of your template.
Please also post a screenshot of your bot’s event configuration.
Here are the bot’s event configuration:
The template I want to have the text generated in the pdf that gets emailed:
Full Name (DSHBD): <<[Full Name (DSHBD)]>>
Employee Contributions (DSBHD): <<[Employee Contributions (DSBHD)]>>
Matched Contributions (DSBHD): <<[Matched Contributions (DSBHD)]>>
Spread Cost (DSHBD): <<[Spread Cost (DSHBD)]>>
Total Contributions (DSHBD): <<[Total Contributions (DSHBD)]>>
I don’t see a <> tag.
Hey @Steve
I think that is the part that is causing me problems, this past week I have tried so many permutations/combinations using start expressions. I have followed the appsheet email template guides and I still had no luck. Im not sure what I am missing to make this email work!
You may be trying to send the info of all of the rows from the same table instead of a parent one?
If the rows are not children of any other one I think that a scheduled report may be necesary
Even if I put that the event occurs on a schedule, it does not solve my problem.
I am only receiving 1 row from the app, when multiple should be present in the email.
I feel like you have the information needed to figure it out. Perhaps share some of what you tried with Start/End.
I have followed the outlined examples here and applied them to my circumstance and if they don’t error out, the email body becomes blank…
I have exhausted so much time on this small part of the app, when it should be much simpler.
