HubDB Editable Table Sort Row

Woodsy
Top Contributor

Hi all, is it possible to reorder the row listing in an editable HubDB table? A number of applications offer the ability to click on the column title and sort order by ascending or descending (alphabetical or numerical). I have attached a screenshot to show. I have a resource order column that displays the resource in order on the website. As the list grows I may need to reorder the resources on the website.

 

Hubspot Screen.png

 

Currently I create a new row (at the bottom of the table) and add a number to the resource order. If I want to make this new resource show 3rd on the website I need to change all the numbers in the HubDB to fit this in. I have to scroll up and down the list increasing the numbers of other resources by +1. This would be easier if I could select the resource order column title and choose an option like sort the editable HubDB rows by ascending numbers (like excel).

Excel.png


This would put the rows in the correct order so that they could be easily updated rather than scrolling up and down to find the next number in sequence to update.

 

I'm hoping that I am just missing something as this functionality should be a standard way to sort a database.


Thanks

0 Upvotes
1 Reply 1
amwilie
Key Advisor | Elite Partner

Sorting and reordering rows is not a functionality within HubDB.  I agree it's a pretty standard database function and it's unfortunate it's not an option.

 

For now the best way to go about reordering is to export the database to a CSV file, open in an application like Excel, sort there, and then import back into HubDB.

Alyssa Wilie

Web Developer at LyntonWeb

If this answer solved your question, please mark it as the solution!