Using the ‘keypairs’ Field in Celigo Forms Sourced from NetSuite

Integrator.io
1

Is it possible to create a ‘keypairs’ field like the one in the Shopify Integration App that sources its values from a NetSuite saved search?

The image shows a section of a shipping method mapping interface featuring options for different shipping speeds and the ability to search or select methods. (Captioned by AI)
The image shows a section of a shipping method mapping interface featuring options for different shipping speeds and the ability to search or select methods. (Captioned by AI)4462×876 207 KB

2

Yes

1 Like
3

Or you can use optionsMap field type in an example like this if you need more than 2 columns:

A screenshot of a form builder interface from Celigo, showing JSON code for form definition on the left and form preview on the right. (Captioned by AI)
A screenshot of a form builder interface from Celigo, showing JSON code for form definition on the left and form preview on the right. (Captioned by AI)2560×1277 222 KB

{
  "fieldMap": {
    "salesforceAccountType_map_netsuiteCustomerStageAndStatus": {
      "optionsMap": [
        {
          "id": "netsuiteLocation",
          "name": "NetSuite Location",
          "type": "exportSelect",
          "resource": {
            "virtual": {
              "name": "Lookup",
              "_connectionId": "626168f90b6ef816b50c82d7",
              "asynchronous": true,
              "oneToMany": false,
              "netsuite": {
                "type": "restlet",
                "skipGrouping": true,
                "statsOnly": false,
                "restlet": {
                  "recordType": "location",
                  "searchId": "3369",
                  "useSS2Restlets": false
                },
                "distributed": {
                  "useSS2Framework": false
                }
              },
              "distributed": {
                "disabled": false
              },
              "adaptorType": "NetSuiteExport"
            }
          }
        },
        {
          "id": "netsuiteCustomerStage",
          "label": "NetSuite Customer Stage",
          "required": true,
          "type": "select",
          "options": [
            {
              "value": "lead",
              "label": "Lead"
            },
            {
              "value": "prospect",
              "label": "Prospect"
            },
            {
              "value": "customer",
              "label": "Customer"
            }
          ]
        },
        {
          "id": "netsuiteCustomerStatus",
          "label": "NetSuite Customer Status",
          "required": false,
          "type": "select",
          "options": [
            {
              "value": "6",
              "label": "Unqualified"
            },
            {
              "value": "7",
              "label": "Qualified Lead"
            },
            {
              "value": "8",
              "label": "In Discussion"
            },
            {
              "value": "9",
              "label": "Identified Decision Makers"
            },
            {
              "value": "10",
              "label": "Proposal"
            },
            {
              "value": "11",
              "label": "In Negotiation"
            },
            {
              "value": "12",
              "label": "Purchasing"
            },
            {
              "value": "13",
              "label": "Closed Won"
            },
            {
              "value": "14",
              "label": "Closed Lost"
            },
            {
              "value": "15",
              "label": "Renewal"
            },
            {
              "value": "16",
              "label": "Lost Customer"
            },
            {
              "value": "17",
              "label": "Qualified Prospect"
            }
          ]
        }
      ],
      "allowFailures": false,
      "hideLookupAllowFailures": true,
      "title": "Map Salesforce Account Type to NetSuite Customer Stage and Status",
      "tooltip": "",
      "name": "salesforceAccountType_map_netsuiteCustomerStageAndStatus",
      "type": "staticMap"
    }
  },
  "layout": {
    "fields": [
      "salesforceAccountType_map_netsuiteCustomerStageAndStatus"
    ]
  }
}
4

This is amazing, Tyler! Thank you so much. I got it to work.