PDF File creation add link to column

Hi,

I am creating an app for leave requests, I have created a bot that creates a PDF document based on a leave request and save it to a subfolder of my google drive. I need to have the link of the file inserted into a column called linked PDF.

Everything is working but for the populating the column with the link to the created file. I do have any programming experience, but I have using Gemini to help me with this, I have been battling for two weeks without any luck.

Is there a way to do this using the bot or any other way?

Regards

How are you creating the PDF? Screenshots would be helpful.

1 Like

Hi Steve,

Thank you for getting back to me, I have now got it to work… Actually it was generating the PDF but as part of the bot action, I wanted the link to the generated file to be put into the link field, this was actually the part that wasn’t working. After much help from Gemini I eventually saw the problem, I hadn’t disabled the time stamp in the creation process and the was always a mismatch with the link.

Thanks

Regards

1 Like