Job Runner
Bundle Records by Field Value
Overview
Bind records with the same value in a given field and convert them to new records.
Usage
Bind records by key fields and map them to a different record formatt.
Example:
As shown above, in the unconverted app, a team’s performance is represented by one record per quarter. The converted app summarizes the results for each team year and calculates the total annual points value.
First, get the records before conversion and set it to the Record parameter. For Key Fields, select team and year.
The important thing is conversion mapping, which allows aggregation of field values within the record bundled using aggregation functions as shown below. This example uses the sum function. To see what other aggregation functions are available, see the function list.
| Value | Set To Field |
|---|---|
| = Team | Team |
| = Year | Year |
| = sum(points earned) | Total points |
In this example, we first group records with the same combination of team and year at the source and map them to one record at the destination. In this example, we will have four Groups called “Osaka,2021”, “Osaka,2022”, “New York,2021”, and “New York,2022”, so we will convert to four records.
The result of the action is the transformed record. Note that this record has not yet been saved anywhere. It is also not automatically saved. To save the converted record, connect to “Add Records from Other Records” etc.
Parameter
Set the Record, Key Fields, Target app, and Mapping.
Record
Select the Action you used to retrieve the target records.
Because of its nature, this Do is meaningless if it does not contain multiple records. Note that after connecting records with When One Row is Ready, the records will become one row, and the conversion will have no effect.
Key Field
Select the key fields in the records. Multiple selections are possible.
This parameter accepts the following field types:
- Text
- Number
- Calculated
- Radio button
- Drop-down
- Link
- Date
- Time
- Date and time
- Lookup (string)
- Lookup (number)
This parameter does not accept fields that are inside tables.
Target app
Specify the destination app.
The app does not store records, but is needed to determine the list of fields to convert to.
Mapping
Enter the conversion mapping.
When referencing the source field value in this Mapping, the rule is as follows:
- The key fields become a single value for that key.
- Fields other than key fields are an array containing all field values from the bundled record.
- If the destination is a single value field, such as the Text filed, you must use an aggregation function or take a representative value, such as “=Field[0]”.
Occurrence of record Retrieval Criteria
| Criteria | Occurrence |
|---|---|
| When record Row Is Ready. | |
| When All record Rows Are Ready |
“When One record Row Is Ready” occurs once per record converted.
If there were no records, neither would occur.