AnsweredAssumed Answered

Change status of multiple records in Assets db via script

Question asked by kmicb5 on May 3, 2017
Latest reply on May 3, 2017 by philmodjunk

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 ]


  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