The timing on this is going to shift to be more aggressive at this point. Microsoft is going to be dropping it soon. So it forces everyone to move sooner rather than later.
1 Like
The file I use is a FileMaker file with BaseElements. It's cross-platform.
2 Likes
@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:
- Copy the FileMaker thing, or plain text.
- 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 ).
- 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.
- 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.
- Paste your FM objects to your destination.
Login is: admin/admin
Link Expires: 3/27/2021
6 Likes
To a small degree, this actually kind of serves as a clip manager for a few things. Though overall I’m using Dropship.fm and aText for most Clip management.
I’m not at my computer right now, but I have a utility called ChangeFieldsContext.fmp12. I don’t remember where I got it or who made it. I know the notes are in English and French.
You copy your layout objects, paste it into this file and enter a start and end table occurrence names and click a button, then paste the results back in your layout. It’s pretty neat.
2 Likes
The ChangeFieldsContext.fmp12 file is from 1-more-thing. Unfortunately, I can't find it on their site, or I would link you to the correct page. And since it's not mine, I'm not going to distribute it. Here is what it looks like (with the last example of my real-world use):
I would contact them if you are interested.
I took a look at @jormond's utilities file above, and that looks super handy as well. If you added a couple of fields and a button to do the find/replace (substitute) on the edit XML text field, you'd have the same thing without the preview image. Probably more handy, as you could do multiple changes in one pass if you have more than one TO in your objects that need changing. Example:
Invoices_PACKINGSLIPS:: ==> SalesOrders_PACKINGSLIPS::
and
Invoices_PackingSlips_PACKINGSLIPITEMS:: ==> SalesOrders_PackingSlips_PACKINGSLIPITEMS::
1 Like
@FabriceN Hi Fabrice, can you provide more information about this file @flybynight talks about ?
Thanks
I have another file that does do that stuff... but that file is also not mine. LOL
TextMate Bundle for FileMaker is a handy addon for TextMate.
Along with clipboard conversion, it has a handful of extraction and generation scripts.
eg.
extract field names
extract variable names
array to set variable steps
array to substitute statement
etc.
Plus Syntax highlighting, so it's a nice place to work out and tidy/indent calcs.
2017 was the last update but still good.
1 Like
Hello,
sorry, I'm late in the battle. Here is @FredoMkb 's file "Change Field Context".
It requires BaseElements plugin.ChangeFieldsContext.fmp12 (564 KB)
3 Likes
I have MBS, didn't know this was possible. What feature is used to accomplish this?
1 Like
Download my file. It uses BaseElements to do it. But MBS does it the same way. It’s primarily about converting the clipboard contents to/from the correct format.
I don’t know the specific functions for retrieving and setting the clipboard with MBS. Most of the work is calculating the correct format.
1 Like
welcome to the soup 
https://www.mbsplugins.eu/component_Clipboard.shtml
is the component to get lucky with, new in MBS 10 was the auto-detect of the FileMaker clipboard content, super convenient
2 Likes
Hi Josh:
I'm not seeing a link for your file. I did download 1 More Thing's file, but it appears to be locked. I have the MBS plugin, so if I can find an example that uses MBS, that would be great. Other examples are fine, but I need to see scripts to adapt to MBS, I believe.
1 Like
The link is at the bottom of this post: Mass change of field source in layouts - #23 by jormond
I talked to Fabrice about this (I use this tool all the time). One of his people developed it, and put it out for public consumption. Fabrice was considering polishing it up a bit and sharing it, but that conversation was a year ago. It is not available anyplace on the web officially, and I had to send a copy to @FabriceN as he was not aware at that time that it even existed.
Sorry for the late reply.
If someone needs Federico's tool, I still have it but it is not "supported" in the sense that we're not going to help you or reply if you have problems with it.
On the bright side, 1-more-clip, our acclaimed clipboard manager, always at your fingertips, now supports plain text and, yes, clip edition, including find/replace.
1 Like