Error in column values on WORD template

AppSheet AppSheet Q&A
1

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:

2X_b_bb9cd47c6233336a5262d1f1be39bdb6ca0902c5.jpeg
2X_b_bb9cd47c6233336a5262d1f1be39bdb6ca0902c5.jpeg737×227 24.3 KB

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

Thank you!

2

Admin_Techlift:

‘‏‏DŹWIGI W PROJEKCIE‏‏’

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

1 Like
3

@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
4

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
5

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

2X_3_3c6395a770ca249ae6ce71b65f704852f03f06b2.png
2X_3_3c6395a770ca249ae6ce71b65f704852f03f06b2.png1678×932 153 KB

2X_e_e66d9dd207eb71fcd92ced5ca7f788957b5c9f01.png
2X_e_e66d9dd207eb71fcd92ced5ca7f788957b5c9f01.png674×398 37 KB

Wild!

1 Like
6

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

2 Likes
7

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.

2 Likes
8

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.

1 Like
9

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

10

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
11

Admin_Techlift:

google docs vs. Word templates.

Word might be more tightly constrained.

12

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
13

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

1 Like