Checkbox checked values from many-to-many table

[otavionestares]

Hello everyone!

In my web app, I have a products CRUD. The products can have a lot of categories, for this, I created a many-to-many table with category_id and product_id. I was able to record the categories selected (with checkboxes) to the database (thanks for @ben post), but I can’t figure out how to show the selected categories with checked checkboxes on update form.

Any tip?

Thanks!

[mebeingken]

Hey Otavio,

Use a repeat to display a check box for each of your available categories. On the checkbox use a dynamic attribute - Checked - and select the field from your data that determines if it should be checked or not.

–Ken

[George]

Maybe this will help:

Dynamically Check Multiple Checkboxes

In this tutorial we will show you how to check multiple checkboxes, based on a database value. This is useful if you are using an update record form, or some details page which show multiple checkboxes that rely on a dynamic value. In our case this is our update record page, which shows reservations info: [Screenshot_20] We insert the values from the checkboxes in our database in a single field, comma separated: [Screenshot_21] So, let’s add the checkboxes on the page. Select where you wa…

[otavionestares]

Hey George! Thanks!

I checked this and tried do the same procedures, but instead of using a field with the IDs, a query returning the categories ids of the product, but not worked

I tried to create a flow to add the categories retrieved from the database query to a variable or a text input, but couldn’t make it happen…

[otavionestares]

Hey Ken! Thanks for your reply!

Still not working

Repeat

Checked Dynamic Attribute: I’m using here, a query already loaded by the form, using the product_id as a parameter, only the the products categories are returned.

On “Checked” should I have to compare values? For example: check if checkbox value is == to query returned value?

Thanks!

[mebeingken]

@otavionestares

On “Checked” should I have to compare values? For example: check if checkbox value is == to query returned value?

Somewhere you have stored in the db whether or not each checkbox has been checked. So yes, in the Checked attribute, you need something that will evaluate to true/false.

[otavionestares]

Hello everyone!

Just found a solution!! I created a custom query and used a MySQL function called GROUP_CONCAT. This function returns rows in columns and you can use SEPARATOR as parameter.

This query:

SELECT GROUP_CONCAT(category_id SEPARATOR ',') as category_id
FROM ProductCategory where product_id = 18;

Returned “3,6,1”. Then, on front end, I used the split method and “checked” dynamic atribute, just like the tutorial @George suggested above.

Thanks for the replies and I hope this can be helpful!