Oct 18, 2023 11:08 AM - edited Oct 18, 2023 11:08 AM
Im trying to filter the next api request:
https://api.airtable.com/v0/appn8Dg5iLM042oZh/tblDamHA046rqdTJF?fields%5B%5D=client_address_(from_deal_id)&fields%5B%5D=client_name_(from_deal_id)&filterByFormula=assignee%3D+9650
but instead of the assignee being 9650 i need to filter it by names like "Nick Smith", how could i do it?
The error i get when i try to put a string instead of a number like:
https://api.airtable.com/v0/appn8Dg5iLM042oZh/tblDamHA046rqdTJF?fields%5B%5D=client_address_(from_deal_id)&fields%5B%5D=client_name_(from_deal_id)&filterByFormula=assignee%3D+samantha
is:
Solved! Go to Solution.
Oct 20, 2023 09:21 AM - edited Oct 20, 2023 09:22 AM
Solution:
https://api.airtable.com/v0/appn8Dg5iLM042oZh/tblDamHA046rqdTJF?fields%5B%5D=client_address_(from_deal_id)&fields%5B%5D=client_name_(from_deal_id)&filterByFormula=SEARCH ("Samantha", ARRAYJOIN(assignee))
assignee is a lookup field thats why it is a ARRAYJOIN, and it also works with full names with spaces like "Nick Smith"
Oct 20, 2023 09:21 AM - edited Oct 20, 2023 09:22 AM
Solution:
https://api.airtable.com/v0/appn8Dg5iLM042oZh/tblDamHA046rqdTJF?fields%5B%5D=client_address_(from_deal_id)&fields%5B%5D=client_name_(from_deal_id)&filterByFormula=SEARCH ("Samantha", ARRAYJOIN(assignee))
assignee is a lookup field thats why it is a ARRAYJOIN, and it also works with full names with spaces like "Nick Smith"