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 data from elsewhere

PreviousA specific value cannot be present elsewhereNextPopulate another local field with total from elsewhere

Last updated 4 months ago

Was this helpful?

As one of our most commonly used rules, this is used to pull data from different blocs. This is a way of looking up data elsewhere based on certain values/criteria, 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 dont always have the same joining values.

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.)

Data Required Field

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

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.

Default Data if Field not found

If this is filled, when it does its search for data, if it fails to find it we can populate the local field with this value, e.g. "No Data Found". By default if nothing is found it overrides any data in the local field with a blank entry. By typing "IGNORE" it will keep the existing data in the local field.

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, we might want to find data about an individual in another bloc, but just searching their name may not be accurate enough, so we will send over both their name and date of birth, and both of these will then need to match in the other bloc so the person can be found.

Only extra parts of string (optional)

An advanced feature which allows for the extraction of specific parts of a string based on user-defined formats. For example, A scanned barcode like T6W24H3849293852 matches the predefined format T6W24&&&&&&&&&, extracting T6W24. Similarly, SH24A999B matches SH24&&&&, extracting SH24

Get first record instead of more recent record

By default the rule will return the most recent record, but when this option is checked it will return the very first record that matches.