Pipeline - How can I use a variable in Action

Question

Hi there!I am creating a pipeline to automate my month end reporting.&nbsp; I intend this to run (preferably automatically on first of every month for the last month). The first task is to create the no. of tickets for the last month.&nbsp; I query all the tickets and wish to count the no. of tickets. I see that i don't have a action for that, whereas I have action to add a record, update a record or delete a record, but I have no action to count the records. How can I do that ?&nbsp;For a moment, i thought I can use templating language (ninja, which pipelines is based on), but had no luck.&nbsp;Can anybody help ?regardsdinesh------------------------------DineshDineshdinesh.rampal@apollotyres.com------------------------------

austink · Answer

Would it be acceptable to just have a summary field that matches your query that would show you the total amount of tickets over the previous month? Then you would just query for what was in that field to get your number of tickets.

markshnier__you · Answer

Dinesh,I suggest a different approach which is easier than a Pipeline.Make a helper table with one record in it.&nbsp; It will be Record ID# =1.Make a relationship to your Tickets table by making a formula field on Tickets&nbsp; equal to a 1.Then make any summaries on that table for your counts.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Forum Discussion

Pipeline - How can I use a variable in Action

Related Content

Using variables with class='SaveBeforeNavigating

Three Words of Advice on Pipelines

Pipeline Not Triggering

Global Variables and pipelines

Three Words of Advice on Building Pipelines - Brittany Scheid