I would like to build an app(s) where user would be
(a) selecting a record in a table (invoice related data) and on clicking a button
(b) should get invoice lines from another table
(c) create an invoice document as per a predefined template (some thing like below, but not a plain text based invoice)
(d) save the created invoice document as PDF into database (Airtable)
(d) send the invoice PDF by mail to the customer and update database
I think I not quite sure how to implement step (c), especially having a predefined template to be populated with invoice related data.
Please suggest if there are any links / tutorials for this or at least a high-level approach. I hope this can be done without using any paid plugins or components/integrations.