Having problems with automations and dynamic conditions

[cris_orange]

So I'm running into an error that I can't seem to fix. Whenever I try to set a condition based on a linked record or a formula field, I get that an unknown error has occurred.

My first table, products, have a linked field to a record inside the main product master where the product's vendor is linked. So I've created a lookup field for the vendor record id and stored it inside my products table. The value for that record is "recSdTazTLqgiGtBb".

My second table, Vendor IDs, which contains all of my different Webflow IDs, is also linked to the vendor in the table. Here I get the exact same field value "recSdTazTLqgiGtBb".

Now I want to run automation that temporarily puts a webflow ID into my products record that I'm trying to edit. The trigger is an update to the action field, which works fine.

The next step is a conditional logic group that asks for the status of my product record, which also works just fine.

Next, I'm trying to find the correct record in my Vendor ID Table. So I try to set the condition "Where Vendor (Vendor ID table) is Vendor (Product table) (both linked records, not dynamic). I immediately get the correct result that I am looking for. But If I do the same with dynamic fields, I either get an empty result (use of ID) or the error message that an unknown error occurred (use of Name). 

The same happens if I directly ask to check for the stored record ids. I always receive an unknown error occurred, and it drives me mad.

I hope I could describe my problem and hope that someone here can help me.

[TheTimeSavingCo]

Hmm could you provide screenshots of the relevant tables please?  Sorry, I'm finding it hard to visualize!

[cris_orange]

Sure so this is the filter set with static fields as you see in the second screenshot it returns me exactly the value that I am looking for

But as soon as I try to match the conditions dynamically

First try with IDs

Or with Name values this one

[cris_orange]

So I made some progress. I can at least filter it to the correct vendor

But I still can't narrow it down to the 2nd entry. I only need the row with "Möbel Knappstein" so my automation can work correctly. For example when I try to check the Record ID (from Kunde) I always get disabled options with the tooltip "no valid nested options"

[cris_orange · Accepted solution]

Oh I just figured it out, holy hell...

So I needed to create a lookup field inside my webflow data table for the client record and now if i am checking it to that it works.

Well thanks @TheTimeSavingCo for being my rubber duck in that case

[TheTimeSavingCo]

Ha glad you got that sorted!

[rzoock]

Hey, I'm stuck on a similar issue. Did you figure it out?

[JBJ]

@cris_orange @rzoock 

I got stuck on a similar problem and found both the explanation and solution to it. I'm late in the game, but this might help you 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 [string = 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