Displaying different column in Database based on User Input

Ask the community
,
1

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?

2

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: Table - Velo API Reference - Wix.com

And take data from collection using this: https://www.wix.com/code/reference/wix-data.html