Solved: Outputting "Yes" and "no" responses to PDF - Page 2

chrisdparent · 12-29-2023 02:00 PM

Hello,

So I have a number of fields set to Yes/No type and as a result, they write to the table as "TRUE" or "FALSE." In my PDF export automation, it outputs as a "Y" or "N." What I need is for it to display the actual words "Yes" or "No." I have tried changing the type to Enum and setting the values to "Yes" and "No" but it still seems to write to the table as TRUE or FALSE and does not display as I am hoping in the PDF. Any suggestions?

**Bonus points if you can tell me how I could get it to shade these Yes or No outputs in the PDF in different colors based on whether it is a Yes or No response. 🙂

Suvrutt_Gurjar

I think you had asked the query in the relevant tip as well. I am responding here in detail

Insert Colorful Status RYG Images in the Reports - Page 2 - Google Cloud Community

The data in the app record in the backend sheet looks like

As you can see[Recent-Customer], [Prime_Customer], [Online_Purchases] are Y/N type columns.

So the template can look like below to convert the "Y" "N" or 'TRUE", "FALSE" values to "Yes", "No"

Please note the [Prime_Customer_Status], [Recent_Customer_Status] and [Online_Purchases_Status] are three VCs that convert the status of Y/N columns [Prime_Customer], [Recent_Customer] and [Online_Purchases] into those status images as desired by you.

The result PDF will look like below

The expression for VC [Prime_Customer_Status] can be something like

CONCATENATE("https://placehold.jp/",SWITCH([Prime_Customer],"TRUE","228C22","FALSE","FFCC00","000000"),"/ffffff/150x150.png?text=",IFS([Prime_Customer], “Yes”, NOT([Prime_Customer]),”No”))

You can similarly construct VCs and expressions for [Recent_Customer_Status] and [Online_Purchases_Status] columns.

Finally, please note as mentioned in the tip also, the images use an external service. So please evaluate the impacts at your end such as any security requirement or continuous availability of service etc.

View solution in original post