Cross-Bloc Data Manipulator
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 | |
Apply Bloc Initialisation Actions | |
Apply Field Actions (Parameters, Rules, Live Field Activity) | |
Apply Pre Submit Data Features (Cross Bloc Updates, Mail Alerts) |
Last updated