Dynamic options population of form node

[mredodos]

Exist a better way to do this? “options dynamic population from external data”

i have found a workaround for dynamic population of options like that

on top the data from odoo populate options in second page of the form with this expressions:

{{ 
  [
    {
      fieldLabel: "xxxx",
      fieldType: "dropdown",
      fieldOptions: {
        values: $json.data[0].xxxx.map(entry => ({
          option: entry.name
        }))
      },
      requiredField: true
    },
    {
      fieldLabel: "xxxx",
      fieldType: "dropdown",
      fieldOptions: {
        values: $json.data[1].xxxx.map(entry => ({
          option: entry.name
        }))
      },
      requiredField: true
    }
  ]
}}

Information on your n8n setup
**n8n version:1.68
**Database (default: SQLite):Postgress
n8n EXECUTIONS_PROCESS setting (default: own, main):
**Running n8n via (Docker, npm, n8n cloud, desktop app):Docker/Coolify
**Operating system:Linux

[n8n]

It looks like your topic is missing some important information. Could you provide the following if applicable.

• n8n version:
• Database (default: SQLite):
• n8n EXECUTIONS_PROCESS setting (default: own, main):
• Running n8n via (Docker, npm, n8n cloud, desktop app):
• Operating system:

[barn4k]

hello @mredodos

that one is better

[
   {
      "fieldLabel":"xxxx",
      "fieldType":"dropdown",
      "fieldOptions": {
        values: {{ JSON.stringify($json.data.map( entry => { return {option: entry.name} })) }}
      },
      "requiredField":true
   }
]

[mredodos]

Thx do you know if i can put the name as the label show in front end and id as real value??

[mredodos]

i think im missing something in your solution because return an invalid json

[barn4k]

Can you provide a sample of the data?

It’s unclear what should be there

[mredodos]

About my question on set a label and value of options:

I need the ID of fields, but i need to populate the name inside the select too…

So i have found a workaround i have made a options like this name-ID and after where i need the ID i have split and take last value {{ $(‘Form’).item.json.xxxx.split(“-”).last() }}

---

About your solutions, it seems to return always wrong JSON syntax at the end

my data output from the previus node before the secondo page form( the aggregator node) is like that:

[
  {
    "data": [
      {
        "Info": [
          {
            "id": 12,
            "name": "Name 1"
          },
          {
            "id": 17,
            "name": "Name 2"
          }
        ]
      },
      {
        "Struct": [
          {
            "id": 1883,
            "name": "name 1"
          },
          {
            "id": 1868,
            "name": "name 2"
          },
          {
            "id": 1831,
            "name": "name 3"
          }
        ]
      }
    ]
  }
]

[mredodos]

@barn4k sorry have you read my last message?

[barn4k]

You can do that directly in the form node, but the code will be quite complicated. Instead, it’s easier to build a json in the Code node

[mredodos]

So from default n8n not support a options label/value in a dropdown?

[barn4k]

No, key/values are not supported there