Discussions

Expand all | Collapse all

Limit the number of records returned in Pipeline using a field value

  • 1.  Limit the number of records returned in Pipeline using a field value

    Posted 23 days ago
    Does anyone know how to limit the number of records returned in a pipeline quickbase channel records search using the value in another field as the criteria?  I know that we can hard set the limit using the limit field in the step, but I need the ability for it to depend on the value in a field.

    ------------------------------
    Emma Finger
    ------------------------------


  • 2.  RE: Limit the number of records returned in Pipeline using a field value

    Posted 23 days ago
    I have not tried this myself but did you try dragging a field from one of the fields on the right hand panel into the limit box?

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Limit the number of records returned in Pipeline using a field value

    Posted 22 days ago
    Hello Mark,

    Yes, the limit field will only except 2 characters and if you try to enter anything besides a number it displays a warning and will not allow it.

    ------------------------------
    Emma Finger
    ------------------------------



  • 4.  RE: Limit the number of records returned in Pipeline using a field value

    Posted 22 days ago
    You need to use the Query section that appears below Limit. It'll be collapsed initally, but once you expand it you can select any of the fields you chose above as output and set criteria on them.

    ------------------------------
    Shannon Henry
    ------------------------------



  • 5.  RE: Limit the number of records returned in Pipeline using a field value

    Posted 22 days ago
    Hi Emma,

    there is a couple of options available when setting up a Pipeline like this but they do take some steps beyond the drag and drop builder.

    You can use the QB API and specify the top parameter. https://developer.quickbase.com/operation/runReportSo the query would be something like
    https://api.quickbase.com/v1/reports/511/run?tableId=bck7gp3q2&top={{a.limit}}

    Or as Shannon was mentioning you can use an advanced query to help with that, specifically _fidX in an advanced query

    https://help.quickbase.com/api-guide/do_query.html#queryOperators
    Using the value in another field as the matching value

    ------------------------------
    Evan Martinez
    ------------------------------