I have a table table that represents our Call Schedule - for my hospital's medical team.
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. - i was able to do this after watching Wix Wiz's youtube video.
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.