LOOKUP performance in PDF template?

AppSheet AppSheet Q&A
,
1

Hello,

I created a simple app with a safety control questionnaire and at the end the App generates a PDF from a google docs template. So far so good…

The special point for this app: it’s multilingual. As it is meant to be used by several countries in Europe, I added 8 languages and tried to work with a translation table to translate both, the App and the document. But now I get this as a PDF:

mika134_0-1712069164601.png
mika134_0-1712069164601.png795×1133 125 KB

Lots of “Loading data…” labels where my beautiful translated texts should be… :pensive_face:

Of course there are many LOOKUP and some IF formulas in the pdf, but couldn’t the automation just wait until everything is loaded until the PDF is generated? Does anybody see a solution for my issue?

Thanks a lot!

2

Add Ref columns pointing to your translation table, and use dereference expressions instead of LOOKUP().

2 Likes
3

Thanks a lot, this solution was too obvious to see for me :see_no_evil_monkey:

Solved my problem!

1 Like