Multiple items on a form used as invoice

HCL Domino Domino Forum
1

I’m building a issue-database that when the issue is closed a invoice will be sent to the issue owner (All issues are internal)

The invoice is a form populated with data when the issue gets closed and sent as mail. This is done in lotusscrupt.

I need help how to best solve that the invoice is able to populate several itemrows. Each row with colums for item-name, number of items, a-price and sum of that item.

I have thought of having a simple textfield with a linebreak for each item. But then the the sum of each item can not be computed automatically.

So I need a way to dynamically add more fields for every item added, haven’t figured out if this is possible or not?

(This invoice-form is after sent by email saved and modifications can be done by invoice-owner until a final export is done and the invoice-document is archived)

2

Subject: Multiple items on a form used as invoice

My personal choice is to opt for discrete docs whenever the data are repeated that way you can handle each ‘line item’ as a separate record. If you include enough information in each doc, you can do math, sort/group, report, whatever based on some shared characteristics.

You can also use response docs for this - I just tend to prefer documents to response docs.

There are lots of posts related to ‘dynamic tables’ so if you really want data inside of one doc, search on that term and you should find what you’re looking for.

Doug