I have an “Events” collection which holds information for events during the year. I want to be able to have two text boxes for “this month’s event” and “next month’s event”.
I think the solution is to pass the value (e.g. this month or next month) to the collection filtered against the “Event Date”). I get the correct single item when filtering for either this or next month when directly filtering on the collection but I want to have both events on the same page dynamically populated.
In my head this is easy.
I can imagine a SQL query for this
Box 1: Select event_name where event_date = “this month”
Box 2: Select event_name where event_date = “next month”
Sadly my Corvid coding is not as good as old school database code
Appreciate any help
You can filter a query of your Events collection for each of the two text boxes (this month and next month).
I would suggest learning about Wix Data and using Wix Data with Corvid . You can also look over Wix Data API to see what is possible to do with Wix Data.
Play with the Search a Database example to see how to work with a database. The Corvid Resources page provides tutorials, examples, and articles on getting the most out of Corvid.