🔩 Data Mapping > Action

Introduction

The actions available for the mapping feature slightly differ from the ones available for the formula feature (see below)

For more a more detailed documentation regarding the action available, please refer to the dedicated section inside the formula documentation.

Important

As mentioned above, the actions available and their behavior are the same as the ones available for the formula feature. HOWEVER, some differences remain between the two features. We intend to unify the behavior of the action in the future. The following list is an exhaustive list of the differences between the two features:

• The SET_SELECTABLE_OPTIONS action is not available in the mapping feature.
• The REMOVE_VALUE action is not available in the mapping feature.
• There can only be one action per mapping rule.
• When a rule is triggered for a given entity, the process stops. This means that if the first rule is triggered, the second one will not be executed. This behavior is different from the formula feature, where all the rules are executed.
• Every time the property source is mentioned in the action formula documentation, in the context of the mapping feature, it designates the table from which the data is extracted.
  • Example: if we intend to map data from the table my_table to the table the_table_shared_by_my_partner, the template {{source("key")}} will return the value of the field key from the table my_table
  • In the context of the formula feature, the source property designates the current table, which is the_table_shared_by_my_partner in the example above. This difference is due to the fact that the mapping feature is used to map data from one table to another, while the formula feature is used to map data from one table to itself. We understand that this difference is confusing and we intend to unify the behavior of the action in the future.
• Every time the property source is mentioned in the action formula documentation, a target property is also available. In the context of the mapping feature, the target property designates the table to which the data is mapped.
  • Example: if we intend to map data from the table my_table to the table the_table_shared_by_my_partner, the template {{target("key")}} will return the value of the field key from the table the_table_shared_by_my_partner
  • In the context of the formula feature, the target property does not exist.