Here is my slice (called Order Needed) that I want to automate emails for:
<<SELECT(Order Needed[Product Name],TRUE)>>
<<[SKU]>>, <<[Manufacturer]>>, <<[Current Inventory]>>, <<[Minimum Acceptable Inventory]>>, <<[# to order]>>
<>
These are my error messages:
I believe the issue is that process using the Task (โNew processโ) is not using the matching table. If you go to the โProcessesโ tab, you should be able to verify/modify that.
Note, processes operate on Tables, so you wonโt see your slice in the dropdown. Youโll need to choose the table that โorder Needed (slice)โ is based on.
Hey Jared,
If I change the Processes table from โnoneโ to the table that my slice references, it will give an error unless I change to โForEachRowInTableโ and in that case, it sends me hundreds of emails. In our existing inventory app, we just have our vendor login weekly to it to see what to order. I think I will just do that on this as well. What I would like to still automate though is if the order needed is greater than ten to send an email to the vendor. I know I will have to sum the numbers in the โ# to orderโ column in my slice, but if you have any advice on doing that and triggering an email when it does that would be great.
Thanks!
Hi @Ryan1
Your approach is correct, we would need to look into your data and template to understand the errors that are showing up.
If you could send an email to support@appsheet.com, include your userId, AppName, Bot name and allow support access to your app then we will investigate the issue.
Thanks
User | Count |
---|---|
35 | |
35 | |
28 | |
23 | |
18 |