« Abu Ghraib and the question of leadership | Main | Groundwork for a better GUI »

FM7 Portal Row Edits and Commits

I ran into an odd problem while working on my project management application in FileMaker 7. In one of my views, I have a portal in which the fields are enterable and editable "inline". You'll see in my picture portalrowthat I have included a button that pops up a small detail window that shows users more details about that portal row and allows them to edit and add additional data to that portal row.

The crux of the problem is this. If you are "sitting" in a field in a portal row and then click the button (the blue plus sign) which does a "GTRR" (go to related record) of displaying it in a new, smaller window, you'll run into a record lock that prevents you from editing the record in the detail view because the lock from the referring window hasn't been released. If, however, we release that lock by committing the record BEFORE we do our GTRR, we'll lose the focused portal row and wind up going to the wrong related record (actually, always the first related record).

Solution
The idea is to be able to commit our record but still return to our portal row before doing our GTRR script. This is where script parameters come to our rescue. scriptparameter Pass the Get ( PortalRowNumber ) function as script parameter with that button. We can now safely commit the record, return to the portal row by the value of the script parameter and happily do our GTRR.

TrackBack

TrackBack URL for this entry:
http://www.typepad.com/services/trackback/6a00d8341ca89053ef00d83504b0f453ef

Listed below are links to weblogs that reference FM7 Portal Row Edits and Commits:

Comments

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment