Skip to main content
Question

Auto Generate Attach and E-Mail Document Templates

  • Aug 29, 2025 10:57 PM UTC
  • 2 replies
  • 253 views

Forum|alt.badge.img+5

Good day everyone!

 

Through some searching I did find this YAML Document creation - Save PDF to field in record | Qrew Discussions to create and email and Document Templet. 

Looking through the YAML, I couldn't tell if this would work with a document templet that has to also pull from specific fields in the record we want. 

 

For instance when we finish a job, we have a button that Generates a service closing report that populates some information based off that job. The generate document button is with in the report and grabs the fields we need from there.

My end goal is to automate this for my guys on the road, where clicking generate document will also:
Attach the Document to the Record

Email the generated document to a subset of people associated with the job. 

2 replies

Maria
Forum|alt.badge.img+21
  • Community Admin
  • Sep 3, 2025 12:02 PM UTC

Qualifying my response by starting out saying, "I haven't used this YAML personally..." but If your question is, "will the document generated reflect the data from the record it's triggered from?" I believe the answer is yes. Fields are specified in the YAML, but you'll need to update it to match you table's field IDs. 


Top Step
Forum|alt.badge.img+12
  • Observing
  • Oct 20, 2026 4:08 PM UTC

You can do this without adapting that YAML. Both pieces are built in now.

For the email, use a custom email instead of a pipeline. Set it to send when a record is modified, with a condition like Status changes to Closed, or a Send Closing Report checkbox gets checked. Below the email editor there's an option to pick document templates. Choose your closing report and Quickbase generates it from that job record and attaches it when the email goes out.

Recipients can come from user fields on the job, so the people tied to that job get it. If some of them aren't Quickbase users you can type in addresses too, but a realm admin has to ask support to turn on open email for the realm first.

To keep a copy on the record, add a pipeline on the same trigger. Use the Quickbase channel's Generate Document step with your template ID and the record ID, then an Upload a File step that puts the file transfer handle from that step into a file attachment field on the job.

That way the button your guys press only has to set the status or the checkbox. The email and the attachment both happen on their own.

Generate Document in Pipelines needs a Business or Enterprise plan, and template changes can take up to 15 minutes to show up in generated files.