Discussions

Expand all | Collapse all

Pipeline - How can I use a variable in Action

  • 1.  Pipeline - How can I use a variable in Action

    Posted 22 days ago
    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
    ------------------------------


  • 2.  RE: Pipeline - How can I use a variable in Action

    Posted 21 days 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.


  • 3.  RE: Pipeline - How can I use a variable in Action

    Posted 21 days 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
    ------------------------------