can you help me on this: https://www.loom.com/share/557dd0bb52544f609b...

·

Clay Team
APP
·
Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉
Maxime M.
·
company table: https://app.clay.com/workspaces/10570/tables/t_lDpGsqmXaFyB/views/gv_pT06NqcCkstB
Maxime M.
·
contact table: https://app.clay.com/workspaces/10570/tables/t_LyxrhjTnJnHY/views/gv_jAaF4MbxAd0u
Clay Team
APP
·
Hey Maxime, thanks for reaching out! Taking a look!
Clay Team
APP
·
So you were actually doing it correctly but instead, you need to select "insert all items" and you can also ask it to search for that specific field called "persona" and it should do a better job. I made the change for you so you can check it out if it helps! Let me know if you run into any issues!
0ab21bc7-ba71-4b4d-98b4-e4dde32b6c01.png(43 kB)
Maxime M.
·
hey Arturo O. I kind of tried it but didn't succeed. And I just checked the changes you made but looks like it's not working: https://app.clay.com/workspaces/10570/tables/t_lDpGsqmXaFyB/views/gv_pT06NqcCkstB
Maxime M.
·
Do you mind fixing it to see what's the exact formula I should use?
Clay Team
APP
·
Ahh, sorry about that. Let me see what it's dealing with
Clay Team
APP
·
There we go, I missed that "persona" had a subfield called "value" so it was not detecting it properly so I just added that word to the prompt and now working. if any "value" from "persona" from this list /recordsFound contains "VP" then true, otherwise false