Controls

Re: Repeating table to automatically display multiple items?

Metron4 — Fri, 22 Feb 2013 23:37:19 GMT

Ah, cool! A calculated value worked perfectly. Thanks!

Re: Repeating table to automatically display multiple items?

Hilary Stoupa — Fri, 22 Feb 2013 23:28:20 GMT

What's the balance due column? Is it from the same data source as the rest of the data? Or a different data source? If it is a different data source, you could just use an expression box / calculated value.

Re: Repeating table to automatically display multiple items?

Metron4 — Fri, 22 Feb 2013 22:33:39 GMT

I found a post (buried on the 13th search results page) that gave me some good tips on how to do what I wanted. Now if I could only figure out how to include a Balance Due column I would be all set.

Repeating table to automatically display multiple items?

Metron4 — Fri, 22 Feb 2013 20:27:44 GMT

How do you use a repeating table to automatically display a set number of rows? Our projects have between one to six invoices. I have tied the formula of each text box to a value in my Invoicing table. The values are loaded when the form is opened. The table should display all the invoices associated with a ProjectID. But the repeating table will only show the data if there is only one invoice. If there are more than one, I get zero dollar values and only one row. It won't display four rows if there are four invoices. Please see attached image where I artificially expanded the table. Thanks.