Re: How can I convert text from formula to linked items

2616 0
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

I have a Zapier firing when a certain label is added in Evernote. I am able to get the record added correctly into Airtable. Inside the text of my Evernote, I have encoded who the note is about. Example below:

<NAME: First Person, Second Person, Third Person>

I have a formula that can find “<NAME:” and I can pull the correct list of names, comma separated string. However, I also have a contacts table with peoples first name.

How can I get a column that has to be a formula (in order to pull the text) and get it linked to a Contact.

The ultimate goal is to be able to have a view of my contacts and see what Evernotes were tagged to their name.


11 Replies 11
5 - Automation Enthusiast
5 - Automation Enthusiast

My bad… it was indeed a question of " " (empty space). I thought about it before writing to you but didn’t find the empty space, so I thought the bug was not the because of that.
Thanks again for your time and clear explanations !

5 - Automation Enthusiast
5 - Automation Enthusiast

Where can I find instructions on this setup, please? Thank you for your help! :slightly_smiling_face: