This formatted search is assigned to the contact fax number. It will only set it to the fax number from the BP General tab if it is currently blank. When it is not blank, it uses the contact fax field itself so that there is no real change.
SELECT ( CASE
WHEN $[$107.7.0] = '' then $[$47.0.0]
ELSE $[$107.7.0]
END )
as FaxNumber
Comments
0 comments
Please sign in to leave a comment.