Take Multi-Contact from one sheet to another in Bridge

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?

Find more posts tagged with

API and Developers

Bridge

Accepted answers

All comments

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"

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.