Output Checkbox to Microsoft Word File

Question

Hi all,

I am generating a report that will hybrid, a part is automated and another part is manual, so I need to see the check box on this way, showing on my output file:

Does someone know if there is a tool that can help me? I guess if the type of data is boolean, I have a part of the solution, but I need that the information will show on this way that can you see above.

viniciusnp31 · Answer

Hi, Yoshiro!

Tks for your answer, but I want to add a "check box contents control" which can be actively set to on and off, I will verify if I can do it by VBA

Yoshiro_Fujimori · Answer

Hi @viniciusnp31 ,

If you just want to show check box as a character, you can convert your boolean value "TRUE" to “☑” (U+2611) and "FALSE" to “☐” (U+2610)

(or whatever charactor code you like) with Formula tool and output it to MS Word file.

If you want to add a "check box contents control" which can be actively set to on and off, I do not know how to do it on Alteyrx.

I guess it is a scope of VBA, which I am not familiar to.

I hope this can be of some help.