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.
@Londya5 ай бұрын
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 :)
@cottagekeeper8 ай бұрын
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.
@TheRemyRomano4 ай бұрын
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.
@NicolasBarakat-x4o2 ай бұрын
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?
@DanielVILLENEUVE-pk9sk3 ай бұрын
Hello, what if i need to upgrade the prices in my future invoices. How can I do it without affecting the past invoices ?
@danleeman3 ай бұрын
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.
@雄飞10 ай бұрын
After invoice make, How to save to PDF by auto ?
@lisadennis57945 ай бұрын
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.
@danleeman5 ай бұрын
Usually a Make.com integration
@kryptodad6 ай бұрын
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.
@danleeman6 ай бұрын
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