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

Brian Robbins
Contributor
August 28, 2024

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.

2 answers

1 accepted

Suggest an answer

Log in or Sign up to answer
0 votes
Answer accepted
Brian Robbins
Contributor
August 28, 2024

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!

1 vote
Alex Medved _ConfiForms_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
August 28, 2024

You can sort like this

created DESC LIMIT 5

That is to set in a TableView's 

Screenshot 2024-08-28 at 20.05.46.png 

Brian Robbins
Contributor
August 28, 2024

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
Contributor
August 28, 2024

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

TAGS
AUG Leaders

Atlassian Community Events