Set Fields across a found set

[snatkins]

I am looking for a way to set a field across a found set. I want to be able to do a Find and then mark those in the found set to all have the same text in a certain field. I am also wondering if there is a way to have a dialogue box come up to create the text that will go into the field.

A script that allows me to do this would be great - I have tried to build one but am having some issues.

Thanks! Sarah

[efen]

Is this a double post? -- seems to be similar to question in the other forum -- Naming a Found Set in a portal for Found Records

[Ender]

Different questions I think.

Sarah, check out the Replace Field Contents command or script step.

[Søren Dyhr]

I want to be able to do a Find and then mark those in the found set to all have the same text in a certain field.

I can admitted slightly pompously say, not a particular nomalized desire ...a related record with all ID's of the records in a pilcrow delimited field does this better than a scripted replace!

--sd

[Ender]

not a particular nomalized desire ...a related record with all ID's of the records in a pilcrow delimited field does this better than a scripted replace!

I don't think this is the way to go. I have a pretty normalized structure, but I still have many fields that categorize records in different ways. There are plenty of times when I then have to change a set of records to a different category. Using a Replace or Set Field loop is an easy way to do this.

In the case where the text is normalized to a second table, the foreign key to the correct related record would reside in the main table, and changing it for a set of records would still require a Replace or Set Field loop. Using a multikey of the main table's IDs as the match key for a second table seems like a big mess to me.

[Søren Dyhr]

Why should the multiline reside in the main and not on foreign side, except you think it's a mess?? Have this topic ever been discussed??? I could imagine it made some sence in our ongoing Recuring Event dabate??

Admitted that using globals for "trafic terminal" could prove messy, but script parameters is much more clean ...obvious ...straight forward

It have now after considerable time occured to me how convenient Rays custom function is for this particular task:

http://www.briandunning.com/filemaker-custom-functions/detail.php?fn_id=39

If listA is the multiline key on the foreign side, then will his function remove the value in listB from listA if it occures there, but it misses does it add it ....All done with one single line of Set Field and listB as scriptparameter!!! The Jeff Almquist method have gone even more intutive ...

http://www.fmforums.com/threads/download.php?Number=159735

--sd

[snatkins]

I admittedly, haven't checked this for a while - was away - and now it seems people have added more posts, and I really don't get what you're saying at all...I am a beginner / intermediate but I have found it hard to follow what you have posted.

thanks, sarah

[snatkins]

I also guess I forgot to mention something: I want to be able to do this multiple times - i.e. the set text would be either in a repeating field or a portal (haven't decided yet) so that a record might have multiple i.d.'s...I don't want to replace the text every time - I want to be able to add a new text.