How to sort Product by Category?

Need help Database
1

Hello,
I have 2 custom data types Product and Category.
Both have Name field, and Product has Category field.
I already displayed the table that has 2 columns (Product Name and Category Name) using Repeating Group.
Then, I just want to sort the table by Category Name, but I can not find the Category field in the dropdown list.

I am not sure if the Bubble.io originally support or not.

Please help me to solve this issue ASAP.
Thank you.

image
image741×373 18.7 KB

2

On Product data type add a field called category_name and make of type text

3

Hello, @boston85719
Thanks for your reply.
However, I want to avoid duplication of the category name field.
Can you suggest other solutions without duplication?

4

Okay

No, it is not possible to sort by another data type value

1 Like
5

Thank you very much.

1 Like