Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Adding line items on an invoice

Topic Labels: Formulas
1321 1
cancel
Showing results for 
Search instead for 
Did you mean: 
TRBS
6 - Interface Innovator
6 - Interface Innovator

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