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.