I’m stumped or not thinking…
In designer, I open a database that has many forms. Each form has a field named Field1. How would I change the default value of Field1 from “Yes” to “No” without opening each form to change the default value manually?
Chad…
Subject: In Designer - change a field value on many forms
You can write LotusScript code to find all the forms, export them as DXL, change the default (or perhaps change it into a shared field), and import them again.
Subject: In Designer - change a field value on many forms
Why could he not run an agent on all the documents manually; something like:
SELECT@all;
@If(Field1 != “Yes”; “No”; “Yes”)? What am I missing? Thanks for any additional info about why such an agent would not work. Cathy
Subject: RE: In Designer - change a field value on many forms
Chad writes: “In designer…” So it looks like Chad really wants to change fields in forms. An agent only changes items in documents.
Subject: Thanks, Rod - I guess I missed that. (eom)
Subject: How many forms are you talking about?
Subject: In Designer - change a field value on many forms
Chad,
Forget these bozos with their “Rube Goldberg” overblown killing-a-mosquito-with-a-cannon solutions. Go with Cathy’s suggestion. That’s how I fix fields all the time.
Ken
Subject: RE: In Designer - change a field value on many forms
Read this first, to understand what we are talking about. Then read Chad’s original question again very carefully. Then read my reply to Cathy.
Subject: In Designer - change a field value on many forms
Get a time machine, go back to when you were first building the database, and make Field1 a shared field. If you use shared fields, you can use a single field definition on multiple forms. If you change that definition, it changes the properties of the field on every form where it appears.
Failing that, you’ll have to go to third-party tools. TeamStudio’s Configurator may help.