Question

Single Line Calculation Search

Forms Layout Designer Laserfiche Version 11 Forms

Updated January 13

asked on January 13

Hello,

Is there a way to search for a string in the value of a single line field and output True/False or 0/1 to another field. The following formula works in Excel, but will it does not look like ISNUMBER OR SEARCH are available formulas in Laserfiche. I know I can use js, but I am using the modern form designer.

=IF(ISNUMBER(SEARCH("test", My_Field)), "test", "")

Thank You,

0 0

Answer

SELECTED ANSWER

replied on January 13 • Show version history

The FIND function returns the number of digits before finding the first value in the second value. The function performs the search starting with the starting character. FIND(targetText, textToSearch, startingCharacter)

"=FIND("type", "prototype", 1)" returns "6"

In your example, it would look like:

==IF(GT(FIND("test", My_Field, 1),0),"test","")

This is searching for the position of the text in the field. If found, it will compare that number to 0. If the position value is greater than 0, return "test". If not, return "".

1 0

Replies

replied on January 13

Thanks so much Kevin! This worked perfectly.

0 0

You are not allowed to follow up in this post.

Question

Question

Single Line Calculation Search

Answer

Replies

Sign in to reply to this post.