Forum Discussion

DineshRampal's avatar
DineshRampal
Qrew Cadet
4 years ago

Pipeline - How can I use a variable in Action

Hi there!

I am creating a pipeline to automate my month end reporting.  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.  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 ? 

For a moment, i thought I can use templating language (ninja, which pipelines is based on), but had no luck. 
Can anybody help ?

regards
dinesh

------------------------------
DineshDineshdinesh.rampal@apollotyres.com
------------------------------
Pipelines

2 Replies

Sort By
  • AustinK's avatar
    AustinK
    Qrew Commander
    4 years ago
    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's avatar
    MarkShnier__You
    Qrew Champion
    4 years ago
    Dinesh,
    I suggest a different approach which is easier than a Pipeline.

    Make a helper table with one record in it.  It will be Record ID# =1.

    Make a relationship to your Tickets table by making a formula field on Tickets  equal to a 1.

    Then make any summaries on that table for your counts.



    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------