Index and match custom formula

Get Help
1

Hello,
I am trying to create a custom formula takes in a string [myURLString] and searches for it in a database field [myDatabase].URL

If the URL is found then return the [Name] field of the database [myDataBase].Name
If not found then leave blank.

I am struggling to figure out how to do this. I’ve tried using the AI formula creator and looking through the formula reference guide, but I am not having any luck.

Any help is much appreciated.
Thank you.

2

It sounds like you could use auto-linking to connect entities from two different databases, and once that’s done, you can use formulas/lookups to get whatever fields you like.

3

@J_Broadway
When you say a formula that “takes in a string”,
do you mean search for the value of a text field?
If so, you should be able to write a formula like:

If( [myDatabase].Filter( [URL] = [field_to_match] ).Count() > 0,
    [myDatabase].Filter( [URL] = [field_to_match] ).Sort().First().Name,
    ""
)