Get hubspot multiselect column data in the order they are added in specific row.

[nutan1]

We have used hubspot multiselect column to store data for multiple countries.Here i want to display data in the order they are added in perticular row.But currently getting data order by id.Mean if i added india first at the time of multiselect column creation  it willl get first no matter when we have added it in specific row(first or last or middle).Is it possible to do such a thing.

[IsaacTakushi · Accepted solution]

Hi, @nutan1.

In my tests, property values for multiple checkbox field types were stored and returned in the order they were added, so this should be possible.

For example, I created a property named multiple_checkbox_test_property with four options: Option 1, Option 2, Option 3, and Option 4. See the screenshot below:

I then gave a contact an Option 4 value first, then Option 3, then Option 2, and finallyOption 1. This screenshot shows how the values look on the contact record:

When I retrieve the contact using this endpoint, the property values are returned in the order I set them:

"multiple_checkbox_test_property": {
            "value": "Option 4;Option 3;Option 2;Option 1",
            "versions": [
                {
                    "value": "Option 4;Option 3;Option 2;Option 1",
                    "source-type": "CRM_UI",
                    "source-id": "",
                    "source-label": null,
                    "timestamp": 1557413789371,
                    "selected": false
                },
                {
                    "value": "Option 4;Option 3;Option 2",
                    "source-type": "CRM_UI",
                    "source-id": "",
                    "source-label": null,
                    "timestamp": 1557413786395,
                    "selected": false
                },
                {
                    "value": "Option 4;Option 3",
                    "source-type": "CRM_UI",
                    "source-id": "",
                    "source-label": null,
                    "timestamp": 1557413782134,
                    "selected": false
                },
                {
                    "value": "Option 4",
                    "source-type": "CRM_UI",
                    "source-id": "",
                    "source-label": null,
                    "timestamp": 1557413776978,
                    "selected": false
                }
            ]
        }
    }

If you are seeing different behavior, please share a link to an example contact in your account.