Bold formatting that shows on the AppSheet PDF document.

[DanMottaF]

Hello,

I'm developing a document automation application and I need help. I want to simulate a bold formatting that will also be applied to the PDF document later. However, as everyone knows, there's no formatting control in AppSheet. Nevertheless, I'm trying to achieve this using Unicode characters ("a", "𝗮", "b", "𝗯", "c", etc.). I managed to create a SUBSTITUTE formula to replace values in the [Ressalvas] column of my table. However, I would like a mechanism that replaces values with Unicode characters only where the text is enclosed between "**" characters (for example, *CONSIDERING* the law n. *8.666/2023*, so it becomes 𝗖𝗢𝗡𝗦𝗜𝗗𝗘𝗥𝗜𝗡𝗚 the law n. 𝟴.𝟲𝟲𝟲/𝟮𝟬𝟮𝟯). Do you have any ideas for a formula that could accomplish this? I'm sure this would help a lot of us.

SUBSTITUTE formula i'm using:

SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE([Ressalvas], "a", "𝗮"),
"b", "𝗯"
),
"c", "𝗰"
),
"d", "𝗱"
),
"e", "𝗲"
),
"f", "𝗳"
),
"g", "𝗴"
),
"h", "𝗵"
),
"i", "𝗶"
),
"j", "𝗷"
),
"k", "𝗸"
),
"l", "𝗹"
),
"m", "𝗺"
),
"n", "𝗻"
),
"o", "𝗼"
),
"p", "𝗽"
),
"q", "𝗾"
),
"r", "𝗿"
),
"s", "𝘀"
),
"t", "𝘁"
),
"u", "𝘂"
),
"v", "𝘃"
),
"w", "𝘄"
),
"x", "𝘅"
),
"y", "𝘆"
),
"z", "𝘇"
),
"A","𝗔"
),
"B","𝗕"
),
"C","𝗖"
),
"D","𝗗"
),
"E","𝗘"
),
"F","𝗙"
),
"G","𝗚"
),
"H","𝗛"
),
"I","𝗜"
),
"J","𝗝"
),
"K","𝗞"
),
"L","𝗟"
),
"M","𝗠"
),
"N","𝗡"
),
"O","𝗢"
),
"P","𝗣"
),
"Q","𝗤"
),
"R","𝗥"
),
"S","𝗦"
),
"T","𝗧"
),
"U","𝗨"
),
"V","𝗩"
),
"W","𝗪"
),
"X","𝗫"
),
"Y","𝗬"
),
"Z","𝗭"
),
"0","𝟬"
),
"1","𝟭"
),
"2","𝟮"
),
"3","𝟯"
),
"4","𝟰"
),
"5","𝟱"
),
"6","𝟲"
),
"7","𝟳"
),
"8","𝟴"
),
"9","𝟵"
)

Thanks,

Daniel

[1minManager]

The way I've done it before is as follows, where you want text sometimes in bold and red and sometimes normal

<<IF([Check]=TRUE,"black text","")>><<IF([Check]=FALSE,"bold and red","")>>

 So that for each condition you have a complete formula. 

But you can't mix and match formating between the << >>.  So this wouldn't work

<<IF([Check]=TRUE,"black text","bold and red",)>>

Hope this helps 🙂

Simon, 1minManager.com