Does a row description really need to get evaluated like an expression?

Hi! My app has gotten rather complicated so I’m in the process of adding descriptions to rows in certain tables to help me remember how they function in my app. I was a little surprised, however, to find that even a text description is evaluated like an expression and therefore can break my app.

The workaround is simple enough. All I need to do is put a quotation mark at the beginning and end of my text. This seems to work even if I have other words or expression in quotes inside the quotes – as long and the number of quotations mark is even (an odd number will cause an error).

Of course, I can live with this but I think it would be nice if app creators could simply type or copy and paste text into a “Description” column without having to worry about the possibility of an error. That leads me to the question in the header of this post: Does a row description really need to get evaluated like an expression? In other words, can’t AppSheet find a way to disable the checking (or automatically add the needed quotation marks) so that creators can focus on content when composing descriptions?

0 4 564
4 REPLIES 4

Bahbus
New Member

Well, the problem is that you’re using it in a way that is not intended at all.

Use the column Description (not the column Name) to provide long descriptive text. This is what is shown in the form as the “question” for the user. For example, “Is insulation damaged on any cables in the system? Including in electrical boxes and on roof?”. The corresponding column Name on the other hand would probably be something compact like “Insulation Damaged?”. If no Description is provided, AppSheet will use the column Name instead.

So, because of it’s main purpose, it has to be treated just like every other expression.

Wow! Thanks @Bahbus! I completely misunderstood the nature of the column “Description.” I thought it was similar to the descriptive comment we can add to actions:

2X_9_974a263a3fda7db1d4e34351fb0ec01de4bf513c.png

Thanks for setting me straight!

No worries. I did the same thing at first, and then checked the app, went to a form and said “ooooooooh… well that won’t work…”

It seems that I’m not alone in wishing for a simple spot to type in notes.

Top Labels in this Space