How to add triggers to your Orca Scan sheet

You can use Triggers to add if-this-then-that logic to your sheets without code. Each Trigger is made up of:

• Condition = what must be true for the condition to be met
• Action = what should happen when the condition is met

By enabling Triggers, you can do things like:

• Show and Hide Fields Conditionally
• Set Low on Stock Notifications
• Receive Emails When an Item is Damaged
• Split Barcode Data into Separate Fields

Use triggers to automatically split complex barcode data, such as GS1 or VCard, into different fields, eliminating the need for repetitive data entry.

How to enable Triggers in your sheet

1. Log in to the Orca Scan web app and use the bottom navigation bar to open the sheet where you want to add a trigger
2. Click on the Triggers icon located in the top-right corner of the sheet
3. Click Add from the triggers tab to begin the setup process
4. Giving your trigger a clear, descriptive name is essential for easy identification and management. Choose a name that reflects the purpose of the trigger, for example, “Request damage details if the vehicle is damaged”
5. Conditions determine when a trigger should activate. Define the specific scenario that must occur for the trigger to activate, for example, “Description contains Damaged”
6. Set a trigger action; this is what you want to happen when the defined condition is met, for example, update a field, send a notification, or apply a rule
7. Click Save to confirm and apply your settings

Tip: Test the trigger by scanning a barcode or entering data to see if it activates as intended

Conditions

Actions

Advanced Condition Options

For more complex scenarios, you can use advanced conditions like Regular Expressions (RegEx) or GS1 Application Identifiers (AI):

Matches RegEx

Regular Expressions (RegEx) are powerful tools for detecting specific patterns in text. In addition to validation, they can be used to extract, split, or reformat data with the set value action.

Example

Given the RegEx pattern (\\d+)-(\\d+)-(\\d+)-(/d+)$ , you can match and extract groups of digits separated by hyphens.

Using the following as input:

**12345-67890-54321-98765**

You can reference these matched groups as $1, $2, etc., to extract specific parts of the string.

• First Group: $1 → Output: 12345
• Second Group: $2 → Output: 67890
• Third Group: $3 → Output: 54321
• Fourth Group: $4 → Output: 98765

We love Regular Expressions, but they can be tricky. RegEx 101 is a great tool to use when writing and testing your expressions. If you need step-by-step guidance, RegexOne offers fantastic tutorials, or you can reach out to us!

Contains GS1 AI

GS1 (also known as Global Standards 1) is an international standards organisation that has set a series of standards for how information is encoded within a barcode.

These globally adopted standards help computer systems around the world make sense of physical objects as they move through the supply chain.

The Contains GS1 AI condition can be used to perform an action when a barcode contains a specific GS1 Application Identifier.

When used in conjunction with the set value action, values such as serial number, expiry date, etc, can be extracted from a GS1 barcode and moved into a relevant field/column.

How to Set Up Low Stock Notifications

Set up a low stock level for each specific Item:

1. Create a minimum stock column
   • Add a new column Min Stock, and assign it a Data type of Number
   • Ensure to Save
   • Enter the minimum stock levels for each Item
2. Add a trigger using the following:
   • If field - Quantity
   • Condition - Is Less Than
   • Condition Value - [Min Stock] (Use exact column name inside squared brackets [] )
   • Then - Notify me
   • Notify Via - Select a notification method

Now, whenever a product quantity falls below the Min Stock level, you will receive a notification with related product information.

How to Set Up Expiration Notifications for Scanned Products

Set up an expiry date for each product:

1. Create an expiry date column
   • Add a new column Expiry Date, and assign it a Data type of Date
   • Ensure to Save
   • Enter the expiry date for each item
2. Add a trigger using the following:
   • If field - Expiry Date
   • Condition - Is Less Than
   • Condition Value - $DATE:NOW
   • Then - Notify me
   • Notify Via - Select a notification method

Now, whenever you scan a barcode for a product that has expired, you will receive an immediate notification with the relevant product details.

Questions about triggers?

We’re always happy to help; chat with us live or drop us an email.