Error in column values on WORD template

Hello,

I’m trying to use my first WORD docx as a template for a specific workflow (previously using google docs).
Actually I’m getting this kind of an error: “Expression ‘‏‏DŹWIGI W PROJEKCIE‏‏’ is invalid due to: Expression refers to undefined field.”.

I have no expressions in the template, just column values. First I put values that way: <>, log was ok but it didn’t work and only these formulas appeared in the attachement.

Then - I corrected and added brackets, <<[column name]>> and have started getting erros in logs.

I came back to type <> but errors still continue.

That’s my docx:

Do you have any idea what I’m doing wrong?

Thank you!

Maybe it’s the special character " Ź "???

1 Like

@Admin_Techlift,

Also, if you are referring to column values in the workflow templates the syntax is <<[Column Name]>> instead of << Column Name >>

2 Likes

None of your “column values” are valid. The angle brackets, << and >>, are intended to enclose an AppSheet expression to be evaluated. The result of the evaluation of that expression is then substituted at that location in the template. You’ve placed column names directly within the angle brackets. Column names are not valid expressions, hence the error message you’re getting. Instead, enclose the each column name in square brackets to get the value of the column. For instance, instead of this:

<<DŹWIGI W PROJEKCIE>>

use this:

<<[DŹWIGI W PROJEKCIE]>>
2 Likes

I’ve got the following in a template of mine, doesn’t cause any errors:


Wild! :crazy_face:

1 Like

I want to say this behavior changed relatively recently, like within the last year.

2 Likes

I put the square brackets <<[DŹWIGI W PROJEKCIE]>> and the errors occur.
I put only the angle brackets <<DŹWIGI W PROJEKCIE>> and the errors occur.

The same error description is showed in the log.

No idea, all my previous templates work with only angle brackets, but they’re made in google docs. This time I’ve tried the WORD template and in both cases of brackets - it doesn’t work. :frowning:

2 Likes

All my previous templates work with only angle brackets, but they’re made in google docs. This time I’ve tried the WORD template and in both cases of brackets - it doesn’t work. :frowning:

1 Like

I don’t agree. In old templates made in google docs, the syntax <> works perfectly.

This could be the reason… But in such case I would need to change column names… Errors of the first steps in the Appsheet (and generally databases rules, I suppose)…

On the other hand - in my older templates I have also these “special characters”.

The other difference which comes to my mind is: google docs vs. Word templates.

1 Like

Word might be more tightly constrained.

For troubleshooting, you could try stripping the template down to the simplest possible thing:

<<[DŹWIGI W PROJEKCIE]>>

Literally make that the entirety of the template, in WORD. If that produces the error, contact support@appsheet.com and provide them with the template. It should be easy for them to troubleshoot the internals to find the problem.

1 Like

Please create a very simple test application that reproduces the problem and submit a bug report that refers to that application.

1 Like