Skip to main content

Common form fields

Comments

3 comments

  • Bas van Ditzhuijzen Strategic Partner NetSuite Integration Whiz Salesforce Integration Whiz
    Great Answer
    Answer Pro
    Engaged
    Celigo University Level 4: Legendary

    There is an extra inputType "staticMap" that allows you to do make a mapping table based on data that is sourced live from the source&target systems.

    There is an excellent example by Tyler in the following link:

    https://docs.celigo.com/hc/en-us/community/posts/11906392792347-Querying-NetSuite-Records-in-Custom-Form-Builder-Settings

    0
  • Bas van Ditzhuijzen Strategic Partner NetSuite Integration Whiz Salesforce Integration Whiz
    Great Answer
    Answer Pro
    Engaged
    Celigo University Level 4: Legendary

    There is an extra type "exportSelect" that allows you to do a virtual export, and choose one of the results for your custom setting:

    Make sure that your virtual export returns 'label' and 'value' as the value that will be shown and the value that is saved in the custom setting.

    "CeligoFileDefinitionId": {
          "helpText": "The Id",
          "id": "CeligoFileDefinitionId",
          "label": "Celigo File Definition Id",
          "name": "CeligoFileDefinitionId",
          "required": true,
          "resource": {
            "virtual": {
              "_connectionId": "yourconnectionId",
              "adaptorType": "HTTPExport",
              "asynchronous": true,
              "http": {
                "errorMediaType": "json",
                "formType": "rest",
                "method": "GET",
                "relativeURI": "/v1/filedefinitions",
                "successMediaType": "json"
              },
              "name": "read file definitions",
              "oneToMany": false,
              "transform": {
                "expression": {
                  "rules": [
                    [
                      {
                        "extract": "_id",
                        "generate": "value"
                      },
                      {
                        "extract": "name",
                        "generate": "label"
                      }
                    ]
                  ],
                  "version": "1"
                },
                "rules": [
                  [
                    {
                      "extract": "_id",
                      "generate": "value"
                    },
                    {
                      "extract": "name",
                      "generate": "label"
                    }
                  ]
                ],
                "type": "expression",
                "version": "1"
              }
            }
          },
          "type": "exportSelect"
        }

     

     

     

    0
  • Tyler Lamparter Senior Solutions Consultant
    Answer Pro
    Celigo University Level 4: Legendary

    Bas van Ditzhuijzen one additional one is having a refreshable multi select. If you take the exportSelect option, and just add another field for "multiselect": true, then you can have a live refreshable multiselect field. Kathyana Rule and I are actually working on updating this doc as we speak. Stay tuned!

    "CeligoFileDefinitionId": {
          "helpText": "The Id",
          "id": "CeligoFileDefinitionId",
          "label": "Celigo File Definition Id",
          "name": "CeligoFileDefinitionId",
          "required": true,
    "multiselect": true,
          "resource": {
            "virtual": {
              "_connectionId": "yourconnectionId",
              "adaptorType": "HTTPExport",
              "asynchronous": true,
              "http": {
                "errorMediaType": "json",
                "formType": "rest",
                "method": "GET",
                "relativeURI": "/v1/filedefinitions",
                "successMediaType": "json"
              },
              "name": "read file definitions",
              "oneToMany": false,
              "transform": {
                "expression": {
                  "rules": [
                    [
                      {
                        "extract": "_id",
                        "generate": "value"
                      },
                      {
                        "extract": "name",
                        "generate": "label"
                      }
                    ]
                  ],
                  "version": "1"
                },
                "rules": [
                  [
                    {
                      "extract": "_id",
                      "generate": "value"
                    },
                    {
                      "extract": "name",
                      "generate": "label"
                    }
                  ]
                ],
                "type": "expression",
                "version": "1"
              }
            }
          },
          "type": "exportSelect"
        }
    0

Please sign in to leave a comment.