Data Grid Question

Unknown

Data Grid Question

Unknown

I have a DataGrid that has some data within it. One field is named “isActive” and it is an integer field within SQL that all records contain 1 or 0. I am looking to have this IsActive field show up in the data grid as a checkbox. My question is, does the field within SQL need to be a Boolean to make that happen, or is there a way to force it to show up as a checkbox within Decisions when it is an integer field?

Thank you in advance!

Unknown

There is no way to achieve this natively, unfortunately. You might be able to get creative, and use a data repeater within the data grid, and do a series of mapping/conversions to get there, but Im still not sure how well that would work for your use case. Additionally, you could experiment with javascript, and check the option to allow unsafe javascript and see if you can create something that way, but it wouldnt be something that would be supported if that makes sense.