Limit number of displayed rows

Question

Hi All,I have a field that is a proxy to another table which is growing, is there a way I can restrict the size of the list in the dropdown to, lets say 5, or bring the "Create new record" button to the top of the list?------------------------------Regards,Gustavo Cota------------------------------

markshnier__you · Answer

Maybe just suggest to the users to type xxx, get no hits and then you will at the Add New button right away.

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

gustavocota · Answer

What If I wanted to have the same functionality as that "Create new" button but in a URL formula field, what the url should be in order for the new record to populate the dropdown?

------------------------------
gustavo cota
------------------------------

markshnier__you · Answer

There is not a way to do that with a URL formula button, because you would need to create the new parent record and obtain its Record ID, and then use that to connect the child Record to it. The problem is that there is nit a way to get the record ID until the record is actually created.

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

gustavocota · Answer

Maybe I didnt explain myself correctly.I am creating a record where I have a dropdown with a bunch of existing elements. At the end of the dropdown the "create new" button allows me to create a new element for the dropdown and then adding it to the list without first saving the main record.I guess the "create new" button calls a url to open the new window to create a record "on-the-fly" thus without requiring the ID of the main record.That url is the one I would like to add to a URL formula field------------------------------gustavo cota------------------------------

markshnier__you · Answer

The URL formula to pop up an add record form isURLRoot() &amp; "db/" &amp; [_DBID table name goes here from advanced properties]&amp; " &amp; ?act=API_GenAddRecordFormIf you want to return to the record that you launched off of then you would suffix that with&nbsp;&amp; "&amp;z=" &amp; Rurl()so&nbsp; it would be&nbsp;URLRoot() &amp; "db/" &amp; [_DBID table name goes here from advanced properties]&amp; "?act=API_GenAddRecordForm"&amp; "&amp;z=" &amp; Rurl()This is the same syntax you see auto generated for the Add child button on all relationships.&amp; "&amp;z=" &amp; Rurl()"------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Forum Discussion

Limit number of displayed rows

Related Content

Calculation/Performance Limits Inquiry

Reference Numbers Displaying Instead of Names in QuickBase

Display Thumbnail Image

Roundup whole number

Limit the number of displayed rows in reports when editable on the form