Hi, I am new to filemaker and I use filemaker heavily as an end-user at the new workplace. Without altering the filemaker program by 1) creating scripts that show up under the menubar(I am not the Filemaker admin), or 2) use of plug-ins. How can I copy cell data to the clipboard. For example in SQL(I know filemaker doesnt read SQL like this) I could do a SELECT name FROM cola WHERE value = lime; and then that cell(s) in filemaker being active or copied to the clipboard. I plan on writing a script to automate a lot of the tasks I do with the data from CERTAIN cells in filemaker and the only thing I cannot figure out is how to make a specific cell or cells active without clicking it with the mouse nor using the magnifier find glass. The rest I can do. I have looked at the export functionality and cannot find anything that suites my needs.

Make a new layout with just the fields (cells) you want to copy on it.

Change to this layout.

Invoke* the Copy All Records command to copy that field for all records in the found set.

*Copy all Records is Option-Copy on MacOS, not sure what the modifier key is on Windows. It'll either be Alt, Ctrl or Shift. The Edit menu should display Copy All Records when the right key is pressed.

You will probably need admin acces to do create the new layout.