Hi! I’m new here and I have a question, is it possible to make a database (or a collection, as I understood) full of names and pictures correlating to a specific year and then make a dynamic page in which you choose the year and it will display the table of all the names in that year and a picture on top? And also a page where you could search one of those names and it will find it along the year it’s correlated to? Like what you would do with an SQL database and tables.
(Kind of like a list of alumni names and their pictures by year)
Thanks beforehand!
Hi you asked a lot of questions, these are some steps in building what you need.
And it’s not hard.
- Activate the code tool
- Build a database, with your data, and one of the columns will of course be this year
- Then build a dynamic page for each year.
- Add a table to a page and connect it to the database.
But you don’t have to make a page for your process. You can build a single page with a table of the entire database and then do a dropdown field with all the years and perform a search function on the change
import wixData from 'wix-data';
export function dropdown1_change(event) {
$w("#dataset1").setFilter( wixData.filter()
.eq("yearbook", $w('#dropdown1').value)
);
}
First of all, thank you! and that’s exactly what I need, a dropdown list to choose a year and what to display, now I just need to figure out how to do it… and I guess searching for a name and getting results is possible I’ll try to figure that out as well… does it support fuzzy match? if you don’t know all of the name but just part of it? and just to make sure, I need to make seperate tables for each year or just a really long one?
ראיתי שכתוב בעברית אז תודה שוב על העזרה! מעריכה את זה!
For matching: Contains should write .contains instead of eq
You make one long table and only change the recipe in the yearbook column
If you have trouble you can talk
https://www.av-digital.co.il/
Bnei Brak. Israel