Dear Wix Code Maestros
I have a dataset (TopSanta) that contains 100's of rows of holiday information. Within the dataset I have a column for a Family of 3 price (fam3), a Family of 4 price (fam4) and a Family of 5 price (fam5).
I want people to be able to display the information in a table (Table4) based on 2 selection they make from a drop down user input. 1st the airport they want (#selection1) & 2nd their family size (#selection2).
Can anybody advise how I change the column I display depending on the family size selected?
Hi! The most easiest option i see here - create 3 tables and expand/collapse them, depending on user input
In case it's not suiteable and you need combminations of coulmns - you should stop using databinding and fill in your table with code with this property: https://www.wix.com/code/reference/$w.Table.html#columns
And take data from collection using this: https://www.wix.com/code/reference/wix-data.html