Checkboxes view [decode JSON]

Decode JSON checkbox data in a CF view.

Overview

The issue occurs when JSON-encoded checkbox values from a database display as raw arrays instead of decoded, readable text.
Use the Special Fields advanced setting in the Read Data action. Set the data path to your field name and select the Decode JSON processing function to automatically convert the stored JSON into individual values.

Answered
ce cesarvelame 01 Jun, 2020
Hi, I'm trying to decode this checkbox field in a view.

I used this code: item.quempode/json in the special fields on the read data but no success.

Model Name: item
Field Name: quempode

Reference: https://www.chronoengine.com/forums/posts/t104651/checkboxes-not-checked-when-loading-record

Checkboxes view [decode JSON] image 1
he healyhatman 01 Jun, 2020
So you have JSON stored in an array, is that right?

If so: {var.jsonde:read_data_name.model_name.column_name}
ra rafaelscouto 26 Nov, 2020
I created a custom code to read data from a database, where I get the return as follows:

$ this-> data ['list_array'] = $list_array;

how can i use that json option?
Max_admin Max_admin 27 Nov, 2020
Answer
in the Read Data in v7 use the Special fields advanced setting to auto decode a field directly in the loaded data list!
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
ra rafaelscouto 04 Jan, 2021
I'm trying to popularize a dropdown but I haven't seen a tutorial on how to do it on cf7.

in my table in the database, I have a column:

tab_days with the values ["1", "2" ...]

My drop-down menu looks like this:

<div class = "item" data-value = "[1,2]" data-text = "[1,1]"> ["1", "2"] </div>

how do I make it look like this:
I want to separate the items

data-value = 1 data text = 1
data-value = 2 data text = 2

...
Max_admin Max_admin 08 Jan, 2021
how did you get it to list the options in that format ?
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
cr cruser 02 Mar, 2022
The Read Data in v7 (using the Special fields advanced setting to auto decode my field request) I still get the value returned as ["Building Issues"]

My data path is: request and the Processing Function is: Decode JSON

What am I missing? What I want displayed is Building Issues and not ["Buidling Issues"]
This topic is locked and no more replies can be posted.