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

Question

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
------------------------------

shannonhenry1 · Answer

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
------------------------------

evanmartinez · Answer

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&nbsp;top&nbsp;parameter.&nbsp;https://developer.quickbase.com/operation/runReportSo the query would be something like
https://api.quickbase.com/v1/reports/511/run?tableId=bck7gp3q2&amp;top={{a.limit}}Or as Shannon was mentioning you can use an advanced query to help with that, specifically _fidX in an advanced queryhttps://help.quickbase.com/api-guide/do_query.html#queryOperatorsUsing the value in another field as the matching value------------------------------Evan Martinez------------------------------

markshnier__you · Answer

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
------------------------------

emmafinger1 · Answer

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------------------------------

natekurtz · Answer

I am attempting a similar thing here and running into a wall.&nbsp; For context, we are trying to use this pipeline to automate ticket creation.&nbsp; So when we want to ship x pieces of equipment we will put a number in a field in the main form.&nbsp; The pipeline would then run and do a search on our inventory, then create a ticket for the number of units we want to ship.&nbsp;&nbsp;Everything seems to be working but i can't reduce the number of results returned when searching the records.&nbsp; My "Search Records" step in the pipeline is returning all of our inventory (which I want) but then i can't reduce the number of results based on a field.&nbsp; Looking at the list of criteria i can use in the advanced query i am drawing a blank for what to use.&nbsp; &nbsp;Any suggestions?&nbsp; Did this solution end up working for your use case?------------------------------Nate Kurtz------------------------------

Forum Discussion

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

6 Replies

Related Content

Pipeline Make Request - Return Make Request JSON Output into fields

Button: save the new record and edit the new record

How to add list of attachments on child record from parent record

Get latest child record on parent record

Duration Fields with Pipelines

Recent Discussions

Summary Table Question

Google Search is back

Can I use quickbase actions within the same table?

Looking for Consultant: Add time tracking to existing task management app.

Share your feedback on the new Qrew Discussions