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

Thanks,

I will give it a try this afternoon.

James

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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

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