Senseforce 2.0 Manual
  • Welcome to Senseforce 2.0
  • SF MQTT API
  • SF Edge
    • Edge Package Overview
    • Edge Installation
      • Using the SF Edge Service installer in command shell
      • Headless SF Edge Servie execution
    • Edge Configuration
      • Which Plugins to load (appsettings.xml)
      • Edge Data Routing (EventDefinition.xml)
      • OTA configuration (otasettings.xml)
      • Edge Logging
      • Input plugins
        • SQL Plugin
        • SQLite Plugin
        • OPC UA Plugin
          • OPC UA server browser
        • SIEMENS S7/SINUMERIK Plugin
          • Creating connection definition file
        • S7 Plugin
        • REST Plugin
        • TCP Listener Plugin
        • XML File Parsing Plugin
        • Heidenhain Plugin
      • Output Plugins
        • MQTT Plugin
        • SQLite Plugin
    • Edge Compute plugins
      • Creating compute plugins
      • Using compute plugins
  • SF Edge Asset Management
    • Edge version repository
  • SF Platform
    • Navigation
      • Overview Screen
    • Dataset Builder
      • Filters, Aggregations and Groupings
      • Functions of the Formula Editor
      • Additional Settings
      • Special Events
      • FAQ and Troubleshooting
    • Script Editor
      • Details of the Script Editor
      • Installed Packages
      • Working with Timestamps
        • Working with Timestamps in Python
        • Working with Timestamps in R
      • FAQ and Troubleshooting
    • Widgets
      • Text
      • Headline
      • Image
      • Progress Bar & Gauge Chart
      • Table
      • Map
      • Line, Bar, Scatter and Area Chart
      • Pie Chart
      • Gantt Chart
      • Histogram
      • Overview
      • Log
      • Default colors and color conditions
      • FAQ and Troubleshooting
    • Dashboards
      • Dashboard Filters
      • Favorites
      • Data Drilldown & Widget Interaction
      • Editing multiple dashboard widgets
      • Time Zones
      • Synchronized Zooming
      • Sharable Dashboard URL
      • Multi-chart layout options
      • Default sort for table widgets
      • Releases
      • Reporting
      • FAQ and Troubleshooting
      • Applying zoom to global timestamp filter
      • Optimise the layout for different devices
    • Machine Master Data
      • Dimensions
      • Instances
      • Things
      • Use Case
      • FAQ and Troubleshooting
    • Automation
      • Trigger
      • Scheduling overview
      • Actions
      • Test your Automation
      • Zapier integration (necessary internal steps)
      • Zapier integration
      • Subscriptions
      • FAQ and Troubleshooting
    • Event Schema Management
      • Importing a Event Schema
      • FAQ and Troubleshooting
    • Virtual Events
      • Creating a Virtual Event
      • Scheduling Overview
      • Permissions and Data Access
      • FAQ and Troubleshooting
    • Details modal for elements
    • Copy / Duplicate elements
    • Whitelabeling
    • Edge Device Management
    • Element History
    • Public API
      • Get your access token
      • Endpoints
      • Debugging scripts
      • FAQ and Troubleshooting
    • User & Group Management
      • FAQ and Troubleshooting
    • Active Directory & SSO Setup
Powered by GitBook
On this page
  • Action: Mail
  • Action: Integration

Was this helpful?

  1. SF Platform
  2. Automation

Actions

PreviousScheduling overviewNextTest your Automation

Last updated 2 years ago

Was this helpful?

After configuring the you can add actions to your automation with the button in the left sidebar.

After you added an action you can choose between two types of action

  • Mail, sends an email to the given addresses if the trigger condition is true at the scheduled time. You can add entries from the first row of your data source.

  • Integration, uses a integration if the trigger condition is true at the scheduled time. You can use all the data from the trigger data sources as well as from additional data sources.

Action: Mail

Adding a mail to your actions will send an email to the given addresses and/or all users in the given groups in case the trigger gets activated.

To use email as an action you only need to set a name, the subject of the email, and the message. To define the mail receivers you can either provide a list of email addresses and/or select one or many groups. If you selected groups as receivers, every member of your selected groups will receive the triggered email.

Note that when you select groups as recipients you can see the number of users currently in a group next to the group name:

When you use @ in the message you can select one of the columns of your data sources. Note that this will only display the first entry from this column, not the whole column.

Define Time Zone

The time zone dropdown gives the possibility to convert dates (timestamps) from your columns to a specific time zone.

The defined time zone is available as a variable for the message. With this it is possible to add information about the time zone that are used for the dates.

If no time zone is defined the default time zone "UTC" is used.

Trick: How to display more than the first entry in an email

Use the following code in a script to transform a column into a string that contains all entries separated by ', '. If you use this script as a data source you can append this entry to your email.

# in PYTHON
# if the column is not of type string, convert first
dataset['column'] = [str(x) for x in dataset['column']]

# use output as result variable
output = ', '.join(dataset['column'])
# in R
# use output as result variable
output <- paste0(dataset$column, collapse = ', ')

If you want to display a whole table you can use,

# in PYTHON were df is a pandas.DataFrame
# use output as result variable
output = ', '.join(list(df.columns))
for i, row in df.iterrows():
    output += '\n ' + ', '.join([str(x) for x in row])
# in R were df is a data.frame
# use output as result variable
output <- paste0(names(df), collapse = ', ')
for(i in 1:nrow(df)){
    output <- paste0(output, '\n ', paste0(df[i,], collapse = ', '))
}

Action: Integration

When you use @ to display one of your column's first entry the data will not be shown if you but it will be added correctly if the action is executed due to the trigger.

You can find information on how to set up integrations and details on how to use them .

trigger
Zapier
test the action
here
here