Removing Calculated Results in Fields

[longojim]

I have a FMP 5.5 database with thousands of fields. A bulk of them contain a calculated result which defaults to a "No" radio button being selected. Is there some type of generic script loop that would go to each field - remove the calculated result - and have the field validation set to an existing Yes/No value list - then move to the next field? Thanks for any suggestions.

[Fitch]

Thousands of fields? Or thousands of records?

[bruceR]

I have a FMP 5.5 database with thousands of fields. A bulk of them contain a calculated result which defaults to a "No" radio button being selected. Is there some type of generic script loop that would go to each field - remove the calculated result - and have the field validation set to an existing Yes/No value list - then move to the next field? Thanks for any suggestions.

You need to answer Tom's question. But I believe the action you're looking for is the "Replace" action which can enter a constant value or a calculated value into all records in the found set.

[longojim]

I have over 4000 fields. About 900 of these have an auto-entered "No" in their definition. I was wondering if I could loop through the fields to first identify those with the auto-entered "No", and second, remove it (uncheck the auto-enter box in the field definition dialogue box) - but still have the field validation continued to be tied to the existing value list of "No/Yes". Again - thanks for any tips.

[CobaltSky]

Hi longojim,

From what you're saying, it sounds like what you need is a third-party scripting/automation tool that will let you control the interface (Manage Database and Options for Field dialogs) to spped up what is otherwise going to be some pretty laborious hack work. Suffice to say that there is no native way to script changes to field options in FileMaker.

There are a few tools of that kind around. We use QuicKeys for Windows here with reasonable results, but there are various others.