Insert other fields from another table into the DOC (PDF) file

[LeviP]

Hi guys,
I have the tables InvoiceHeader and InvoiceDetail
How can I insert other fields in the doc when I generate the pdf of the invoice

I want to insert the company fields so that they are dynamic, such as:
"Company" (RSocial, NComercial, CAI, RTN, Tel1, Email1)

I have all the company information in another table

[Marc_Dillon]

You can enter any appsheet expression, just has to be in between double angle brackets << >>.

[LeviP]

Thanks, I already tried it.

However, it only brings me the information that is in the table or that has references to these tables. For example, the "Company" table does not have references to the "InvoiceHeader" and "InvoiceDetail" tables, therefore it does not bring me the information

What should I do and how?

[Marc_Dillon]

What exactly did you try that didn't work?

How is the company table/record associated to the invoiceheader record that your bot is triggering on?

[LeviP]

The "company " table was not associated with the InvoiceHeader table, in that case I expected to call the fields in the doc, but I don't know how

Now I inserted a CompanyID field in the InvoiceHeader table to reference it to the company table, however it still does not show the only record that is in that table

And the bot that I use is only to create the invoice using the template that the company does not show

[Marc_Dillon · Accepted solution]

That's a correct dereference expression. So must be something wrong with your new companyID field, how did you create it?

There's only one company record in the table? If that's never going to change, you can just use <<companyTable[RazonSocial]>>