2 Replies Latest reply on Mar 1, 2017 9:15 AM by TomEdge

    Container field not pasting into first record.

    TomEdge

      This started happening after 1/18/17 so I'm assuming it has to do with 15.0.3 update.  I have a local table on an iPad that syncs with a table on the server when the driver returns with signed pack slips.  Everything worked fine until the 18th of last month.  Now when syncing it doesn't copy over the signature for the first record in the set, but does for the remaining as it loops through.  Signatures didn't come up missing until after 1/18/17 and I have made no changes to the code in months.

       

      -Tom

        • 1. Re: Container field not pasting into first record.
          TSPigeon

          TomEdge:

           

          Thank you for your post!

           

          Could you provide a sample of the script that isn't working as you expect?

           

          I can't find any changes that were made in 15.0.3 that would affect an import or insert script step.

           

          TSPigeon

          FileMaker, Inc.

          • 2. Re: Container field not pasting into first record.
            TomEdge

            Here's the code.  Another client is running this same application on two iPads.  Of the two, only one has upgraded to 15.0.3 the other is still running 15.0.2.  The one running 15.0.2 is still pasting in the container data for the the first returned record.  Only the one that is running 15.0.3 stopped doing it after the upgrade.

            I omitted the code after the loop...

             

            -Tom

             

             

                

               - Allow User Abort

               - Set Error Capture

               - Go to Layout

               - Freeze Window

               - Go to Layout

               - Set Variable

               - Set Variable

               - Set Variable

               - Set Variable

               - Go to Layout

               - Set Variable [ $$Server; Value:"fmnet:/" & tblPreferences_PL::Server &"/workorder - data.fmp12" ]

               - Set Variable

               - Go to Layout

               - If

               - Go to Record/Request/Page[ First ]

               - Loop

               - If   --Everything but the signature is copied over for the first record.  

             

               - Set Variable

               - Set Variable

               - Set Variable

               - Set Variable

               - Copy [ Select ]

               - Go to Layout

               - New Record/Request

               - Set Field

               - Set Field

               - Set Field

               - Set Field

               - Paste [ Select ]

               - Go to Related Record [ Show only related records ]

               - Set Field

               - Go to Layout

               - Commit Records/Requests[ Skip data entry validation; Force Commit ]

               - End If

               - Go to Layout

               - Go to Related Record [ Show only related records ]

               - Set Field

               - Go to Layout

               - Perform Find [ Restore ]

               - Set Variable [ $Path; Value:Get(TemporaryPath) & $Packlist & ".pdf" ]

               - Save Records as PDF [ Document - ][ Pages - Number Pages From: 1; Include: All pages ][ Security - Printing: High Resolution; Editing: Any except extracting pages; Enable copying; Enable Screen Reader ][ Initial View - Show: Pages Panel and Page; Page Layout: Single Page; Magnification: 100% ][ Restore; No dialog ]

               - Send Mail [ Send via SMTP Server; To: $$MailTo; Subject: tblPacklist_Header::Packlist; Message: "Attached signed packlist..."; Attachment: “$Path”; Name: "eReceipts"; Email Address: $Email; SMTP Server: $SMTP; Port: $Port; Use TLS; Authentication Type: Plain Password; User Name: $Email; Password: $Password ][ No dialog ]

               - Go to Layout

               - Go to Record/Request/Page[ Next; Exit after last ]

               - End Loop

               - End If

             

             

                  From: TSPigeon <noreply@filemaker.com>

            To: Thomas Edge <tomedge@yahoo.com>

            Sent: Wednesday, March 1, 2017 8:24 AM

            Subject: Re:  - Container field not pasting into first record.

                

             

            Container field not pasting into first record.

            reply from TSPigeon in Report a Product Issue - View the full discussionTomEdge: Thank you for your post! Could you provide a sample of the script that isn't working as you expect? I can't find any changes that were made in 15.0.3 that would affect an import or insert script step. TSPigeonFileMaker, Inc.

            Reply to this message by replying to this email, or go to the message on FileMaker Community

            Start a new discussion in Report a Product Issue by email or at FileMaker Community

            Following Container field not pasting into first record. in these streams: Inbox

             

             

            Manage your email preferences

             

            FileMaker Developer Conference 2017 • Phoenix, Arizona • July 24-26 • www.filemaker.com/learning/devcon