Hi Nicholas,

I’ve run into the same issue myself.

Unfortunately, Page Designer doesn’t support conditional visibility, so there’s no way to automatically hide a field based on its value.

There are a few other extension blocks that can generate PDF documents with more flexibility, but most of them come with a monthly cost.

Regards,
Sam

Hmm, are these line items from a linked field?  Does the filtering by view function help?

• Original:

  

   

• Filtered:

  

If not, could you provide some screenshots of your tables and the page designer set up?

Hey ​@NicholasMaars,

If you have Invoices Table, and Invoice Line Items table, the solution suggested by Adam should work.

Just as a different workaround (which will fully depend on your table structure), you can apply conditions to a given lookup on your base (e.g. Value > 0). Now, as long as the field you are looking up is in itself a linked field, you should now be able to display the filtered records on Page Designer.

Feel free to schedule a call if you need further help! I’d be happy to help.

Also, only kind of related you might want to take a look at this fun post I wrote on parsing invoices using Airtable’s AI feature.

Mike, Consultant @ Automatic Nation

Using Page Designer, you could use a formula to create a list of invoice items by concatenating the different items, and excluding the items that have a value of 0.

I’ve had several experiences of creating invoices and sending them automatically to customers and since Page Designer is manually tirggered, we opt for one of the following:

• Use an external service to create a PDF using Zapier or Make.com (I have applied apitemplate.io and found it easy to use.)
• Build an App in Softr.io and let customers log-in and see their invoices as a web-page.

If you'd like to review how these options would look like and should be implemented, you can schedule a free meet here. Happy to help!

Matt Nixon