How can I format boolean type for data source type JSON?

posted on July 12th, 2021

Answered

Rodrigo Arantes asked on July 12, 2021

Here is a data source config example:

datasource: {
   type: "json",
   data: [{
     firstName: "User",
     lastName: "Peixoto",
     salary: 90000,
     birthDate: "2020-12-31",
     terminated: false,
   }]
}

Is there a data type boolean or formatting setting for it? Couldn't find it in mapping object.

6 answers

Public

Mykhailo Halaida ⋅ Flexmonster ⋅ July 13, 2021

Hi Rodrigo,

Thank you for posting your question.

Flexmonster does not provide a separate field type for boolean values. Instead, by default, they are recognized as regular string fields.

Please let us know if this helps.

Best regards,
Mykhailo

Public

Rodrigo Arantes ⋅ July 13, 2021

Hi Mykhailo,
What is the best approach to instead of displaying "true" or "false" we display a friendly format like "Yes" or "No"

Thanks

Attachments:
Screen Shot 2021-07-13 at 09.59.09.png

Public

Mykhailo Halaida ⋅ Flexmonster ⋅ July 14, 2021

Rodrigo,

Thank you for your response.

The preferable approach in this situation is to modify the data source so that it already contains the "Yes"/"No"-value field you want to display.

However, it becomes easier if you're using inline JSON data as your data source: you can set up a data preprocessor on the client-side that will add the necessary field to the data before feeding it to the pivot table. This way, the original data stays unchanged, but it is also displayed as necessary in your Flexmonster instance.

Here's a quick example demonstrating this approach: https://jsfiddle.net/flexmonster/ru6fz1vj/.

Hope this helps!

Regards,
Mykhailo

Public

Rodrigo Arantes ⋅ July 14, 2021

Hi Mykhailo,
That's what I was trying to avoid. Wanted to see if there was something built-in related to data formatting.
Thanks for quick response

Public

Mykhailo Halaida ⋅ Flexmonster ⋅ July 15, 2021

Hi Rodrigo,

I just realized there's a much simpler solution involving the customizeCell() API call.

It does not require you to modify the input data – instead, you simply rewrite the cell labels in the grid without affecting the underlying data.

Here's a sample for demonstration: https://jsfiddle.net/flexmonster/w6uvf3Lm/.

Does this solution suit you better?

Regards,
Mykhailo

Public

Rodrigo Arantes ⋅ July 15, 2021

Hi Mykhailo,
That's the one I went for.

Thanks a lot for the follow up ?

How can I format boolean type for data source type JSON?

6 answers

Please login or Register to Submit Answer