Introduction of LONGTEXT() expression

[Koichi_Tsuji]

It is similar request I previously posted as feature request to direct the data type to duration type, by introducing new expression, kind of DURATION() function. This time, I notice it is useful to have LONGTEXT() expression, while we have TEXT() expression in place.

Why? 

One of the typical AppSheet syntax add return to the list type values is : -

Substitute([Col], " , " , "

")

It is quite common that we pass such expression to app formula of Virtual column which is set to Longtext column.

However, if we pass the exactly same expression into Automation template, the "return" is ignored.  The returned value out of this expression is displayed as a single line.  We concluded that this is because appsheet template expression will return the value as "text" value, instead of "longtext" as we are not telling to AppSheet so. Hence, on the produced document, the strings are on the single line, which is out of our expectation to introduced return per item.

We have TEXT() expression, so it is making sense to me to have LONGTEXT() expression as well, to direct AppSheet expression parser that the value being passed as argument is actually Longtext instead of simple text.

For now, to achieve what we want, we need to craete unnecessary VC (Longtext type) for the table, and need to call that column in the automation template. Better to avoid to add VC for this occassion, as adding VC is simply slow down the app.

Thank you.

@Steve 

@Suvrutt_Gurjar 

@takuya_miyai 

@Aleksi