Forum Discussion
gustavocota
Qrew Member
Thanks Sam,
I was interested in having few records in a dropdown instead of the the entire list from a table so the "Create new" button is available without scrolling down.
So If I use this option and the user creates many of those records during the same session, a scroll down will be required eventually, which is what i want to avoid. Before I have asked if a report can be made to limit records to the first 5 or so and I think there was no way to do that yet.
------------------------------
gustavo cota
------------------------------
I was interested in having few records in a dropdown instead of the the entire list from a table so the "Create new" button is available without scrolling down.
So If I use this option and the user creates many of those records during the same session, a scroll down will be required eventually, which is what i want to avoid. Before I have asked if a report can be made to limit records to the first 5 or so and I think there was no way to do that yet.
------------------------------
gustavo cota
------------------------------
SamJones1
4 years agoQrew Cadet
Personally, I'd just make a "Create New" button and put it next to the drop down, rather than trying to keep the list short.
If you want the list to always be the 5 most recently created, you could create a universal parent record, relate all the newly created records to that so you can get the maximum record id, then create a report formula to limit to only the 5 greatest Record IDs.
If you need more help actually implementing that, swing by Data Collaborative's free Office Hours, every Thursday at 1pm Eastern.
Sign up here:
https://data.quickbase.com/db/bqeqqj33i
------------------------------
- Sam
______________________________________________
Sam Jones
Vice President, Product and Technology
he/him
The Data Collaborative, Inc.
sjones@datacollaborative.com
366 Massachusetts Ave, Suite 203 | Arlington, MA 02474
------------------------------
If you want the list to always be the 5 most recently created, you could create a universal parent record, relate all the newly created records to that so you can get the maximum record id, then create a report formula to limit to only the 5 greatest Record IDs.
If you need more help actually implementing that, swing by Data Collaborative's free Office Hours, every Thursday at 1pm Eastern.
Sign up here:
https://data.quickbase.com/db/bqeqqj33i
------------------------------
- Sam
______________________________________________
Sam Jones
Vice President, Product and Technology
he/him
The Data Collaborative, Inc.
sjones@datacollaborative.com
366 Massachusetts Ave, Suite 203 | Arlington, MA 02474
------------------------------