Airtable Typecast is not working

[mibrahim547]

Hello everyone…

I have a problem that although i enabled the TYPECAST in the airtable update node and also i enabled the permissions on the single selection colum on airtable… the system is not able to update records with new entry types for the single selection.

im using self hosted version 1.7

below is the screenshots

[EmeraldHerald]

Hi @mibrahim547

Could you provide your workflow and some sample data that you’re trying to send over that isn’t working with as expected with the Typecast option?

[mibrahim547]

[mibrahim547]

@EmeraldHerald

[EmeraldHerald]

Hi @mibrahim547 I was out yesterday, so only seeing this now.

I appreciate you sending over your workflow as that’s helpful, but could you also provide some sample data in JSON format for what isn’t working? Your workflow unfortunately requires outside credentials, so it wouldn’t be something I can run

[peterng1618]

I have the same issue. Seems like the Typecast option is doing nothing. The node still validates the input data against existing values that it has from reading the table schema when the table was first selected. My Airtable account has sufficient permission to add new single-select values, to be clear.

[EmeraldHerald]

Hi @peterng1618 I just tried on 1.9.0 following a similar approach to you and couldn’t reproduce this - can you let me know what version of n8n you’re on, and can you provide an example of how your Airtable data structure looks like? That way I can try to follow your exact steps for reproducing

[peterng1618]

Hi Grey,

I’m on 1.8.1 Docker. My Airtable data structure is really simple, just the default template when creating a new table as you can see below.

[peterng1618]

I just upgraded to 1.10.0 and still run into the same issue. FWIW, the issue persists on all 3 Airtable operations: Create, Update, Upsert

Additional update: Adding new values to the Multi-select field with Typecast is working as intended.

Thank you for looking into this!

[peterng1618]

Update 2: I found a workaround by copying the Airtable node to a text editor, changing the Single-select field’s type from option to string, and pasting it back to n8n. New values can be added successfully as expected.