I have this situation:
But I need to have December 2021 only on the first row created in December. When a new row will be added in January only the first row in January will have “January 2021” on column Month.
Tried to do it with IF and AND but still gets an error.
Could you please help me with this?
Thanks for the clarification. Unfortunately grouping in Airtable won’t help with that because you’re using field data as part of your interface in Webflow, but Airtable’s grouping structure only affects the display of the data, not the data itself.
That said, there is a way to do what you want, but the method to set it up will depend on the design of your base. In that light, I’ve got a question: what determines which item should be listed first for a given month? Is it based on a date field where the entered date is before all of the others? Is it set manually by dragging a record to the top of the list? Something else?