Jump to content
Sign in to follow this  
Totes

Need help changing portal row fields

Recommended Posts

Hi,

Been struggling with this for a few hours now.

I have a portal on my layout and one field is a Yes / No field, at some point I need the user to be able to change the yes/no field in the portal to a “Yes” answer in all the portal rows which show up for that record..

I have tried the setfield script but it only changes the first portal row field to “Yes”

Is there a way to change the yes/no field in all the portal rows for a particular record at one time.

Thanks,

James

Share this post


Link to post
Share on other sites

There is no simple way, all methods will require a script.

The script needs to use the Go to Related Record (GTRR) step to "find" the portal records in their table, then loop through the found set of related records and use the Set Field step to enter the "Yes". Then return to the original layout.

Go to Related Records [ relationship ; layout ]

Go to Record/Request [ first ]

Loop

Set Field [ field ; "yes" ]

Commit Record/Request [ no dialog ; no validation ]

Go to Record/Request [ next ; exit after last ]

End Loop

Go to Layout [ original layout ]

Refresh Window [ fluch cached join results ]

The Replace [] step can be used in place of the Looped Set Field.

Share this post


Link to post
Share on other sites

Be careful when using the replace function as it requires that field to be on the layout, it's all too easy to "tidy" a layout at some point in the future and remove the field thereby breaking the script. For this reason I tend to use the looped set field.

Edited by Guest

Share this post


Link to post
Share on other sites

Replace does NOT require the field to be on the layout. It did in FileMaker 6 and earlier.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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