hey guys i need help on making a script for a record with a field titled "Source #"

I want it to be global if and only if a different field (with a drop-down menu) is set to "Open"

how would you make a button/script to make multiple "Source #" fields global?

Well you cant script to change the indexing options of a field.

Perhaps you can further explain what you are trying to achieve and we can assist you with a solution.

1st off it's gov. business... so i can't tell you any information on the database...

but i need to have a field stay constant based off of the "Closed" or "opened" status of a field...

if it's opened it needs to be globalized...

if it's closed i need the field to stay with the old field text

for instance...

record 1-open-version 1

record 2-closed-version 1

record 3-open-version 1

then globalized instance

record 1-open-version 2

record 2-closed-version 1

record 3-open-version 2

record 4,5,6,7...-open-version2

thanks in advance for the help,

Euka

"if it's opened it needs to be globalized..."

I think you'd better explain what you mean by "globalized".

And as Mr Vodka suggested, tell us your problem.

by globalized i mean the field is the same on all records except for the one already closed

so if the "opened/closed" field is open it needs to change to a text entered in the "source section" along with every other open field

does this help?

thanks

There is no such thing as a global with exceptions. You need a calculation field along the lines of:

Case ( Status = "Open" ; result1 ; result2 )

If you want, you can make result1 and/or result2 return data from a global field (the calculation will be forced to unstored in such case).

but i have to edit the text fields to tell it what to make global, with a calculation i can't edit the field, right?

Right - but you can edit the global(?) field/s referenced in the calculation.

ok this is how i set it up...

Here is the link to the photo

the fields on the right are global and are able to change...

i put in calculation

Case ( Closure Status="Open" ; Current Source Title ; Closure Status="Closed" ; Source Title ) 

then 

Case ( Closure Status="Open" ; Current Source Date ; Closure Status="Closed" ; Source Date)

then 

Case ( Closure Status="Open" ; Current Source Library # ; Closure Status="Closed" ; Source Library # )

then

Case ( Closure Status="Open" ;Current Source Document # ; Closure Status="Closed" ; Source Document # )

and it works... BUT ONLY FOR A SINGLE RECORD AT A TIME... I need it to change all "open" records to the current fields...

HELP...

I'm so close i can smell it...

It's very difficult to see anything in your screen shots. Are you using a calculation field?

i think i have it in text...

but if i have it in calculation i can't keep the old text, correct?

i have it on auto-enter mode... could we run a conditional statement to change the Source title, etc. fields to the current source title,etc., HOW would that look?

I still can't see anything in your screen shot (you're giving us Mac users a bad name...).

And I don't understand what you mean by "keep the old text". The texts need to be kept in text fields. If one of these needs to a global field, the calculation must be unstored - and that can only happen in a calculation field.

Take a look at the attached file - I believe it shows all possible combinations.

Globals.fp7.zip

...(you're giving us Mac users a bad name...).

Eukanuba shows Windows XP :qwery:

UPDATE: I know, I know, it looks like something I would do but ...

Edited June 17, 200817 yr by Guest

Hm. I could have sworn... Say, you didn't change it just to pull my leg, did you? Because i could have sworn...

If I'd have thought of it - and if I could have - and if I wouldn't mind messing with someone else ... then you can bet I'd have been tickled to pull your leg. But alas no, I didn't change it. :jester:

Well, then I guess it's beginning.

NO-SIR-EEEE-BOB-CAT-TAIL

hey i think i solved it based upon your file... thanks man...

what i did was to create a new layout and have a field called "Current Source Title" which was global in a footer then i had a field called "Original Source Title" as a text-stored value then a calculation based on "source title" which was dependent on whether the Open/closed field status...

thanks guys...