Emoji and special character in PDF workflow t...

[Fabian_Weller]

Emoji and special character in PDF workflow template

As I see, we cannot use Emoji and special character in PDF workflow template. I would like to use check boxes . But in the PDF it appears like this: 􀀀 Is there any workaround?

[Fabian_Weller]

@Philip_Garrett_Appsh

[Phil]

@Fabian

I suspect that the font with these special characters is not being included in the document sent to the PDF service.See article help.appsheet.com - Troubleshooting Custom Fonts

I am not sure how you can get around this. Troubleshooting Custom Fonts help.appsheet.com

[Fabian_Weller]

@Philip_Garrett_Appsh Thank you for pointing this out. I did’t find any font with symbols in the Google fonts I can choose.

Interestingly when I download the file as html, the emojis and special characters do show up in the right way.

And also when I download it as a PDF, the special characters do show up in the right way. The emojis do not.

Didn’t you say, that the way the PDF export looks like, also the PDF Attachment will look like?

[Phil]

@Fabian

We use the PDF Rocket web service to convert the HTML to PDF. We send an HTML file to PDF Rocket. It returns a PDF file.

Another customer was having trouble getting some special fonts to be displayed correctly when PDF Rocket converted their HTML to PDF. That was the origin of the article I cited above.

In that case, it hinged on whether the HTML file contained an appropriate “import url” that referred to the custom font. When the “import url” for the font was included in the HTM file, the PDF Rocket service retrieved the custom font and did the HTML to PDF conversion using that font.

I am not sure I understand your last question.

[Fabian_Weller]

@Philip_Garrett_Appsh Thank you for clarification. Do you know how I can add a emoji / symbol font to the HTML file?

[Phil]

@Fabian

Sorry but I do not.

You might try a Google search to see how to add fonts to a Google doc. Then follow the steps in the article I cited to see if the right font import is included in the HTML file. Then see if PDF Rocket does the conversion properly when the right font import is included in the HTML file.

[Fabian_Weller]

@Philip_Garrett_Appsh Okay thank you I will try it.

Another question: Can I add images in Workflow Template “directly”? I want to have an empty checkbox or a marked checkbox.

I tried this, but without success: <<IF([Question] = TRUE , “CheckboxTRUE.png” , “CheckboxFALSE.png”)>>

I know I could do this with a VC in the App, but I don’t want to do this, because i need the Checkbox image only in the template.

[Phil]

@Fabian

You can use URLs to publicly visible images.

[Fabian_Weller]

@Philip_Garrett_Appsh How can I do this? I tried <<IF([Question] = TRUE , “https://cdn0.iconfinder.com/data/icons/harmonicons-02/64/check-box-512.png” , “http://chittagongit.com//images/square-icon/square-icon-13.jpg”)>> But this will just return the text value of the URL.

[Fabian_Weller]

Hi @Phil
I just noticed that a Microsoft Word Template is able to handle special characters like ☑ and ☒ .
(Google Template is not)
In the PDF they look perfect.

[Fabian_Weller]

Hi @Phil
I can confirm, that special characters like ☑ and ☒ are now working also with Google Doc template.
Thank you
Though some do not show up proper.

Special characters in PDF Workflow Template Tips & Tricks 💡

I want to share some testing how special characters and emojis will look in PDF using Google Doc template. It seems to be better supported like 2 years before. Though some still do not show up proper. [image] Here you can copy the characters I used ☐ 🗆 ☒ ⌧ 🗵 🗷 🗴 🗶 ⛒ ✖️ 🗹 🗸 ✓ ☑️ ✔️