hi all,

i have a field as a pulldown. i'd like to have another field that collects the selections made by the user using the pulldown and add them together like this:

If (PatternCount (CollectedWordsField, singleWordPull), CollectedWordsField, CollectedWordsField + " " + singleWordPull)

both CollectedWordsField and singleWordPull are defined as text fields..

this if doesn't work. Why?

thanks...

i almost figured it out...

now i have this:

If(PatternCount(allLocalKyewords, InternalKeywords) = 0, allLocalKyewords + " " + InternalKeywords, allLocalKyewords )

it works if PatternCount(allLocalKyewords, InternalKeywords) = 0 but it doesn't do anything if PatternCount(allLocalKyewords, InternalKeywords) = 1.

why?

Perhaps because those are funky numbers you're adding...

Try using the & operator between your strings instead of addition +.

right, it's already working.... thanks...

now the pulldown updates it but it doesn't keep the values. it replaces the previous value with the new one every time i select something from the pulldown. to keep the values i have to copy the existing combination back to the field that holds them all. can i make the pulldown to trigger an action to do that. i did a button with one and that does it fine but it'll be better if it's only one step thing.

apparently a field can not update itself - circular action...

thanks again

I have developed demos of several different approaches which can be used to achieve this without the two-step buttpon process you are using at present.

One technique is based on an automatically compiled calculation using the GetField ( ) function. However, this function was introduced with v5.5, so it won't work in an earlier version. To get the calculation to update, you have to click out of the record (ie it picks up the last value you select when you leave the record).

The other method uses a paused script attached directly to the pop-up field.

Rather than explaining the steps in detail, I've attached a zip archive which includes two unlocked example files - one showing each method. If you have a look at how they are set up, hopefully they will give you some ideas to work with?!

autolists.zip

many thanks to CobaltSky...