Jump to content

Merge 2 field names (not text)

Recommended Posts


I moved fields (and scripts) from one FM file to another one.

Now, I have a table to 2 fields that has same function but different names, example: Container1 and Container2

Both have their own attached scripts and calculations.

I would like to merge "container2" into "Container1" field so the attached scripts and calculations will also change, but I can't rename it simply to "container1"

is there a way to without going through all the scripts and calculations?




Link to post
Share on other sites
14 minutes ago, Amanco said:

I would like to merge "container2" into "Container1" field

Not sure what exactly "merge" means in your scenario. Suppose you have a record where Container1 contains Image1.jpg and Container2 contains Image2.jpg. Which of these images should the "merged" field contain, and what should happen to the other image?


Link to post
Share on other sites

I am basically looking to remove the field "Container2" and use it as "Conatiner1".  So image2.jpg to move it to "Container1".

but i am looking mainly to change the field name first from "Container2" into "Container1" so all the attached scripts and calculations will change as well, so I don't have to do change them manually. 

but because the field with the name "container1" already exists in the table, I can't rename it.



Thank you

Link to post
Share on other sites

If the scripts and calculations you want to use reference the Container1 field, then move your content to the Container1 field, then delete the Container2 field.

Note that the actual field name is irrelevant here. Filemaker uses IDs to link to referenced fields.


Link to post
Share on other sites

Both fields "Container1" and "Container2" have referenced scripts and calculations. 

I mean by changing the field name, the name will also change in all the scripts and calulations. In this case I want them all to be "Container1"

2 minutes ago, comment said:

Filemaker uses IDs to link to referenced fields.


In this case, is it not possible to make them all reference to the field "Container1" apart from doing it manually?

Link to post
Share on other sites

That's not possible - at least not within Filemaker*.

(*) It is sort of possible if you copy the script/calculation field as XML, modify the XML in another application and paste it back. But if you make a mistake, you could end up destroying your file.


Edited by comment
Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Similar Content

    • By Mike_FM
      Hi all,
      I would like to create a page count for a found set of records when I am in preview mode and when I export to PDF  ie if a found set of records has 3 pages then the first page would contain a field that reads '1 of 3'
      Can anyone help with how to achieve this?
      Any help is much appreciated
    • By Don_Macaroni
      I cannot select inside an input field at a specific character. Clicking on the field works and selects the field, but I then need to use the arrow keys to go to a specific characters. Mouse clicking at a specific characters does nothing. Anyone has experienced this?
    • By Mike_FM
      Hi all,
      I have created a portal in a related table and I want to apply a filter to it so that it only shows the latest versions from a found set of records and to hide the others. There is a related field within the portal called 'scan version' which displays the version number as eg 'v001' 'v002' 'v003' etc
      I've been hunting around online to find a calculation that fits my needs and have played around with the 'Max' function but to no avail
      If anyone can give me some pointers that would be awesome, I'm still very new to this and learning so any help is always appreciated!
      If you need any more info please let me know
      I have just worked this out and used the following calculation
      Scans::Scan Versions = Max ( Scans::Scan Versions )
      and it worked!
    • By Selva
      I have tried to pass the below JSON data to the API. But it doesn't accept the JSON data due to Square brackets[] in the JSON Key. Is there any solution available to pass the below value?
      JSONSetElement ( "{}" ; "[Name | Last]" ; "Test" ; JSONString )
      We need the output like below.
      "[Name | Last]": "Test"
      Thanks in advance.
    • By Mike_FM
      Hi all,
      I'm a film editor and have started building a FM database to be able to track visual effects shots that go in and out of an editing timeline. 
      I am trying to create a calculation that will enable me to add frames to timecode and get the result back in timecode.
      At the moment I have a text field called 'Scan TC In' which has the following TC entry 18:59:48:23 (HH:MM:SS:FF) and I need to add 8 frames to it, the timeline runs at 24 frames a second. 
      Does anyone know how I can achieve this?
      I'm a newbie to FM so any help is greatly appreciated!
  • Who Viewed the Topic

    6 members have viewed this topic:
    Matt.C  comment  Laura Griffin Long  Stefano Parmeggiani  doughemi  Ocean West 
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.