Take Multi-Contact from one sheet to another in Bridge

Ide AirTrunk

I have a form that users fill in to log risks, they can select multiple risk owners and assign them via a multi contact cell, I then use bridge to auto divert this risk to the respective register..

Unfortunately Bridge does not recognise multi contact to pull into the cell and I get an error.. has anyone been able to workaround this?

KlausNoah

Bridge can be picky with multi contact cells. Use the JS module to format and move the contacts properly. Then you can use Cozmicway's Japanese names to name your next sheets so you easily find them later.

prime_nathaniel

I have done this for a number of customers, the formatting changes when you have 1 contact vs multiple contacts. Just add a subroutine to your JS to detect the source count. The real trick is ensuring you saw the level parameter API documentation.

levelinteger

Specifies whether object data types, such as multi-contact data are returned in a backwards-compatible, text format in text/number columns.
- Set level=0 (default) to use text/number columns for multi-contact data and multi-picklist data.
- Set level=1 to use multiple-entry contact list columns for multi-contact data; multi-picklist data is returned in text/number columns.
- Set level=2 to use multiple-entry contact list columns for multi-contact data and use multiple-entry picklist columns for multi-picklist data.

Default 0

The individual contact syntax is

{

            "columnId": 7079310979714948,

            "objectValue": "m@primeconsulting.com"

},


The multi contact format you want is

{

            "columnId": 183174050303876,

            "objectValue": {

            "objectType": "MULTI_CONTACT",

            "values": [

                {

                    "objectType": "CONTACT",

                    "email": "m@primeconsulting.com",

                    "name": "m@primeconsulting.com"

                },

                {

                    "objectType": "CONTACT",

                    "email": "nathaniel@primeconsulting.com",

                    "name": "Nathaniel Kam"

                },

                {

                    "objectType": "CONTACT",

                    "email": "test@test.com",

                    "name": "test@test.com"

                }

            ]

        }