May 15, 200718 yr Newbies I am new to filemaker. I need to write a script that will allow me to: find a keyword in one field in all records and then in all of those FOUND records ONLY, I need to enter, that is, ADD (without deleting other info within that cell) a specific text word in a DIFFERENT field . Please help!
May 15, 200718 yr Something like this might work: Enter Find Mode [] Set Field [ onefield ; "keyword" ] Error Capture [on ] Perform Find [] Error Capture [off ] If [ Get( FoundCount ) > 0 ] Go to Record/Request [ first ] Loop Set Field [ differentfield ; "word" & " " & differentfield ] Commit Record/Request [] Got to Record/Request [ next, exit after last ] End Loop End If
Create an account or sign in to comment