Note, however, that just replacing value with event would (probably) break the XML as well, since value is (highly likely) the name of an XML attribute too. However, 99.9% of the field names you will actually be replacing will be quite unique and it is turns out to rarely be a problem.įor example, if your fields were named Previous value and Current value and you wanted to change them to Previous event and Current event that would be no problem at all. (or rather - oops - did we break it?) In Practice:įor the particular example you have given - using only one-letter field names A and B - the above will break the XML and not work - because the search and replace is across the entire XML, and the letters A and B appear in various places throughout the XML and replacing them will make the XML unreadable. Press the Button (or press CMD+OPT+V / ctrl+alt+V).or (on older versions of fmCheckMate) Hold ALT and press the button.or (on newer versions of fmCheckMate) Press the button.Type the name of the field you want to change to C.Click in the eplace field (or press TAB or CMD+SHIFT+F / ctrl+shift+F).Type the name of the field you want to change A.Click in the ind field (or press CMD+F / ctrl+F).Find and Replace text in the XML as needed.or set up fmCheckMate to always switch to the xml editor:.press the edit button (or CMD+3 / ctrl+3) to change to the XML-Edit view.and if you are not automatically changed to the XML editor view.
Choose the fmCheckMate tool (or press CMD+2 / ctrl+2).Convert the FileMaker objects to editable XML with fmCheckMate.Copy your buttons out of FileMaker ( CMD+C / ctrl+c).EDIT] Example 1: From your two Buttons with A and B, create two similar buttons with C and D In Theory:
:-)įirst up download and install fmWorkMate - This is actually the trickiest part of the process, since the latest version is yet to be published (and I will correct this once published) and then automatically generate ('multiply') the rest. I use fmWorkMate myself to do exactly what you are doing! In my case I'm syncing fields between tables of my FileMaker solution and embedded ESS tables, but the process is the same.
Is there a way to replicate those buttons and their logic to all the fields in my table without doing a lot of manual work ?įmWorkMate is a free Power Toolbox for FileMaker Developers from (that I have written over the last 10 years or so). Button A has a "single step" formula that says "set field value of B to A" and button B has a formula "set field value of A to B". That layout has two buttons with attached logic to show the buttons only if the field values are different. I have a layout that shows them side-by-side. Let's call them DataA::field and DataB::field. Or, in other words, I have two fields and two buttons. Is there a way to tell FileMaker "use this layout and script steps on the buttons for all fields, changing the names of the fields as you go" ? I could, of course, manually replicate all the formulas and buttons for all fields in all tables, but that would be insane. I have for a testing field built my logic and a layout so that FM shows me when the local and remote data source are different and shows me two buttons to let me choose which data to merge into the other set. That means I have a number of tables and each with a number of fields. I'm writing a data-sync/merge solution in FileMaker where I have two data sources and compare/merge them.