Aren't dumb quotes kinda, well . . . dumb?

I’m a little surprised that, as far as I can tell, I’m the only person on this forum who is interested in smart quotes – the kind of directional, curved quotation marks that appear automatically in posts made in this forum but that are very difficult to use in AppSheet apps. They look like “this.” I’d like to try to make the case for an improvement in the platform and see if I get a response. If not, I’ll give up for now.

First, because I have a long-term interest in using AppSheet in language education and therefore want language to look right in the app, I’ve gone to the trouble to figure out how display proper “smart” quotes in AppSheet:

Unfortunately, however, my method is something of a pain in the rear end to implement and it has the additional disadvantage of forcing the creator to construct virtual columns when directional quotes are required. Today, I came up with a slight improvement in this approach but the basic problems remain.

Fixing this problem could be implemented by adding CHAR() to the AppSheet expression arsenal. I’m not sure how hard that would be for the engineers at AppSheet but it would make things quite straight-forward but creators who need to use special characters. CHAR() is, of course, how Google spreadsheets lets us use such characters (often inside of CONCATENATE()).

I’ve posted in the past about emoji and other special characters and those posts got moderately enthusiastic responses. That’s partly why I’m scratching my head about the lack of discussion about directional quotation marks and the need for a CHAR() expression. I’ll be interested to read any responses this post gets. :slight_smile: :bowing_man:

I m not fully and carefullly reading your whole post and thread.
But to get the double quotation string to appear, why dont you wrap that text by single quote?


’ “Hello” ’


should return “Hello” in appsheet.

1 Like

Really!? I’ll give it a try. I didn’t think it was this easy. I’ll be back.

yeah, easy peasy.
Try it out.

1 Like

By the way, 「本当です。」 :grinning_face_with_smiling_eyes:

1 Like

I hate smart quotes in all contexts.

1 Like

Haha, on this planet, there are always different opinions and preference, which we need to value.


Even though I don’t share your antipathy toward smart quotes, I think your comment is informative. My hypothesis is that this is a cultural thing. If this were a forum for literary types, I suspect there would be many more people who share my interest in the curly cues. Conversely, I suspect that people who have a lot of experience coding would probably prefer that the squiggles but done away with entirely. :wink: But, if we have CHAR() we can decorate are little apps as we see fit, without causing trouble for others. :slight_smile:

1 Like

I appreciate your help but my test indicates “not really”:

Screen Shot 2021-07-07 at 23.25.30

. . . produces . . .

Screen Shot 2021-07-07 at 23.26.24

But these are straight/dumb, not smart. My method produces this:

Screen Shot 2021-07-07 at 23.27.33

It’s a subtle difference in this font but the different is more pronounced in other fonts.

I left my reading glass behind, so it looks the same to me.
Not sure what you really want to achieve.

Probably I don’t understand what smart quite does mean in this context. Sorry for my poor help.

No problem. By the way, your approach is a lot easier that other approaches that were discussed here:

1 Like

Good, doctor.

I invite you to join our club through to learn more about AppSheet !



Joined!! (Just the free course :wink: I’m kinda cheap – I’m still using AppSheet on the free plan. :slight_smile: )


Good man!

1 Like