I have a bot where the user picks two dates then clicks on an action button to receive a PDF report via email. These two dates trigger various Ref columns to recalculate and are used in the report. The client now also wants this to run at 0200 every monday. So I had a brainwave...
Rather than create a whole new template file, all I had to do would be create a copy of the bot setup to run on a schedule. Then have it write [From Date]=Today()-7 and [To Date]=Today()-1 into the cells where the user would manually change them. Then I could use the same template file. Except... you can't do this.
As the bot is scheduled, it's process can't be associated with a table. So the process cannot select a data action. Neither can you create a data action from within the process. The error I get is "Run Action steps are not allowed for processes without an input entity"
Anyone know how to get around this with me have to either:
Solved! Go to Solution.
Also please check the below highlighted setting (ForEachRowinTable) is on
Can you modify the template such that if the user chosen dates are empty then use a default assigned based on your formulas above?
Yes I can do that and thats how I normally do it. I thought I was being clever doing it this way...
Also please check the below highlighted setting (ForEachRowinTable) is on
Thats it 😁 I knew it would be something simple
Or try with a "call a process" step.
User | Count |
---|---|
43 | |
30 | |
26 | |
14 | |
14 |