Grids / Counts

Ask the community
,
1

Question:

A.) Is it possible to cross reference multiple datasets and represent the data in a grid (like excel) on a webpage.
B.) Is it possible to create a counter that cross references datasets and if the cell has value and if the cell is populated with a value then the webpage returns a numerical value

Thank you

2

Hi!

  1. You can connect a dataset only to one database. However, you can create a new database with multiple reference fields to different databases and then connect it to the dataset.
    https://support.wix.com/en/article/displaying-content-from-multiple-database-collections-using-reference-fields-4034931
    Then you can display data using Table or Repeater:
    https://support.wix.com/en/article/about-displaying-database-content-in-a-table-or-gallery
    https://support.wix.com/en/article/displaying-database-content-in-a-repeater

  2. Yes, if you use the solution above. If you want the cell value to be numerical, your database field should be of type “Number”