change original fields in the multi-fields Formula

arbel11

Hi All,

i am using the multi-field formula and get some issues i can't understand why and be happy for some help:)

i an using this command in the formula:

if findstring([commercial_name],' '+[_CurrentField_]+' ')>-1
then
[legal_name]=[commercial_name] else null() endif

when curentField is a word that i try to find in [commercial_name]-(original field) . the problem that in the output, nothing happen as i expected, but under a field that was true, i get '0'.

can someone please elaborate me what the reason for that?

thanks:)

OllieClarke

Hi @arbel11 what's happened here is that you've written a boolean statement. What your formula is saying is:

IF the current value of the ticked fields exists in [commercial_name] then does [legal_name]=[commercial_name]?

IF the current value isn't in [commerical_name] then NULL().

I'm guessing you want to update [legal_name] to [commercial_name] if another column exists in [commercial_name]? If so use a normal formula tool to update [legal_name]:
IF CONTAINS([commercial_name],[whatever field you've ticked]) THEN [Commercial_name] ELSE NULL() ENDIF

Does that help?