I have a database that stores training certificates for employees,
1) i have a field that is titled: attachment_front this field holds the front side of the certificate in pdf format.
2) once the certificate is entered into the field i then hover at the bottom of the container field and the pop-up type interactive menu appears.
3) I then click on the 'Open PDF in Preview option'
4) the PDF then opens and is titled with a random name e.g. 'FM-222C7C6F-E3B5-408A-BCE5-95BBA3593821.pdf'
My question is can i get this pdf to open and have the name of the certificate which is held in a field titled: document_title, this would save the user having to change the name of the pdf when they want to save it.
Many thanks in advance for any input.