search

[robncarrie91]

Hi all, I am new to this and this is probably a stupid question but how do I change the search from contains letters to starts with the letter? Thank you.

[AleksiAlkio]

Would you please show an example what you are looking for,  thanks. 

[robncarrie91]

Here is an example. when I go to search it includes all birds that have the letters included in them. Is there a way to change it so that the results start with the letters?

[AleksiAlkio]

I'm afraid you are not able to change the behavior with the search functionality. You would need to create your own search functionality.

[MarceloStein01]

I'm assuming you are using the CONTAINS() function, so for example:
CONTAINS("avocado", "cado") = TRUE
However, you would like this to be FALSE, and only search containing the INITIALS "cado", right?

In this case, replace the function with:
CONTAINS(LEFT("avocado", LEN("cado")), "cado")

This will return FALSE because, breaking down the formula:
LEN("cado") = 4

So we can suggest that the formula would be this:
CONTAINS(LEFT("avocado", 4), "cado")

So again, let's break it down:
LEFT("avocado", 4) = "avoc"

We will then have:
CONTAINS("avoc", "cado") = FALSE

I recommend testing this logic, I did it just for the documentation, without testing it, but I think it works for you.