Blocworx Documentation
  • Welcome to Blocworx
  • The structure of Blocworx
    • What is a project?
  • Getting Started
  • How To's
    • How To's
      • Get Started: Build a Simple Module
      • Build a simple invoicing system
  • Page
    • Page Overview
      • Page Sections
      • Modules in Pages
      • Sub Pages
      • URL Links
    • Edit a Page
    • Manage Pages
  • Module
    • Module Overview
      • Module Sections
      • Blocs in Modules
      • Automated Reports
    • Module Editor
      • Add, remove and move Sections and Blocs
      • Edit Module Location & Icon
      • Edit Module Details
      • Import from another Module
      • Delete a Module
      • Make this module available to child instances
    • Manage Modules
  • Bloc
    • Bloc Overview
    • Bloc Front End Overview
      • Data Display
      • Advanced Reports
    • Bloc Editor Overview
    • Pdf & Doc File Template Builder
    • The Blocworx Process Flow
    • Edit Templates
  • Bloc Editor
    • Bloc Form Builder Preview
    • Fields, Tools and Charts
      • Standard Input Fields
        • QR Code
        • Text
        • Large Text Field
        • Checkbox
        • Multi Button
        • Dropdown from List
        • Date/Time Selector
        • Bluetooth (Beta)
        • Button
      • File & Image Fields
        • File Field
        • Multi File Field
        • Image URL Field
      • Linked Data Selection Fields
        • Dropdown from Bloc
        • Autocomplete
        • Radio Buttons From Bloc
        • Checkboxes From Bloc
        • Link Data Field
      • Content Editing Components
        • HTML Field
        • Separator Field
        • Content Editor For User (WYSIWYG)
        • Content Editor (WYSIWYG)
      • User Based Components
        • Create User Pop Up
        • Logged in Users Information
        • User Select Field
        • Signature & Authentication
      • Dynamic Output & Variable Components
        • Time/Date Difference
        • Auto Generate Field
        • Plain Data Field
        • Maths Field
        • Field Merge Builder
        • Label Field
        • Barcode Generator
      • Third Party Integration Components
        • Blocworx Gateway
        • Bartender Integration
        • File Builder
        • Mindee API
      • Charts, Results & Data Feeds
        • Local Data Doughnut Chart
        • Advanced Chart Set 1
        • Results Box
      • Sub Blocs, Tools & Components
        • Submit Button
        • Sub Bloc
        • Cross-Bloc Data Manipulator
        • Bloc List
        • Mail Alert
        • Calendar & Resource Planning
    • Field Create, Edit, Parameters, Rules and Actions
      • Creating a Field
      • Editing a Field
      • Field Parameters
        • Choose hidden options for this field
        • Mobile Configurations
        • Rule and Actions Based Parameters
        • Main Field Parameters
        • Conditional Value
        • Set Character View Limit
        • Conditional Visibility
        • Dynamic Data Update (Update Value Based On Another Date Field)
        • Field Names in Different Languages
        • Manage Field Actions
        • Load Data from Another Bloc
      • Field Rules and Actions
        • Can not be empty
        • Must Be Equal To
        • Cannot Be Equal To
        • Must be Between Two Values
        • Must be at least X number of characters
        • Must be exactly X number of characters
        • Item must have been entered elsewhere
        • Item must not have been entered elsewhere
        • A specific value is required elsewhere
        • A specific value cannot be present elsewhere
        • Populate another local field with data from elsewhere
        • Populate another local field with total from elsewhere
        • Max Allowed Duplicates
        • Can only be numbers/integers
        • Keep Data for Next Entry
        • Must be Certain Format
        • Cannot be Equal Another Local Field
        • Must be equal to another local field
        • Populate another local field with part of this field
        • Populate local field with data from another local field
        • Must have matching equivalent data in another form
    • Bloc Settings
      • Main Bloc Settings
      • Functional Behaviour Settings
      • Bloc Layout and Visibility Settings
      • Data Display Settings
      • User Restricted Data Settings
      • Manage and Build Templates
      • Bloc, User and Role Access
      • List of available Field Slugs
      • Manage Bloc Scheduler
  • Manage Data
    • Manage Data Overview
    • Raw Data and Counting Reports
    • Look Up/Edit Data
    • Find and Replace Data
  • Administration
    • Admin & Development Overview
    • Manage Users
      • Profile Filter
    • Roles & Permissions
      • Roles
      • Permissions
    • Manage Mail Alerts
  • App Settings
    • Sign In With Google
    • Timeout Setting
  • No Code Development
    • Manage Blocworx Instances
      • Parent and Child Instances
    • Edit Theme
    • Manage Modules
    • Manage Pages
    • Extra and Beta Features
Powered by GitBook
On this page
  • Automated Reports
  • Exporting a Report while in the browser.
  • Raw Data vs Smart Report

Was this helpful?

  1. Manage Data

Raw Data and Counting Reports

PreviousManage Data OverviewNextLook Up/Edit Data

Last updated 3 years ago

Was this helpful?

Raw Data and Counting reports is where you can run specific raw data reports (i.e. full data raw data with no parameters set), or run Smart Reports which are reports that perform counts of values individually or even counts of values combined.

To access the Reports section of a specific module, find your module in the list and click "Advanced Reports"

You can now access the Automated Reports straight from the without having to go to Manage Data. You can also run an advanced report straight from a .

Once inside the Advanced Reports section you will see a list of all your blocs

Automated Reports

This is the first section you will see. The purpose of this is to be able to configure reports to run automatically. These reports subsequently get emailed to the recipients you have set.

The furthest left hand side represents the bloc, once you click the checkbox for a bloc you will then see the fields. Simply select the fields you want to appear in the bloc. You can add as many blocs with as many fields as you like. This will subsequently generated a multiple sheet excel file report.

Email Addresses

Here you enter the email addresses you would like the report to get sent to.

Please ensure email addreses are comma seperated. An invalid email address will be ignored. The email address will not be considered valid if there is only a space seperating it from another address.

Date/Time Frame

Here you can choose what data you want to send, e.g. the previous day's data, or the previous week's data or even all data.

Report Type

Frequency

You can choose the frequency of the report (basically how often it gets ran and sent).

Mail Subject

This is the text that will appear as the subject in the person's inbox. This is useful if they are receiving many reports and you would like to differenciate them.

Exporting a Report while in the browser.

Along with building automated reports, you can also run a report immediately while in the browser:

To export or view data from a specific bloc, simply select the fields you want to include in the report, select the "From Date" and the "To Date" and choose if you want to see the data on the screen or get the excel file by click "Get Raw Data Report"

Raw Data vs Smart Report

You will notice there are two different types of reports that can be ran. The most commonly used option is Raw Data. Raw data simply provides you a report of each record in Blocworx. One Row in the excel file per record. This is a standard data report and one that is easiest to understand. The Smart Report is designed to provide you with counts of data of single values, or counts of multiple groups of values. Let's look at an example. Below is a simple bloc with some data related to Businesses:

Here is a screenshot of the Raw Data Report where we have selected all 3 fields along with the system fields like username and timestamps:

Here is an example of a smart report where we have chosen the just the location field:

Here is an example of smart report where two fields are selected, location and Business Type:

You can choose you are going to run a

As mentioned at the top of this page, you can also run these reports straight from a .

bloc
raw data report or a smart report.
module itself
bloc
Note that the Counter provides the number of entries per value. In this case only one field was selected, the location field.
Note how the count is different to the one above, for example, there is only one record where Limerick and Food are both the values. There are 2 records where Dublin and Software are both values.