Mass change of field source in layouts

Questions
23

@Cecile, et all.

Here is a seriously stripped down version of the file we use. Some of the other tools and utilities we have center around work with APIs, and have keys and other things in them, so I had to strip all them out. We simply add tools as we need to if it's something we regularly need to convert or transform.

DISCLAIMER: The file has warts, is provided as is, carries no support options...and as always, use at your own risk. I carry no responsibility for any damage you cause with the file.

General flow:

  1. Copy the FileMaker thing, or plain text.
  2. On the Home screen, just click Clipboard Utility. This goes to the layout and creates a new record if it needs to. ( may fail if there are no records, but that is only ever a problem once ).
  3. Make the edits to the text field on the right. Sometimes easier to do in a text editor. Or use one of the "Tools" in the pop-over. I tried to include samples of how things work where I could.
  4. Click "Set Clipboard" once you have replaced what you want. The "objectType" field determines how the script attempts to set the clipboard. There are different formats for each object type. Tables, Fields, Scripts, Script Steps, Custom Functions, plain text.
  5. Paste your FM objects to your destination.

Login is: admin/admin

Link Expires: 3/27/2021

6 Likes