Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

ConfiForms Form Definition
formNameInvoice
registrationFormTitleInvoices rows

typeTypefalse[1=Consulting|2=Repair|3=Transport|]label;falseselecttrue

descriptionDescriptiontextarea

pricePricein eurnumbertrue

countCountpcsnumbertrue 


sashINLINE

 

 



So, we have a form with 4 fields

...

  • type - dropdown field
  • description - text are field to store invoice item details
  • price - numeric field to store numeric data for item price
  • count - numeric field to store number of items per that price

 

...



ALL stored data 

ConfiForms TableView
formNameInvoice

 type

description

price

count

 


To get Totals per type

We have 2 fields in TableView Merger, type and Total which is described as expression

...

ConfiForms TableView Merger

 type

Total:([entry.count]*[entry.price])

Invoice 

 


Record ID is used as a grouping key, together with a type and therefore rows are showed separately

...

ConfiForms TableView Merger

id 

type

Total:([entry.count]*[entry.price])

Invoice 

 


Same, as above, but description field used as a grouping key, together with a type and therefore rows are showed separately. 

...

ConfiForms TableView Merger

type

description

Total per row:([entry.count]*[entry.price])

Invoice  


Chart showing invoice items grouped by TYPE and with their totals (Chart macro uses the same table as you can see in 1st example, where we group by type field and calculate totals per row)

...