Good morning friend, I would like you to help me with the following:
I have two tables, one called category and the other products.
I have two Repeating groups listing each one, in the products group I have a type of data called category where I store which categories each product belongs to, for example, one two categories: others and technology, and one product, for example: lamp, that product I save those two categories in the categories field.
Sorry if the explanation is long, but the help I need is if when you click on the product in the list of categories, show only the ones it belongs to and hide the others.
How are the relations between Product and Category determined? Product data type has a list Category field or Category data type has a list Product field?
Works!! But one extra question and I hope it’s not too much of a hassle, but can it be done so that if the custom state action has not yet been executed, it shows the complete list of departments when starting the application?
for default data source use ordinary Do a search for Companies
for conditional data source (conditional tab) check if SelectedDepartment custom state is empty. If not - change data source to SelectedDepartment's Companies