Column mapping

Owned by
Magdalena Szpunar
Last updated: Jul 01, 2024
3 min read

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.jsonp

How to access the column mapping?

From a box context

Method 1:

  1. Click on the wrench icon at the top right.

  2. Select Column mapping from the list.

    image-20240207-095638.png

Method 2:

  1. Click the cog icon.

  2. Click the Column mapping button.

    image-20240207-095916.png

  3. Now, you can:

    1. Restore default settings

    2. Reset to defaults

    3. Make changes

  4. 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.

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.

Limitations

  • 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.