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. Fields, Tools and Charts
  3. Sub Blocs, Tools & Components

Cross-Bloc Data Manipulator

PreviousSub BlocNextBloc List

Last updated 4 months ago

Was this helpful?

The Cross-Bloc Data Manipulator Component is for manipulating data in either external blocs or the same bloc that the component is created in. It is a powerful tool that allows you to add records, delete records, update records with certain values or apply mathematical formulas to records.

This tool can be used for warehouse management, inventory and stock where the activity on one bloc may affect quantities or data on another. Other uses for this tool are activities such as mass updating data where certain values exist, or mass deleting (e.g. changing the status of multiple records).

Hint: Don't forget, like all Blocworx fields and components, you can add as many as you like. This means you could set up various criteria and link several of these to different Blocs, where all changes take effect once you submit the form. For example, in an inventory system, if you were moving stock, you could delete from one bloc and add to another.

Caution: This tool has the ability to make large sudden changes to other data sets.

Initial Parameters

Parameter

Description

Type Module Name (optional)

This can be used for accessing Blocs outside of the module you are currently in. You may leave blank if you want to access the the blocs in the current module.

Select Bloc

Use this to choose the bloc whose data you wish to affect.

Select Data Manipulation Option

The action you wish to carry out with, add a record, delete a record, update records with values and multiple mathematical update options.

Choose when the action happens

Used to decide when the update itself should occur. Some people may want this to automatically happen after the form submits, others may want to manually control when this action occurs

Choose Local Field to decide number of records to be added (only for "Add New Record" option)

Allows you to choose a field in the bloc that will determine how many records to add. If not used this defaults to 1. So only one record will be added every time the record is triggered.

Select Local and Remote Matching Fields for Updating (doesn't apply to "Delete record")

Allows you to set the fields that will be updated. Here you match each local field with the remote field (in the bloc you have chosen).

Select Local and Remote Matching Fields to Check Against (doesn't apply to "Add New Record")

Allows you to set the fields that will be looked up. Here you match each local field with the remote field (in the bloc you have chosen).

Add New Record if None Exists

A useful option when you are trying to update a record but the record does not exist. With this option turned on it will add the new record. Please note you have to select the local and remote matching fields for adding the new record.

Apply Bloc Initialisation Actions

Apply Field Actions (Parameters, Rules, Live Field Activity)

Apply Pre Submit Data Features (Cross Bloc Updates, Mail Alerts)