Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

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

Brian Robbins 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 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_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
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 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 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