How can I use a Confiform table view to sort ASC by date, LIMIT 5, but keep the most recent entries?

[Brian Robbins]

I need to sort Ascending (oldest date at the top) but I only want to show the 5 most recent entries. I want new entries to filter up from the bottom, and the oldest one to pop off the top.

I'm using this to create a very simple schedule. One person per week, only displaying 5 records at a time.

[Brian Robbins · Accepted solution]

I put a filter on the Table View rendering the form. Any date less than today gets filtered out, limit of 5, and sort by date ASC!

[Alex Medved _ConfiForms_]

You can sort like this

created DESC LIMIT 5

That is to set in a TableView's 

 

[Brian Robbins]

The dates are being submitted in chronological order, for an upcoming schedule, so this puts farthest date out at the top. I want the oldest date at the top. 

I want to sort, limit, then re-sort.
I'll try ordering by created desc, then date Asc... not sure if that's going to be helpful, but it's something.

[Brian Robbins]

As a workaround, I'm hiding the registration form to add new entries and leveraging the in-line edits feature.