Help with string formula

Support
1

Hello, I’m new here and I’m having trouble with adding a string formula.
I’d like to add a readonly checkbox field that checks if another text field contains a substring.

Something like:
=ISNUMBER(SEARCH(“my text”,A4))

I’ve tried a few options and searched the formula page but I cannot find an answer.

2

Hi,

We currently do not supported formulas for search function.

3

SOLVED: See Add dynamic icons/record flags and Emoji 😉

or go to https://www.ragicsolutions.com/newsforum/_news/add-dynamic-icons-record-flags-and-emoji

Hope this was what you needed

1 Like
5

Hi Amy,

Sorry if I got things wrong, but this was a related to the above post. Instead of using SEARCH(“my text”,A4) you can use FIND(‘my text’, A10)>0 to do what the user wanted with the checkbox.

I simply created a separate post in the Gallery section as my post dealt with more than just the dynamic code function.

Please let me know what you would prefer I did in the future when I want to help someone and then also mention additional things you can do? Either on this thread or you can email me at ragicsolutions@gmail.com

Thanks

1 Like
6

Sorry for the misunderstanding, I was mislead by the “emoji”. And yes, you are correct.

7

Thank you for the answer. it was very helpful and informative :slight_smile:

Though I agree that at first when I saw the “add dynamic icons /Emoji” title I thought it had nothing to do with my question.

8

Thanks and in future I will keep them separate. Sorry for the confusion.

Have a great day.