Instead of the "Spacer" field, use a blank "All Elements --> Text" element. That'll add the same spacing in the Interface without requiring an unnecessary field in the data layer.
Thanks for taking the time to make this tutorial, I was no aware that interface could do this. Disappointing there is no way within Airtable to save a PDF - if they did create a way to make a PDF our use case would be for contracts which are multiple pages.
Been trying to figure out how to do line breaks in formulas for forever. Thank you for this! I also appreciate the interface design workarounds - super helpful as I am big on aesthetics as well :)
You could use an automation to copy the data from the current price of the product to the unique line item itself. If you want to track not just historic invoices but also historic product prices, you could use a related table to products called historical pricing so you could have past data.
Hi Dan, when I build the interface and add the list view of my invoice lines, the new record button says "Add invoice" instead of "Add product" like on yours, what did I do wrong?
When you say "send it to Quickbooks or Xero," how do you do that? I am a Xero user and have Xero project, but don't know how to get the data from Airtable in there.
awesome airtable p*o*r*n :) one question though: how did you manage to create a formula that counts the invoice # up whenever a new record (invoice) is created? this is a major headache for me atm.
Instead of the "Spacer" field, use a blank "All Elements --> Text" element. That'll add the same spacing in the Interface without requiring an unnecessary field in the data layer.
Thanks for taking the time to make this tutorial, I was no aware that interface could do this. Disappointing there is no way within Airtable to save a PDF - if they did create a way to make a PDF our use case would be for contracts which are multiple pages.
Been trying to figure out how to do line breaks in formulas for forever. Thank you for this! I also appreciate the interface design workarounds - super helpful as I am big on aesthetics as well :)
Hello, what if i need to upgrade the prices in my future invoices. How can I do it without affecting the past invoices ?
You could use an automation to copy the data from the current price of the product to the unique line item itself.
If you want to track not just historic invoices but also historic product prices, you could use a related table to products called historical pricing so you could have past data.
Cool. I didn’t know about
somehow. I would just use a text element as the spacer. You can stretch it across as far as you want and leave it blank.
After invoice make, How to save to PDF by auto ?
Hi Dan, when I build the interface and add the list view of my invoice lines, the new record button says "Add invoice" instead of "Add product" like on yours, what did I do wrong?
When you say "send it to Quickbooks or Xero," how do you do that? I am a Xero user and have Xero project, but don't know how to get the data from Airtable in there.
Usually a Make.com integration
awesome airtable p*o*r*n :) one question though: how did you manage to create a formula that counts the invoice # up whenever a new record (invoice) is created? this is a major headache for me atm.
I set up an auto number field, and then in the primary field with a formula I concatenated AH- and added 1000 + the auto number field