Creating Daily Reports in Podio
A lot of times, it would be beneficial to run daily reports from specific Podio Apps. Since By Date or Day flows are not attached to an App, these Items need to be found first before they can be used in an email or pdf Report.
For example: A daily email is sent to the Accounting Manager. This email should include Items from the Invoices App that are ageing at 30 days or greater. We would also like to include a link to the specific Podio item for quick viewing.
Here is the resulting email:
Solution Explained
By using the Search for Item(s) collector, GlobiFlow can search for a specific value, whether contained in the field or by an exact match. This feature can only be preformed on single line text fields and on calculation fields. Using this search feature, we can set a By Date or Day flow to find Items to use from a specific App.
First some modifications need to be made to the Podio App template.
-
Add the field required to complete the Search. For this example, we added a single line Text field and called it Search field. This field will be updated using a Flow in a later step.
-
Next, add a Calculation field to produce the link to the individual item. This field will be added to the Detail Table of Items in the Report. Using a custom Podio calculation, we created a link using the invoice number as the display. See Podio Help for more information on how to create your link.
Note: Do not forget to do a Refresh from Podio in your GlobiFlow account after these changes have been made.
Flow Details
Open the My Flows Tab in your GlobiFlow Account.
-
The first flow we need to create is in the Invoice App that will trigger off the Invoice Due Date and set the search field. Then created a Custom Variable with a PHP IF Statement. The Variable Token is then inserted into the Search field on an Update Item action.
-
For an example, we also need to create a flow in this Invoice App to run on Update of the Paid Amount, and set the field to nothing, once an Invoice has been paid in full.
-
Now we can create the By Date or Day flow for the Email Report. Select New Flow and set the filters for the specific dates this Report should run. The time this flow runs can also be adjusted.
-
First, add the Search for Item(s) collector to find the overdue Items in the source App. This is a search on the single line text field created above.
-
Next, add the Detail Table collector to create a HTML table from the above collected items and select the fields to be used as columns in the table. Be sure to add the Calculation field created above for the Item’s HTML link.
-
Finally, add the Send Email action and compose the email template. Insert the token for the HTML Table into the body of the email.
The Accounting Manager will now receive an email every weekday, that looks like the one below.
-