Help

Re: Find Records automation - Need help with strange error: "No valid nested options"

Solved
Jump to Solution
835 0
cancel
Showing results for 
Search instead for 
Did you mean: 
b_cummings
4 - Data Explorer
4 - Data Explorer

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!
Snag_2e1a6be.png

1 Solution

Accepted Solutions
Sho
11 - Venus
11 - Venus

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

See Solution in Thread

3 Replies 3
Sho
11 - Venus
11 - Venus

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

b_cummings
4 - Data Explorer
4 - Data Explorer

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

Support_IT
6 - Interface Innovator
6 - Interface Innovator

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);