• Connect from ModScript to an external DB using ODBC

    Hello, I would like to ask if it's possible to connect from within a ModScript to an external database (Oracle) to retrieve data from a specific table. We have the following scenario: Another department asked us to automate SBM item creation for…
  • How to reset a Variant?

    I'm working on a modscript with a subroutine where I'm pulling in a field value a variant. I'm reusing this variant later for another call to the subroutine, but it seems to be holding on to the original value. How would I go about "resetting" this variant…
  • AppScript Multi-User Field and current user?

    Hello All, I'm trying to write an appscript to modify a multi-user field. Essentially I'm looking to set the script up so that a user can hit the quick transition button that calls this script, the script in turn should add that user to a multi-user…
  • Getting TS_ID in SBM App Script

    I need to get the TS_ID for my current item and pass it in a where clause. The script needs to run Post Transition. Call Shell.Item.GetFieldValue( "ID", varname) - doesn't work. varname = Shell.ItemId - doesn't work. What's the other options? Also, can…
  • Tranistion from an SBM Script

    Can I call a Tranistion from an SBM Script?