Jul 17, 2023 10:28 AM
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!
Solved! Go to Solution.
Jul 17, 2023 06:24 PM
Find records can only be compared between common variable types.
Only strings can be selected for string fields and numbers for numeric fields.
Jul 17, 2023 06:24 PM
Find records can only be compared between common variable types.
Only strings can be selected for string fields and numbers for numeric fields.
Jul 31, 2023 06:28 AM
Thanks, @Sho, such an obvious solution. I don't know that I would have figured that out.
Oct 20, 2023 09:20 AM - edited Oct 20, 2023 09:21 AM
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);