Introduction
Column mapping allows both platforms to work smoothly and map the fields of your selected monday boards into BigPicture.
Column mapping lets BigPicture know where data can be found in monday board columns, regardless of the column name. You can work with all items and subitems in a single BigPicture box, even if your monday boards don't have an identical column setup.
For boxes based on a single monday board, column mapping can be easily changed:
From the level of an individual box
For boxes based on multiple monday boards, the column mapping is configured on the App configuration > General > Fields page. Read more about the column mapping on the Fields page.
See the video:
https://fast.wistia.com/embed/medias/p3isg5i2x1.jsonpHow to access the column mapping?
From a box context
Method 1:
Click on the wrench icon at the top right.
Select Column mapping from the list.
Method 2:
Click the cog icon.
Click the Column mapping button.
Now, you can:
Restore default settings
Reset to defaults
Make changes
When ready, click Save.
Column mapping (App configuration)
If a box is based on more than one monday board, go to the App Configuration > General > Fields page (admin permissions required).
General mapping affects all items unless you add custom mapping for specific boards.
Built-in fields are capable of taking information from various monday boards and external platforms (for example, Trello).
Column mapping rules are defined for each monday board separately.
Column mapping reminders
When you add or remove boards to a Scope, the app prompts you to check the column mapping:
https://app.arcade.software/share/RLoQB2k3bSCgWhbupTrk
Available fields
BigPicture fields
Start date - can be mapped to a timeline or date column. When date column is chosen, end date field has to be mapped to another date column.
End date - can be mapped to a timeline or date column. When date column is chosen, end date field has to be mapped to another date column.
Story Points
Actual cost
Estimated cost
Status - can be mapped to a status column.
Assignee - can be mapped to a people column.
Original estimate
Time spent
Unconfigurable fields
The icon, item ID, item name fields are mapped out of the box.
Actions
Current setup info
In the pop-up, you can see the current column mapping of a project.
You are also informed who changed the column mapping recently. No person is displayed if you are the user who made recent changes or if there was no column mapping update before.
At the top, you can see info regarding the current setup. The message lets you know if a custom configuration (custom mapping) exists for a project.
If a project uses the default configuration settings, it means a custom configuration doesn't exist for a project yet. The project is using the default mapping.
Make changes
When you modify the mapping and save changes:
The custom configuration is created, OR
The existing custom configuration is updated.
Restore default settings
You can always remove the custom configuration and return to the default configuration.
Reset to defaults
If you click Reset to defaults, all custom settings will be overwritten with default settings.
The action CANNOT be undone.
Limitations
Changes made to columns, such as adding new ones or adjusting status colors for monday subitems are visible in BigPicture with a delay of up to one hour.
Box editors and box viewers have read-only access to the column mapping of a box. The column mapping option is greyed out for them.