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 bgscott
      I have an application where some of the related files will reside on removable media.  When sorting, a message box appears telling the user that the related file (which is not on the server) can not be opened (Not Found) and asks the user to locate it.  The related file may or may not be available on the removable media and is not needed for the purposes of the sort.
      Is there anyway to prevent this message from appearing?  Error capture on does not solve the problem
    • By St3v1e
      New user
      I have a "Search" script setup in one of my layouts, which works well but I'd like to refine it a little to make searching quicker and with less mouse clicks.
      Currently, I have a field into which I enter a client name, and a "Search" button which activates a search throughout my database for any records containing this name. For the search to work I have to input the name (or a portion of it) into the "Search Name" field , and then click on the "Search" button.
      What I'd like to happen is to enter the name into the field and then hit the enter key to activate the same search. Is this possible?

      Thanks in advance.
    • By ChrisOC
      Has anyone integrated Smartsheet with FileMaker using Claris Connect? I can get the basics set up and am able to create a Flow that will add a new record in FM when a row is added in Smartsheet.  However, I can't seem to figure out how to pass any column data from that row into the new FM record.  It does not give me the tags for any of the columns from my sheet, only high level parent and body tags.  What am I missing?  
    • By paulkivett
      My first try using a Server Side Script. I'm importing csv data which is on "This PC / Documents/CompPBM_checks.csv". I have tried every possible path, but still get missing file error. Options tried include
      file:ThisPC/FileMaker Server/data/documents/CompPBM_checks.csv
      $Import equals: Get ( DocumentsPath )&"CompPBM_checks.cvs"
      FM Server is hosted on AWS
    • By pixi
      Has anyone played with latest FMS Linux and LetsEncrypt-Certificates? 
      (How) does it work?
  • Who Viewed the Topic

    8 members have viewed this topic:
    AJ Venice  Oyseka  Matt.C  LAIRY  bcooney  comment  Ocean West  Krisola 
  • Create New...

Important Information

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