LOOKUP performance in PDF template?

[mika134]

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:

Lots of "Loading data..." labels where my beautiful translated texts should be... 😔

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!

[Joseph_Seddik · Accepted solution]

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

[mika134]

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

Solved my problem!