database - Wix filtering dataset with multi-reference fields - Stack Overflow

admin管理员组

文章数量:1287555

I have a question about filtering datasets that have multi-reference fields in them. Here is what I am trying to accomplish. I have "imagecollection" dataset with fields:

1. Each image will be associated with an aspect ratio e.g (1x1, 3x2, 5x7), based on the aspect of the image.
2. A given aspect, on the other hand, can offer different print sizes e.g. 4x6, 8x12, 12x18, 10x10, 20x20, 40x60, depending on the aspect ratio of the image.
3. Each print size can be offered in different medium (material) e.g. ("Acrylic", "Matte", "Glossy", "Fine Art").
4. Based on all the above criteria, each (aspect ratio - image size - material) combination will have an associated price.

My approach was to create an "image collection" collection and then create a database, with some fields referring to other databases e.g., "Aspect" database, "2x3 size" database and "Price database". I have also created two input fields - one for image material preference and second for image size selection, which I want to filter, based on the selection in input 1.

At the bottom of the page a price will be displayed based on the above criteria. However, I don't seem to be able to have the "image size" field display sizes, based on image material in option 1. I gather, what I am trying to accomplish would require some coding, and it is not possible to achieve without a code.

Can you please provide some direction as to how to approach this problem?

本文标签： databaseWix filtering dataset with multireference fieldsStack Overflow