Use parameter in DOC-ID google doc.template for PDF

[A_S_Pysarenko]

Hi everyone,

I want to use different templates for generating PDF files depending on a field value in the Employees table related to the current user.

I would like to store the template file ID in the Template File field and dynamically use this value in the bot instead of specifying a fixed file ID. Something like:
DocID=LOOKUP(UserEmail(), "employee", "useremail", "template file")

Is this even possible?

[WillowMobileSys · Accepted solution]

No, the Template field does not take expressions.  You would need to create a Bot for each template and then control the triggering of that Bot based on your field value in the Employees table.

Alternatively, if there is not much difference between the templates, you could create a single temple and use template IF-END statements to control what sections of the template are shown or hidden.

I hope this helps!

[A_S_Pysarenko]

that's what I assumed 😞
I use the mechanisms you suggested, but it turns out to be a pretty heavy file. I wanted to get around it with a simple solution.
Thanks for the answer