Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Output Checkbox to Microsoft Word File

viniciusnp31
5 - Atom

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:

viniciusnp31_0-1684438276041.png

 

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.

 

2 REPLIES 2
Yoshiro_Fujimori
15 - Aurora

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.

viniciusnp31
5 - Atom

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

Labels