For more detail about the
manyToOne
setting, see the reference page.email
, primary_earnings
, and optional additional_earnings
. Users upload spreadsheets with these columns, though the number of additional_earnings
columns may vary. We’ll map them all to a single additional_earnings
field and validate all earnings as USD currency.
Field Configuration
Adding the propertymanyToOne
with the value true
enables many to one mapping.

Data Review Screen
With multiple columns mapped to one field, all the columns will have the label with a number indicating their order. Note that validations defined in amanyToOne
field apply to all mapped columns.

Results
Upon successful import, the results and metadata include all the values from the mapped columns and metadata indicating how the columns were mapped to the target schema.Result Data
Each value from amanyToOne
column appear in an array that is the value for the manyToOne
field’s key.
Result Metadata
The result metadata indicates which columns from the source file were mapped to which columns.Hooks
Row Hook
manyToOne
fields can have their values changed and their info messages and validations set in row hooks.
Column Hooks
FormanyToOne
fields, a column hook callback registered for a manyToOne
field will be invoked once for every mapped column.
Step Hooks
Step hooksREVIEW_STEP
and REVIEW_STEP_POST_HOOKS
can be used to inspect column mapping at run time to see which columns were mapped to oneToMany
fields.
The full data object supplied as an argument to the step hook will resemble this: