nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Brian Robbins_257ti8

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.

Accepted answers

Brian Robbins_257ti8

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!

All comments

Alex Medved _ConfiForms_

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_257ti8

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_257ti8

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

Brian Robbins_257ti8

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!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

atlassian-marketplace

data-center

addon-com.vertuna.confluence.plugins.confiforms

confiforms

atlassian-marketplace-data-center