Expression was unable to be parsed: Unterminated string

[FaCe]

How to solve the issue caused by "ATTIVITA'" there ?

LINKTOFORM("TUTTE_Form",
"ID", [_THISROW].[ID], "FOGLIO", "RED",
"ATTIVITA'", "(RED" &[_THISROW].[PRATIC] & "-" & [_THISROW].[GN] & ") " & [_THISROW].[SOFFER],"App-12345")

that cause this error: Expression was unable to be parsed: Unterminated string

[FaCe]

How i can handle the apostrophe after ATTIVITA' ?

ATTIVITA' with apostrophe is my column's name 

[CANA-IT]

I am not sure if this will work... In Appscript you can \ before the special character to null it.
Example: "ATTIVITA\'"
As I said, I do not know if that will work in Appsheet..

[FaCe]

No unfortunately it not works in AppSheet i've tried and also now with no success ...

Expression was unable to be parsed: Unterminated string.

[Gustavo_Eduardo]

Create a virtual column with the name of your table and in the concatenation, instead of putting the table name, put the name of the virtual column in brackets. That's the only thing I can think of...

[CANA-IT]

Try this instead:
You could try breaking up the string using concatenation.

This might help AppSheet parse the expression correctly.

Example: "ATTIVITA" & "'". So the full line would be:

LINKTOFORM("TUTTE_Form","ID", [_THISROW].[ID], "FOGLIO", "RED","ATTIVITA" & "'", "(RED" &[_THISROW].[PRATIC] & "-" & [_THISROW].[GN] & ") " & [_THISROW].[SOFFER],"App-12345")

Good Luck

[FaCe]

Tried it, not works unfortunately.

Expression was unable to be parsed: Unterminated string.

It's really odd i see that i could solve changing directly my column's name removing the ' or try the other solutions suggested (VC), but i think there's a way to escape ' ... isn't it ?

[Gustavo_Eduardo]

Take a look at the Naming Protocol  I created, maybe it will help you to organize your nomenclature. In any case, I suggest that the column and table names do not contain special characters and that, if you want special characters, you use them in the "Display Names"

[Gustavo_Eduardo]

Was it just me or are there two quotation marks after ATTIVIATA?

[FaCe]

"ATTIVITA'" with apostrophe ' at the end of the word yes i know it could be better not to use speciale chars, i hope i can solve this leaving the word intact as we have in italian language but probably there's no way to solve it ....

Btw for what i know i should escape the special character. With a single quote this is typically accomplished by doubling your quote: two single quote character.

So it should be "ATTIVITA'''" but it still not works ...

[TeeSee1]

The following seems to work (..though it does not make much sense to me...)

• Create a virtual column with an App Formula = "ATTIVITA'""'"
• Use this column in your LINKTFORM expression like LINKTOFORM("***_Form", [this VC], <value expression>)

Note. I tried this using USERSETTINGS but did not work. 

[FaCe · Accepted solution]

Thank you so much to all of you for your help.

I've solved changing the name from ATTIVITA' into ATTIVITA

I've to make some change in my App but now all works properly