Search the Community
Showing results for tags 'replace'.
Hi! English is not my native language and I'm using FileMaker in a other language so some spelling/translation errors might occur. I have searched and tried to find a solution for this but couldn't find any. I have a text field, let's call it "Table::Colors", where users either write values manually or paste values. Most of the time the user paste in values. I want to make a script/calculation that changes the pasted value so it becomes correct. --- The user usually paste something like this: "1Green 2Dark blue 10Red3 15Yell0w Purple4" --- I have a script that runs when
I created a subset of my Members table. It holds PK_ID and Type I collect into $$PriorType the value of the PRIOR value of the selected 'Type'. I collect into $$NewType the value of the CURRENT valaue (collected on EXIT) of the 'Type' From a script, everything works as expected until I get to the Replace command: At best, I can change the first Type in the first record. Additional Types remain unchanged. I am not real clear on the optional settings on Find/Replace but I have tried all the different combinations and permutations with frustrating results.
I am trying to get around merging files. I have a database of Matters in filemaker pro advanced. I have created a script in the matters file which uses applescript to open a word template file, rename it according to the name of the record I ran the script from and save it with the new name. This part of the script works fine. It is implemented by using a global field with the filename in it and setting a variable in applescript by reference to the global field: "get cell" The new file is a letter - I want to be able to extract the name of the matter from the filemaker database