Adding line items on an invoice

Topic Labels: Formulas
577 1
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

I am working on an invoice in the Page Designer extension and having trouble adding multiple line items. Company A has multiple line items in by Base. The unique identifier is the Company Name "Company A". In Quarter 1, 2023, Company A used 3 different hotels, and has 3 different revenues. I'd like to list on the invoice each of the hotels and their coordinating revenues.

Company A, Hotel A, Cost A

Company A, Hotel B, Cost B

Company A, Hotel C, Cost C

I'd like to add all of these to my invoice, but right now, only the 1st line is pulling into the invoice.

Help! And thank you!


1 Reply 1

You should be able to do this with three tables:
1. Companies
2. Invoices
3. Line Items

Screenshot 2023-07-29 at 3.33.43 PM.png

Screenshot 2023-07-29 at 3.33.40 PM.png

Screenshot 2023-07-29 at 3.33.38 PM.png

Screenshot 2023-07-29 at 3.33.56 PM.png

Link to base