Question:
Hello, I’m currently working on a website for my program -
I need some help to create the following: the table is to display our call schedule - for our medical residency program.
So the first column are the dates, and then each subsequent column is a medical team, and in the cells are the names of the doctors working that team and date.
(see the attached picture)
What I want to do:
- table should populate data external google sheets - so that when the sheets is updated/edited, it automatically updates on the actual website.
- freeze the first row and column so when a users scrolls, those two are frozen in place (like you can do in excel)
- be able to sort the columns and rows (like alphabetically, low to high)
- also allow the user to search the whole table i.e. search for their name and it gets highlighted on the table
- be able to filter the table according to certain criteria. i.e. filter by the “Block”, filter by “name” - so if user chooses “BLUE” for example, only the BLUE column would show up.
- Be able to choose a date from a calendar which then filters the table accordingly - so it would only show the row corresponding to that date
- create categories - so show one month, for example, then be able to click “next” which then shows data from the next month.
Product:
Currently, my table is connected to a data set on CMS. I’ve tried to code everything under Velo for Wix on the page where my table is at, but it’s not working for me. I’m new to javascript, so I don’t really know how to code it properly.
What are you trying to achieve:
see above.
What have you already tried:
I’ve read all of Velo’s documents, and also used chatGP - but it’s not working for me.