How show values the checkbox type?

How to display saved checkbox values from a database.

Overview

The issue occurs because checkbox values are stored as JSON-encoded strings in the database but are not being decoded when retrieved.
Enable JSON decoding in the Read Data settings for the specific field to properly convert and display the stored values.

Answered
ChronoForms v6
oz ozkrsanchez 03 Nov, 2020
Hi everobody,

I have a field with checkbox. I save field correctly. In the database the field is type VARCHAR(255). When i want show the values not work.

I will show the pictures of what happens

1. Information input.
How show values the checkbox type? image 1

2. Field in Database
How show values the checkbox type? image 2

3. Field in debug
How show values the checkbox type? image 3


4. Checkbox when trying to display the information.
How show values the checkbox type? image 4


5. This is the Read Data I use.

How show values the checkbox type? image 5


I appreciate your collaboration to solve my problem, I need to show these checkboxes as they are protected in the database.
Max_admin Max_admin 03 Nov, 2020
The field value should be JSON decoded in the Read Data, there is a setting for this in v6 and also in v7, but v7 is recommeded!
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
oz ozkrsanchez 04 Nov, 2020
Answer
Hi everybody,

I found the solucion, the code used is:

{var.jsonde:read_data_name.model_name.column_name}
This topic is locked and no more replies can be posted.