How do you refresh drop-down lists for the Airtable node when new options added in Airtable?

Questions
1

Describe the problem/error/question

I’m enjoying the new interface for working with Airtable. Thank you! :grinning: :pray:

Is there a way to have the drop-downs refresh in n8n after one adds new choices in Airtable?

If there is a way, I’m not currently seeing it. Have tried waiting a bit to see if it might pick up automatically. Also tried duplicating my existing node.

What is the error message (if any)?

Not really an error – more a how to question.

Please share your workflow

image
image358×265 2.04 KB

image
image708×370 19.4 KB

(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)

Share the output returned by the last node

Information on your n8n setup

  • n8n version: 1.4.1
  • Running n8n via (Docker, npm, n8n cloud, desktop app): self-hosted
3

There should be a “Refresh List” option in the Ellipsis menu (…) next to the Fixed/Expression toggle. That should refresh the list :slight_smile:

4

Thank you @maxT. :pray:

I did try the “Reset Value” several times, but it hasn’t worked for me.

image
image373×190 2.8 KB

I overlooked “Refresh List” for base and table. Thanks for the tip. :pray: Have tried both of those now that I know, but not seeing my drop-down values update. Have also tried executing prior nodes to get data moving through to see if that might do something.

image
image356×137 2.6 KB

Here’s what I see in n8n for options (part 1):

image
image334×360 12.9 KB

Rest of the list (since there was a scroll):

image
image312×367 13.2 KB

Here is my list from Airtable with the missing TBD highlighted.

image
image395×570 16.9 KB

The TBD option was added to the list after I started working on my flow in n8n.

5

@colleen ah that is odd (and likely frustrating, sorry about that!) @Jon any ideas?

6

@colleen can you show me a full screenshot of the node so I can which operation you are using and what the input is?

7

Hi @Jon.

Here’s an overview.

It’s nice not having to use the set node with Airtable anymore.

image
image1416×533 19.7 KB

Here is the first part of the node.

image
image2014×1367 204 KB

Here is a snapshot of a lower part of the node with the drop-downs that I am trying to populate. (Options shown in prior screenshot)

image
image917×1317 40.2 KB

Is this helpful?

8

Hey @colleen,

That does look handy, So the newer version of the node uses a different component which we call RMC (resource mapper component) this is what creates values to send and makes it look nice.

The trick with this though is it loads all of the items at once so if you were to update something in Airtable we won’t know until you update the columnes, If you click on the dots next to “Values to Send” that should then have a refresh option which should reload the column data and get this working for you.

9

Hi @Jon.

I wasn’t able to get anything to refresh. In the end, I ended up doing the flow again. Because I started over, n8n picked up all the values.

From what I was seeing, drop-down options are not refreshing.

I do like the changes – it is easier to work with initially and should be even better when it comes to long term maintenance.

10

Hi, I have the same issue. I have try everything to. Any update ?

11

That is not working. In Airtable I change a column from Number to String. refresh option Was doing anything