Skip to main content

I'm setting up an automation to find records from webhook data. The field I need to match appears grayed out by Airtable with an error, "No valid nested options". Please see image.

I've never seen this error message before, and a google search was of little help.

Can you help explain what this error message means and how to resolve it?

Thanks!

Find records can only be compared between common variable types.
Only strings can be selected for string fields and numbers for numeric fields.


Thanks, @Sho, such an obvious solution. I don't know that I would have figured that out.


Hello @b_cummings - if you're able to run scripts with your plan, you can implement this workaround that convert a "non nested field" into a string that can then be used : 

Declare 'variable-name' as input of the script, then copy this

 

let myinput = input.config();
console.log(myinput);

// Assuming myinput is an array, access the first item (index 0) from the list
let myvariable = myinput['variable-name'][0];
console.log(myvariable);

// Convert myvariable to a string
myvariable = String(myvariable);
console.log(myvariable);

// Set the string value in the 'myvariable' output
output.set('myvariable', myvariable);

 


@b_cummings 

I have a solution to suggest that's easier to implement, in my opinion, than the one offered by @Support_ITI'm late in the game, but this might help you guys out for future automations.

If you’re getting the tooltip ‘No valid nested option’ when trying to select a field as a condition in an automation, that's because the data type of the selected field and the data type of the populated value do not match.

To understand why this happens, it’s useful to know that Airtable processes linked records and lookups as arrays, even when the cell contains only 1 element (in that case, Airtable treats it as a 1-item array). This means you’re trying to have gstring = array] as a condition, which Airtable considers as impossible.

The workaround to that is to create a formula field that references the linked record or lookup. This new field will display the original value, but will convert the array into a string. You can select this newly created field as a condition in your Find Records module.

 

 


 
Hope it helps.

JBJ
🌊 Keep the Flow

@JBJ  Yes I should have realized that easy fix! and hey, when you're at 270 fields why not add another!! Cheers 🍻


I did get an Invalid Filter error and after an hour of research and reading community posts, I emailed airtable support w a detailed description and their AI sent back the solution which was to use the  ARRAYJOIN( ) function the formula reference field FYI

 


@Mike_Shaw1 Glad it helped! Yes, that’s another way to solve this.


This error usually happens when Airtable can't find a matching field or value from your webhook data. It might be because the field type isn't supported, or the data format doesn’t match what Airtable expects.

To fix it, check if:

  1. The field you're matching is a supported type (like text or number).

  2. Your webhook data is correctly formatted.

  3. The field exists in the table and isn't empty.

If it's still not working, share more details, and I'll be happy to help!


Reply