automated way to determine if a field is an auto-enter calculations and lookup fields

[LaurenKuhlman]

I'm dealing with a rather large system and have written an automated way to build out lists of all the non-container, non-calculation, non-global, non-summary fields. Now, I need to also exclude lookups and auto-enter replaces existing value fields. Here's the calculation as it stands:

 

not ( 

   PatternCount ( $field_type; "StoredCalc" ) or 

   PatternCount ( $field_type; "Summary" ) or 

   PatternCount ( $field_type; "UnstoredCalc" ) or 

   PatternCount ( $field_type; "Global" ) or

   PatternCount ( $field_type; "Container" )

)

 

Any ideas on how to obtain this information with a function? 

 

Thanks!

 

I also attached the script I'm working on as a PDF though I doubt referencing it is necessary.

 

FileMaker Pro 13, Mac OSX Mavericks

[comment]

I don't see a script attached. In any case, I don't know of a way to collect this information other than by producing a Database Design Report (unless there's some undocumented ExecuteSQL code?). Why would you need this inside the solution anyway?

[DanShockley]

I don't see a script attached. In any case, I don't know of a way to collect this information other than by producing a Database Design Report (unless there's some undocumented ExecuteSQL code?). Why would you need this inside the solution anyway?

 

I'm almost certain 'comment' is correct.

If your system runs a DDR on some kind of schedule, you could set up something to parse the XML generated for "Field" nodes whose "AutoEnter" sub-node has the attribute "overwriteExisting"=True. 

 

 

Are you doing this to be able to automate some kind of backup/export/data-transfer process? If you say more about why are trying to do this, there may be other possibilities. 

[Rick Whitelaw]

I'm not at a computer at the moment but I don't believe it's possible to script the creation of a DDR.