Child pages
  • TableViewMerger macro to help us to count registrations by user

Versions Compared

Key

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

...

  • We specify a ConfiForms Field macro with field name set to "name" to point at our "name" fields in the form. This is not an expression (does not have a wrapping () around it's name and doe s not have a reference to [entry.field_name], so it will be taken as grouping key!)
  • For the second column, to count, we define an expression like

    Code Block
    How many times:([count])

    It defines a label to be used (How many times) and the expression to calculate ([count]). You can use Supported math operators, formulas and functions and you can have references to filed values in expressions via [entry.field_name] notations

  • [count] and [total] are special context variables available in TableViewMerger. [count] shows the records count for a grouped by key, while [total] holds a total number of records in the dataset


So, for the data like this:

Image Added

you will get this calculated with TableViewMerger like this:


ConfiForms TableView Merger

name

How many times:([count])

f1