4 Replies Latest reply on May 3, 2017 12:56 PM by philmodjunk

    Change status of multiple records in Assets db via script

    kmicb5

      I've customized the canned database "Assets" for my environment. I created a layout that lists all records regardless of status. I added check boxes so you can select multiple records. I created a button that "should" change all selected records either from "Checked In" or "Checked Out" via a script. I know how to go to the first record and loop through them to export them, but I can't figure out how to check them in or out in bulk. For exporting selected records, my script is:

       

      Enter Find Mode [ Restore ; Pause: Off ]

      Perform Find [ Restore ]

      Go to Record/Request/Page [ First ]

      Loop

        Set Variable [$filePath ;

        Value: Choose (Abs(Get(SystemPlatform)) -1; Get (DesktopPath) & “FMExports/“ & Documents::Document & “ “)]

        Export Field Contents [Documents::Document ; “$filePath”

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

      End Loop

       

       

      I "assume" that line 7 (Export Field Contents) would need to be something along the lines of "change field to <status here>" or something of the sorts. Can't figure out. Help? lol