# Mass change of field source in layouts

**URL:** <https://the.fmsoup.org/t/mass-change-of-field-source-in-layouts/1893>\
**Category:** Questions\
**Tags:** layout\
**Created:** [March 13, 2021, 11:33am UTC](https://the.fmsoup.org/t/mass-change-of-field-source-in-layouts/1893 "2021-03-13T11:33:30Z")\
**Posts on this page:** 17\
**Page:** 2

<div class="post-metadata">

**Author:** ![jormond](https://avatars.discourse-cdn.com/v4/letter/j/35a633/32.png) [@jormond](https://the.fmsoup.org/u/jormond)\
**Post date:** [March 14, 2021, 5:06pm UTC](https://the.fmsoup.org/t/mass-change-of-field-source-in-layouts/1893/21 "2021-03-14T17:06:49Z")

</div>

> [@Bobino](#):
>
> Claris is working on putting Edge in the webviewer for windows instead of IE.

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.

---

<div class="post-metadata">

**Author:** ![jormond](https://avatars.discourse-cdn.com/v4/letter/j/35a633/32.png) [@jormond](https://the.fmsoup.org/u/jormond)\
**Post date:** [March 14, 2021, 5:07pm UTC](https://the.fmsoup.org/t/mass-change-of-field-source-in-layouts/1893/22 "2021-03-14T17:07:26Z")

</div>

The file I use is a FileMaker file with BaseElements. It's cross-platform.

---

<div class="post-metadata">

**Author:** ![jormond](https://avatars.discourse-cdn.com/v4/letter/j/35a633/32.png) [@jormond](https://the.fmsoup.org/u/jormond)\
**Post date:** [March 15, 2021, 4:31am UTC](https://the.fmsoup.org/t/mass-change-of-field-source-in-layouts/1893/23 "2021-03-15T04:31:38Z")

</div>

@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

> **[Joshua Ormond sent you 1 item](https://www.dropbox.com/t/r5URAS3wfFx9D7ai)**
>
> utilities.fmp12

---

<div class="post-metadata">

**Author:** ![jormond](https://avatars.discourse-cdn.com/v4/letter/j/35a633/32.png) [@jormond](https://the.fmsoup.org/u/jormond)\
**Post date:** [March 15, 2021, 9:40am UTC](https://the.fmsoup.org/t/mass-change-of-field-source-in-layouts/1893/24 "2021-03-15T09:40:55Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![flybynight](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/flybynight/32/1023_2.png) [@flybynight](https://the.fmsoup.org/u/flybynight)\
**Post date:** [March 20, 2021, 1:01am UTC](https://the.fmsoup.org/t/mass-change-of-field-source-in-layouts/1893/25 "2021-03-20T01:01:22Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![flybynight](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/flybynight/32/1023_2.png) [@flybynight](https://the.fmsoup.org/u/flybynight)\
**Post date:** [March 20, 2021, 10:32pm UTC](https://the.fmsoup.org/t/mass-change-of-field-source-in-layouts/1893/26 "2021-03-20T22:32:33Z")

</div>

The ChangeFieldsContext.fmp12 file is from [1-more-thing](https://www.1-more-thing.com/en/). 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):

 ![image](https://canada1.discourse-cdn.com/flex030/uploads/fmsoup/original/2X/b/b4f4b266e30eb8432846cc8c32466ab869d02f13.png)

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::

---

<div class="post-metadata">

**Author:** ![planteg](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/planteg/32/627_2.png) [@planteg](https://the.fmsoup.org/u/planteg)\
**Post date:** [March 20, 2021, 11:58pm UTC](https://the.fmsoup.org/t/mass-change-of-field-source-in-layouts/1893/27 "2021-03-20T23:58:39Z")

</div>

> [@flybynight](#):
>
> The ChangeFieldsContext.fmp12 file is from [1-more-thing](https://www.1-more-thing.com/en/).

@FabriceN Hi Fabrice, can you provide more information about this file @flybynight talks about ?

Thanks

---

<div class="post-metadata">

**Author:** ![jormond](https://avatars.discourse-cdn.com/v4/letter/j/35a633/32.png) [@jormond](https://the.fmsoup.org/u/jormond)\
**Post date:** [March 21, 2021, 1:46am UTC](https://the.fmsoup.org/t/mass-change-of-field-source-in-layouts/1893/28 "2021-03-21T01:46:13Z")

</div>

I have another file that does do that stuff... but that file is also not mine. LOL

---

<div class="post-metadata">

**Author:** ![rivet](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/rivet/32/1727_2.png) [@rivet](https://the.fmsoup.org/u/rivet)\
**Post date:** [March 21, 2021, 10:21pm UTC](https://the.fmsoup.org/t/mass-change-of-field-source-in-layouts/1893/29 "2021-03-21T22:21:30Z")

</div>

[TextMate Bundle for FileMaker](http://donovanchan.github.io/Filemaker.tmbundle/) 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.

---

<div class="post-metadata">

**Author:** ![FabriceN](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/fabricen/32/2506_2.png) [@FabriceN](https://the.fmsoup.org/u/FabriceN)\
**Post date:** [March 22, 2021, 8:05am UTC](https://the.fmsoup.org/t/mass-change-of-field-source-in-layouts/1893/30 "2021-03-22T08:05:18Z")

</div>

Hello,  
sorry, I'm late in the battle. Here is @FredoMkb 's file "Change Field Context".  
It requires BaseElements plugin.[ChangeFieldsContext.fmp12](https://the.fmsoup.org/uploads/short-url/amdsfIPfTHSZGF7DkLQDNxp7Cha.fmp12) (564 KB)

---

<div class="post-metadata">

**Author:** ![lsnover](https://avatars.discourse-cdn.com/v4/letter/l/9dc877/32.png) [@lsnover](https://the.fmsoup.org/u/lsnover)\
**Post date:** [March 23, 2021, 12:30pm UTC](https://the.fmsoup.org/t/mass-change-of-field-source-in-layouts/1893/31 "2021-03-23T12:30:52Z")

</div>

I have MBS, didn't know this was possible. What feature is used to accomplish this?

---

<div class="post-metadata">

**Author:** ![jormond](https://avatars.discourse-cdn.com/v4/letter/j/35a633/32.png) [@jormond](https://the.fmsoup.org/u/jormond)\
**Post date:** [March 23, 2021, 1:05pm UTC](https://the.fmsoup.org/t/mass-change-of-field-source-in-layouts/1893/32 "2021-03-23T13:05:45Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![harvest](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/harvest/32/231_2.png) [@harvest](https://the.fmsoup.org/u/harvest)\
**Post date:** [March 23, 2021, 2:15pm UTC](https://the.fmsoup.org/t/mass-change-of-field-source-in-layouts/1893/33 "2021-03-23T14:15:07Z")

</div>

welcome to the soup 🙂

[https://www.mbsplugins.eu/component\_Clipboard.shtml](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

---

<div class="post-metadata">

**Author:** ![lsnover](https://avatars.discourse-cdn.com/v4/letter/l/9dc877/32.png) [@lsnover](https://the.fmsoup.org/u/lsnover)\
**Post date:** [March 23, 2021, 8:05pm UTC](https://the.fmsoup.org/t/mass-change-of-field-source-in-layouts/1893/34 "2021-03-23T20:05:49Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![jormond](https://avatars.discourse-cdn.com/v4/letter/j/35a633/32.png) [@jormond](https://the.fmsoup.org/u/jormond)\
**Post date:** [March 23, 2021, 8:26pm UTC](https://the.fmsoup.org/t/mass-change-of-field-source-in-layouts/1893/35 "2021-03-23T20:26:34Z")

</div>

The link is at the bottom of this post: [Mass change of field source in layouts - #23 by jormond](https://the.fmsoup.org/t/mass-change-of-field-source-in-layouts/1893/23)

---

<div class="post-metadata">

**Author:** ![Kirk](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/kirk/32/2197_2.png) [@Kirk](https://the.fmsoup.org/u/Kirk)\
**Post date:** [February 25, 2022, 5:38pm UTC](https://the.fmsoup.org/t/mass-change-of-field-source-in-layouts/1893/36 "2022-02-25T17:38:39Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![FabriceN](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/fabricen/32/2506_2.png) [@FabriceN](https://the.fmsoup.org/u/FabriceN)\
**Post date:** [March 8, 2022, 9:29pm UTC](https://the.fmsoup.org/t/mass-change-of-field-source-in-layouts/1893/37 "2022-03-08T21:29:12Z")

</div>

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-more-clip](https://marketplace.claris.com/fr/detail/1393.html)**
>
> Gérez vos extraits de code, vos fonctions, vos actions de script... et gardez-les sous la main.

[Previous page](https://the.fmsoup.org/t/mass-change-of-field-source-in-layouts/1893.md?page=1)
