Converting text to number & formatting

[Toby_Rush]

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.

Thanks!

[Ephraim_Bismuth]

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 !

[amber_h]

Ephraim_Bismuth:

I’m actually using a zap to do this c/paste task between a formula result and a linked record. I thought like you, that it would have the same results, but it doesn’t. And I can’t figure out why.

It does do the c/pasting, but instead of linking the formula result to an existing record that has the same name, it creates a new record (with the same name/string value, in the linked tab) and link to this new record.

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