Real World Use Cases

The following examples are provided to assist you in developing your own scripts. Please be aware of the disclaimer for these examples.

Important:

Oracle may provide sample code in SuiteAnswers, OpenAir Help Center, User Guides, or elsewhere through help links. All such sample code is provided "as is” and “as available”, for use only with an authorized OpenAir Service account, and is made available as a SuiteCloud Technology subject to the SuiteCloud Terms of Service at www.netsuite.com/tos where the term “Service” shall mean the OpenAir Service.

Oracle may modify or remove sample code at any time without notice.

• Validation

  • Ensure value of multiple commissions fields equals 100%

  • Require notes field to be populated on time entries when more than 8 hours in a day

  • When submitting an expense report, validate each ticket has an attachment (e.g. scanned receipt)

  • Ensure resource time entry matches booking planning and project worked hours

• Automation

  • Optionally create a new Customer PO when editing a project

  • Create time entries from task assignments when the user creates a new timesheet

  • Control budgeted hours for a project using the project budget feature and a custom hours field

• Workflow

  • Prevent a booking from being created if the selected resource has approved time off during the booking period

  • Prevent closing a project that has open issues

  • Automatically create a new issue when project stage is "at risk" and prevent project stage from changing until this issue is resolved

  • Send an alert email when a scheduled script completes

  • Send a Slack notification when issues are created or (re)assigned

Note:

Find these examples on the Platform Solutions catalog page in OpenAir Help Center. See Platform Solutions Catalog.

Using the Examples

Before you start, make sure you have the necessary switches enabled in your test account, see Getting Started.

Note:

You need to be signed in as an administrator to work with the development environment.

To try out the examples:

1. Sign in as an Administrator and navigate to the Administration > Scripting Center.

2. Follow the steps described in the Setup section for the example. See Quick Start for more details.

   Tip:

   Save time by using the solution file link provided at the top of each setup section, see Creating Solutions.

3. See Scripting Workflow and Testing Form Scripts.

Platform Solutions Catalog

Find the real world use case scripting examples on the Platform Solutions catalog page in OpenAir Help Center.

To view the platform solutions catalog, go to User Center > Help Center > Platform Solutions. The page lists all the real world user scripting examples described in this guide. Solutions are color coded by category — Validation, Automation, Workflow — with a visual representation and a short summary to indicate the purpose of each solution.

• To save the solution XML file, click the DOWNLOAD link. You can then import the solution file from the Scripting Center in OpenAir.

• To read the help topic describing the solution, click the LEARN MORE link.