6 Replies Latest reply on Jun 12, 2013 1:04 AM by manjit

    Auto refresh of portal


      Hi all,

      Is there a way that I can forcibly edit a record? What I mean is, I have a portal that has radio buttons for data entry. It is unlikely that 2 people will need to change the condition on the same radio button simultaneously. I need to display the portal with up to the minute info on 2 devices.


      How can I allow user A to modify data in a portal when user B is also viewing the portal, this user may also be changing another radio button at the same time, but user B would be on changing a radio button on a different row.


      Would I need two tables then and somehow keep them in sync in a third table? Or is there an easier way? As Im typing I am thinking of other ideas... may be set up a script timer that releases the record after a few seconds of inactivity but still allows viewing of the portal?




        • 1. Re: Auto refresh of portal

          How has FileMaker behaved so far in your testing of this situation? What have you already tried?

          • 2. Re: Auto refresh of portal

            Have you tried using a global to view the related data?

            • 3. Re: Auto refresh of portal

              It sounds like you're running into a record commit issue. When a user edits a record, the changes he makes aren't seen by the other users until they're committed to the database. If that's the case, you might need to put a Script Trigger on the radio button to commit the record as soon as the user makes a selection. Might solve it.



              • 4. Re: Auto refresh of portal

                Yes... Peter is right.


                When editing a portal you also have the record you are viewing open unless the relationship to the data is via a global field relationship.


                What you need is a script step attached to the buttons scripts which commits the record after changing the values. The smallest amount of time that the records are open the better.


                If summary values in the portal have not updated, you can add a script loop which just goes to the summary field in the first portal row then to the same field in the nest row until the last row when it exists and commits.


                - Lyndsay

                • 5. Re: Auto refresh of portal

                  Thanks everyone,

                  I will go through your posts and get back to you next week. I will be out for a few days.


                  • 6. Re: Auto refresh of portal

                    Looking into your problem it seems like you are hanging in a solution of record locking while more than 1 user try to edit the same record. This cannot be possible as if you want to lock the record for User-1 by flagging current record the commit of record will not reflect to user-2 unless that user refresh his/her open window/ the related portal. Again suppose User-1 is editing the same record at the same time User-2 cannot able to commit the recent modifications done for the same record unless or until the User-1 release that particular record. This is a data integrity property of Database.


                    If you want to allow this type of modifications then you need to create a temporary table where you provide set of records for the same table for each user and once an user finished modification on the particular field it will trigger a script to update the original record in the actual table. This will help you to provide the feature you are searching for.



                    with regards,

                    Manjit Behera

                    Software Developer, Mindfire Solutions, India



                    Skype: mfsi_manjitb