In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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
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
Top Solution Authors