PDF and image from the image type column

Witan · 07-08-2024 04:32 AM

Hi, and first of all, thank you for your previous advice. It was really helpful.

Now, I have another issue (some things in AppSheet are completely incomprehensible and complicated for me).

I have a table for employers. In this table, I keep records of employers, including their logos. The column is of type Image, and it stores the relative path to the image, for example, Employers_Images/f915c5ab.Logo.100148.png.

Then, I have a table for medical checks. In this table, I record medical checks. Each check relates to different records. I want to generate a PDF record for each check. One record = one employer. I can do this successfully. However, I would like to display the employer's logo in the PDF record, where the information about the specific employer is shown. I have been going through the guides all day, but I still can't figure it out.

I tried to approach this using a virtual column: "CONCATENATE("https://www.appsheet.com/template/gettablefileurl?appName=", ENCODEURL(CONTEXT("AppName")), "&tableName=", ENCODEURL("Checks_Records"), "&fileName=", ENCODEURL([Logo]))" which I defined as a placeholder in the Google Docs template.

But it's not working. In the PDF, it still only shows the URL link as text...

Does this even have a solution?

Thank you very much for your time and help.

Witan

Logo has column type Image.
If I insert a direct link to a specific column in the placeholder, the following text appears in the PDF: "Checks_Records::Emp loyers_Images/f915c5ab.Logo. 100148.png"

Suvrutt_Gurjar

Does this format help?

Witan

@Suvrutt_Gurjar wrote:
Does this format help?
<img src="<<[Image_Column_Name]>>">

No. I use Google docs template. Cant use HTML tags.