How can I view all of the records on one page? Right now the maximum I see is 250 per page.

&options=num-n  (where n is the number of records you want displayed) to the end of your report URL.

Or URL.com/db/XXXXXXX?a=q&qid=-1000000&dr=1

This URL skips 400 records and returns a set of the next 200 records:

https://SUBDOMAIN.quickbase.com/db/xxxxxxxx?a=q&qid=1&qskip=400&qrppg=200

This API URL to skips 400 records and returns a set of the next 200 records:

https://SUBDOMAIN.quickbase.com/db/xxxxxxxx?act=API_DoQuery&qid=1&options=num-200.skp-400

------------------------------
Meredith Moore
------------------------------

i don't think that you can control that, except that If you have fewer columns it will display more records, maxing out at 1,000 records.

I see. Do you happen to know how I can reduce the size of a column? Unlike excel, I can't drag it to be shorter with Quickbase.

Columns adjust automatically according to your screen size and the number of columns and how much data is in the columns.  That just how the web works.  You can set a field not to wrap (field Properties) which would force QuickBase to make it wider, but then that might cause side to side scrolling which users don't like.

This does not seem correct.  I have two reports, each with 7 columns.  One of them maxes out at 20 records and the other one shows all 28 records.  How do I set this?

Are these table reports or summary reports?

Summary reports, even with similar data. 

I would put it all in one report, but QuickBase is limited to 3 formulas in a report and I need 6. That is because I have a drop down with 6 different choices and I want to sum the data based on the different selections in that field.

I just cannot figure out what I did differently that one report gives me the 28 records and the other puts it on 2 pages.

Do you have admin access to the app? Can you make real fields instead of report fields? Perhaps that will make a difference

Yes.  I have admin access.  I am not sure I understand what you are saying to do.

I was trying to understand this comment

but QuickBase is limited to 3 formulas in a report and I need 6.

as I'm not aware of that restriction and could not duplicate it in a test I just did.

In my testing, it appears to me that the more "summarized values" you have (ie not the groupings but how many numerical values are in each "cell" of the report, the fewer rows you get on the report.