- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 26, 2018 06:04 AM
I’ve made an invoice system in airtable. I now need to export to send to a client.
However I need my invoice to follow a certain naming convention to be able to use for later.
I’ve made a function field to takes care of that.
I can PDF from the print prompt and name my document, but I need to copy/paste the name from my function field every time.
Is there a way to automatically name my PDF based on my function field?
![Moe Moe](https://community.airtable.com/legacyfs/online/avatars/2X/6/66f48bbca3f78d7ee84438721844676f5c3f71fd.png)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 31, 2020 03:29 AM
Docupilot allows you to set the file name based on a field name. We’ve built an integration for Docupilot with Airtable.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 05, 2020 01:14 AM
I saw that thank you. It’s just the Docupilot price is a little too steep for me to justify atm.
![Justin_Barrett Justin_Barrett](https://community.airtable.com/legacyfs/online/avatars/3X/3/2/322b62e252e04faf5485b361bfe1e5a346583374.png)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 05, 2020 11:18 AM
Are you still seeking a solution for this, or have you found something since you first posted (two years ago)? :slightly_smiling_face:
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 06, 2020 01:31 AM
Still looking - but guess everyone just have to deal with going to the print prompt, keeping an eye on orientation (as default in the print prompt is portrait) and naming the document accordingly.
I don’t know if anyone else has a workaround except using Docupilot?
![Justin_Barrett Justin_Barrett](https://community.airtable.com/legacyfs/online/avatars/3X/3/2/322b62e252e04faf5485b361bfe1e5a346583374.png)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 06, 2020 10:31 AM
I build an HTML version of my invoices in Airtable, including a specific filename. I then use a button field to trigger a script that calls an Integromat scenario webhook. The Integromat scenario sends the HTML to CloudConvert to convert it to PDF, then saves that PDF back to the Airtable. I click another button field that triggers a different Integromat scenario to email the PDF to my client. I don’t send many invoices, so I’m able to use the free CloudConvert account for now. I’ve toyed with the idea of trying to use Google document templates instead of CloudConvert, but haven’t had the time to experiment yet.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 09, 2020 11:53 PM
Thank you Justin - I didn’t think about cloudConvert I’ll try it out…
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 03, 2020 08:34 AM
Hi Justin
I’ve been trying figure out how you build an HTML version of your invoice in Airtable?
Did you make it with the custom block?
![Justin_Barrett Justin_Barrett](https://community.airtable.com/legacyfs/online/avatars/3X/3/2/322b62e252e04faf5485b361bfe1e5a346583374.png)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 03, 2020 09:52 AM
No, I did it directly in the various tables that are part of the invoicing process. In my case, the following tables are involved:
- Line Items
- Rates
- Clients
- Invoices
Line items link to rates, and I build just the line item HTML in a formula field. In my case, each line item is a row in a table, so the formula starts with:
"<tr><td>" & Name & "</td><td>$" & Rate & {Type Abbr.} & ...
On the [Clients]
table, I have a formula field that builds the HTML version of the client’s address.
On the [Invoices]
table, I link to the line items for a given invoice, as well as the client, and roll up the respective HTML data from each of those tables, which is then inserted into a larger formula that builds the rest of the invoice HTML.
![Robert_Thorburn Robert_Thorburn](https://community.airtable.com/legacyfs/online/avatars/3X/0/7/07e7b6e82c4de083e14d91b07f8a8d0a68414d95.png)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 23, 2022 07:45 AM
Hello, Justin, I just wanted to say how helpful and thought- and ideas-provoking i found your posts on this thread and your related one at Create pdf and store it as attachment . Looking at your recent (April 26th) post on using CloudConvert API with AirTable script, I must go look at that, as hopefully will help me regarding the limit of 2 “On” scenarios with free Make.com, which I’ve been using for webhooks on AirTable button fields to do the HTML to PDF conversions. The CloudConvert daily free allowance of 25 file conversions is quite generous for light use applications. I’ve developed a HTML Templates table for generating mergeable pdfs from a Contacts/Customer management base. I love your concept for building HTML invoices too, via your Invoicing linked tables structure.
![](/skins/images/FE00829FDD2AE889FAB731D8F02A8942/responsive_peak/images/icon_anonymous_message.png)