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

Was this helpful?

  1. Bloc Editor
  2. Field Create, Edit, Parameters, Rules and Actions
  3. Field Rules and Actions

Populate another local field with total from elsewhere

PreviousPopulate another local field with data from elsewhereNextMax Allowed Duplicates

Last updated 5 months ago

Was this helpful?

Similar to our , this is used to pull data from different blocs. However in this case it counts quantities of data, either a sum total of numeric quantities, or just a simple count of the amount of times a piece of data was entered. The count can be set based on the criteria that needs to be met. Once we find the data we can set the local field which will get populated.

Hint: Don't forget, we can have a chain of rules on different fields, so once data gets populated to a local field as a result of this rule, we can have the exact same rule on that local field and it will automatically get triggered. It is a useful way to gather several bits of data from several blocs even if we don't always have the same joining values. You can also, for example, applyto the local field that is populated.

Rule Parameters

Parameter

Description

Bloc to Look Up

The Bloc that contains the data we are looking for. (Note, the "Type Module or Job Name" field is not a rule parameter and is simply used for finding blocs in your instance.)

Total Required Field

The field in that bloc which contains the data you want to count.

Local Field to populate

This is the field on your existing bloc where you are adding the rule, its the field you are going to populate with the response of this rule.

Add up total of numeric values or count number of entries

For Calculate Total of Numeric the rule will look for numeric entries and mathematically add them, for example, entries 4,2,8 and 3 will give a result of 21.

For Count Number of Values it will count the numer of times the value we are looking for was added. For example, if we are looking for a value called "Test", and "Test" is added 3 times based on our required search criteria, then the result will be 3

Choose Fields that must match in the other bloc

Here we send over matching pairs of local fields and fields from the other bloc.

For example, in a hotel, we might want to count the number of times a person marked a room with a specific Room Number as "Cleaned" in another bloc, then we would send over two fields:

The Room Number and a local field with the value "Cleaned". With this it will search for all entries where the room number is equal to the room number it is requesting, and where the cleaned value is set to "Cleaned"

Check difference between two time fields

An advanced feature that lets you calculate the number of records that falls between specified date ranges (using both Local and Remote date fields). It can give you a total count of records or a count of unique records that fall within the specified parameters.

Populate another local field data from elsewhere
maths fields