Document Builder to Fillable PDF - symbol fields

SueinSpain

Hi everyone

I have my fillable PDF which I created in Adobe Acrobat Pro

I have mapped my smartsheet using the document builder and it all works brilliantly (yippee).........

......but I have used symbols in the Smartsheet to represen the RAG status (Red, Amber (or Yellow in smartsheet terms), Green). Sadly these come across as the words and not as either the colour or the symbol.

Does anyone know how I can turn these back into colours in the fillable PDF? It would also be useful pass through other symbols as well - for example we use the pie symbol for % complete but that comes across as empty, full, quarter, half etc.

Mnay thanks all in anticipation

Sue

e.g. Smartsheet value

Document value in PDF

Andrée Starå

Hi @SueinSpain

I hope you're well and safe!

I'm not sure it's supported, so maybe you could transform them using the methods below.

You can use other symbols by using UNICHAR, CHAR, or Emojis.

More info:

https://help.smartsheet.com/function/unichar

https://help.smartsheet.com/function/char

https://getemoji.com/

Great resource that Paul Newcome put together

https://app.smartsheet.com/b/publish?EQBCT=82f8fe0936a54758a3afa4b584acde07

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

SueinSpain

Thanks for the reply and support Andree as always - I'll nvestigate all of these as I just didn't know where to start.

Stay safe & well

Sue

Andrée Starå

@SueinSpain

Excellent!

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

JB16

Hi,

Did you ever find a solution for this, because I'm trying to find the same and I'm not sure how the above can work as an alternative.

Thanks,

Jen

SueinSpain

Hi Jen,

I've been so busy I haven't tried the suggested solution yet. Not sure it is the answer but Andree is so good it could be.

The idea it to translate the word "Red" into a symbol or special character and that is what then appears on the pdf.

So still on my to do list I'm afraid

Kindest regards

Sue

SueinSpain

Hi All,

Finally got back to looking at this and it doesn't really solve my problem.

In my smartsheet I have a symbol field with values of Red, Yellow, Green etc.

This is used to indicate the level using it as a RAG status / visual aid.

However, the actual content of the field )behind the scenes so to speak) is the word "Yellow"

So when I pass this to a fillable / writeable PDF using the Generate Documents function

It actually passed through the word "Yellow" and not the round yellow dot or anything highlighted at all. see below the pdf document produced

IDEALLY I want to somehow either highlight the word or show a symbol that is coloured in the document in the same way it is in the smartsheet as the word just doesn't have the same impact.

Andrée Starå

@SueinSpain

Did you test the Emoji option?

Chad Guevremont

I've tried the Emojis and it just returned a blank. I've even tried using formatting to get it to work, and is looks like the formatting is either removed, or will work once then that formatting is used for every other instance of generate document.

I tried contacting support and after one call that didn't solve the issue I never heard from them again.

Gary_

I have tried the emoji, UNICHAR, and of course the symbols already available in Smartsheet. I cannot find any way to get anything but a normal letter or number character to display in the PDF. I know the symbols recently updated, so hoping for updates to this as well. Anyone find any other routes?