Sorting a repeating group with a dropdown menu option being a list

Need help Database
1

Hi,

the data type is Product and contains the field votes, which is a list of users (figure 1 below)

I would like the repeating group for Product to be filtered by a dropdown menu containing the 4 following options :

  • (no filter)
  • Created date (newest to oldest)
  • Created date (oldest to newest)
  • Number of votes (highest to lowest)

I can filter the repeating group for the first 3 options using the conditionals tab (figure 2).

To filter by Number of votes (highest to lowest), I understand I have to use
Sort by ā†’ Change which field and somehow pick Dynamic field name : Dropdown Product sortā€™s value (?? ) (figure 2)

I donā€™t understand how this is supposed to work since a count of unique users has to be performed within the field votes for each Product row before the sorting takes place. The field votes does not appear anywhere in the search.

Thanks for your help.

K.

figure 1:

24-12-22 screenshot 1
24-12-22 screenshot 1673Ɨ634 9.28 KB

figure 2:
24-12-22 screenshot 2
24-12-22 screenshot 2842Ɨ781 33 KB

2

To sort by number of votes youā€™ll need to have a number field on your product datatype to store the number of votesā€¦

Just update that number every time a new vote is registeredā€¦

(By the way, I wouldnā€™t recommend using a list of users on the product datatype, so Iā€™d suggest getting rid of that field, and using a separate datatype to store votes).

In terms of having a drop-down to determine how to sort the RG, my recommendation would be to create an option set, with your 4 sort options, each with a text attribute for the field name, and a yes/no attribute for descendingā€¦

Then just set your sort to the dropdownā€™s valueā€¦ no need to use any conditional data sources or sortingā€¦

3

@adamhholmes - One of the reasons I created a list of users on the product datatype for the votes field is to perform checks so that each user upvotes a product not more than one time.

  • Could you briefly outline what the fields of the ā€œseparate datatype to store votesā€ look like ?

  • From a DB performance point of view, will your DB tables structure suggestion be the most efficient way to sort and display say hundreds of products by number of votes for which thousands of users vote on ?

Thanks.

K.

4

The ā€˜Voteā€™ datatype will need, as a minimum, a field for ā€˜Userā€™ (which will probably just be the Created By filed, but depending exactly on your use case may need to be an additional User filed), and a Product field (of type ā€˜Productā€™).

Of course it can also include any additional data you need to store about the specific vote.

  • From a DB performance point of view, will your DB tables structure suggestion be the most efficient way to sort and display say hundreds of products by number of votes for which thousands of users vote on ?

Yes, without questionā€¦ the number of votes is irrelevantā€¦ itā€™s just a single Number fieldā€¦

1 Like