1 Reply Latest reply on Aug 8, 2011 1:49 PM by philmodjunk

    Copy content from portal fields

    remoran_1

      Title

      Copy content from portal fields

      Post

      I have a portal from which I am able to go to a portal row and copy conetent from two fields in the portal to fileds outside the portal using a go to portal row script without a problems but in the same row, I have two additional fields that are lookups into another table that I also need to copy into outside fields as well. What happens when I invoke the script is the first two fields in the selected portal row works without issue but the two lookups copies always comes from the first row of the portal and not the secodn. The portal itself works exactly as it should but for the life of me, I can't get the lookup files to work as they should. Any help on this would be great.

      TIA

      R. Moran

       

        • 1. Re: Copy content from portal fields
          philmodjunk

          It might help to see a copy of that script.

          Some part of that script, possibly a commit records step, possibly others is changing the layout focus and that loses track of what portal row was current at the time you initiated this script. You can capture the row number in a variable in order to return to it. There is also likely a way to do what you want without interacting with portal rows like this.

          Scripts that interact with portal rows are vulnerable to breaking when someone alters the layout design in the future. It isn't always possbile, but if you can get the job done without interacting with specific portal rows, your script is less vulnerable to such issues.

          To post a script to the forum:

          1. You can upload a screen shot of your script by clicking the edit link to your original message and uploading it there
          2. You can upload a screen shot to a file share site and post the download link to a new response you post here.
          3. You can print a script to a PDF, open the PDF and then select and copy the script as text from the opened PDF.
          4. If You have FileMaker advanced, you can generate a database design report and copy the script as text from there.
          5. If you paste a text form of the script, you can use the Script Pretty box in the Known Bugs List database to paste a version that is single spaced and indented for a more professional look to your script. (Use the HTML option and paste the text into the HTML editor.)