Select all non empty fields in a layout

[JeffC]

Hi all

My first post.Hope i make sense.

 

I have a layout with possibly 100 or more fields on different tabs.  I would like to be able to select all non empty fields on this layout and then place them in another layout as merge fields.  I would like to do this for one record at a time.

 

I feel there must be a way to script this or do it without 100's of "If " statements.

 

Any help greatly appreciated.

 

JeffC

[Lee Smith]

Hi Jeff, and welcome to the forum,

 

I moved your topic from "FileMaker Pro 12" to "Finding & Searching”, because the General Topic for FileMaker Pro 12 is for discussion of the new tools, functions and features that were introduced with that version of FileMaker and  not for asking how-to questions.

 

I moved it to this topic because you phrased it as a find question. However, there are several other topics this might have fit into but I’m not sure I’m understanding your need.

 

If you have any questions about this action, please contact me by Private Message.

 

Lee

[bruceR]

Jeff: I think you're going to need to explain things in more detail.

 

It always helps to provide a copy of your file. It can be an empty clone.

 

Why do you have hundreds of fields on a layout? It sound like you have a fundamental data structure design problem.

 

Scripting does not provide any way of using IF statement to control the contents of a layout.

[mr_vodka]

I second Bruce's comment. If you have a hundred fields with that many null or empty values then you most likely have a structure issue.