Form: conditional dropdown?

[AyS_0908]

Hi,

In the Form node, is it possible to have a dropdown list conditionned by the previous ones

• either with a js script,
• or via an integration with google sheet?

Example:
If in dropdown 1, Function selected is “Marketing”,
Then in dropdown 2, Sub-Function will be the ones related to “Marketing”.

Many thanks in advance

Information on your n8n setup

• n8n version: Last
• Database (default: SQLite): Postgre
• n8n EXECUTIONS_PROCESS setting (default: own, main): own
• **Running n8n via (Docker, npm, n8n cloud, desktop app):**docker
• Operating system: Windows last

[ria]

Hi @AyS_0908

Yes it’s possible with the Next Form Page node with JSON as input.

See the example below with some dummy data mimicking a google sheet output

Hope that helps!

[AyS_0908]

Thank you very much @ria.
If I understand well:

• the first Form node can only have 1 dropdown,
• it sends data to G-Sheet which selects the option list for dropdown 2 in Next Form
• etc ?
  Thanks again

[ria]

Hi @AyS_0908

Yes, the first form node would act more like an “intro page” as we need something to trigger it. Then after that trigger we can pull our data from external sources, e.g. Gsheets for our drop-down options.

There is no way to dynamically populate the drop-down in the trigger node at the moment.

[AyS_0908]

Thank you @ria