June 15, 201213 yr Laretta was kind enought to show me how to pull data from one field "pastestring" into different fields. My question is, I have to different fields and will only use one of the fields per record. My calculation for the name field is: Trim ( GetValue ( Substitute ( GetValue ( pasteString ; 1 ) ; ":" ; ¶ ) ; 2 ) ) I want to say something like: Pull the name from line 1: on pasteString OR Pull the name from line 1: on pasteStringTwo. I basically have 2 different contact forms, and I just need to figure out how to put an OR statement in there... Any help would be appreciated!
June 15, 201213 yr You need to have a test to determine which string you would like to pull from and then use a case function. case(yourtest,string1,string2) ie if test is true use string1 if not use string 2 that is if I understand you correctly
Create an account or sign in to comment