Hi,
I am just looking for a general guide of creating an email report from a table slice using the new bot/process/task system. I have the email portion set up, however when I go to run the reports, the reports are empty. Any thoughts?
Thank you for this. I appreciate it
Hi
Iโve tried for weeks to try to create a bot that sends a report for a slice at 5 am everyday and have had no luck. I have built a task and have built a process for the task, however the bot doesnโt accept the slice as a valid configuration. Any assistance?
You setup the Bot for the base Table, then you reference the Slice in your reportโs template, using a START expression.
So Here is my template for this report
what am I doing wrong. The slice is at the start expression, then the columns I want on the report, then an end expression, yet it is not executing.
Security Actions For Nampa OK MHP
<<Start:Nampa OK MHP>>
Property: <<[Properties].[Name]>>
Patrol Action: <<[Patrol Action].[Action]>>
Time: <<[Time]>>
Tech: <<[Tech]>>
<>
START expressions require a List of key values. You just put the slice name, thatโs not enough, add in the key column.
<<START:Nampa OK MHP[key-column]>>
So?
I just told you how you had to change your template from your previous post, did you try that?
Iโd suggest you review the help article on start expressions again.
Iโve added key column to the top of the template and it sends every record on the security table not just the slice I want. Also wanted to add Iโve reviewed the document several times and I am still unsure as to why it isnโt performing the action I want.
Iโve set the bot, event, process and tasks to Security (Base Table). Iโve then used your suggestion to create an email template:
<<START: Nampa OK MHP[Key]>>
Property: <<[Properties]>>
Patrol Action: <<[Patrol Action]>>
Time: <<[Time]>>
Tech: <<[Tech]>>
<>
If you are done helping let me know and Iโll ask in then general forum again. no sense asking twice.
What is your sliceโs row filter condition ?
I set it to [Properties] = โNampa OK MHPโ and the result was what I wanted. Thank you for your help and patience.
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |