Skip to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Set Fields across a found set

Featured Replies

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

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

Different questions I think.

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

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

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.

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 cool.gif

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

  • Author

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

  • Author

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.

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.