Flow Help
NovacuraRoadmap
6.12
6.12
  • What is Novacura Flow?
  • 📓System requirements
  • 🎉Release notes
    • Page 1
    • 6.12.2
  • 🎣Getting started
    • Quick start
    • Develop your first app
  • 🔨Installation and upgrade
    • Installation
    • New installation
    • Upgrade installation
    • Apply service pack
    • Add component
    • Windows authentication
    • Event log
    • FAQ
      • Monitoring
      • Troubleshooting
      • Migration tool
      • IIS user permission
      • Moving SQLite portal database
  • 🧱Security
    • Server
      • Security settings
  • 💡Development
    • Studio
      • Installation and log in
        • OpenID Connect
      • Applications
        • Menu
          • Inbox
            • Public variables
        • Workflow
          • Start step
          • User step
            • Header
            • Static text
            • Labeled static text
            • Link
            • External app launcher
            • Image viewer
            • Text input
            • Numeric input
            • Date input
            • Time input
            • Check box input
            • Binary option input
            • List selection input
            • List multi-selection input
            • Menu selection input
            • Image selection input
            • Data grid
            • Calendar
            • List presentation
            • Camera input
            • File gallery
            • GPS location input
            • Signature capture input
            • Item creation sub task
            • Check list sub task
            • Verb sub task
          • Machine step
          • Decision step
          • Assertion step
          • Assignment
          • Table
          • Checkpoint
          • Split
          • Join
          • Script item
          • Log point
          • Annotation
          • End step
          • Included workflow
          • Offline resource
          • Swimlanes
          • Offline workflow
            • Create an offline workflow
            • Create an offline resource
            • Create an offline seed inbox
            • Create an offline transactions
        • Subscribe
        • Server content
          • Workflow scheduler
          • Generate link
        • Elements
        • Problems
        • Find
        • Metadata panel
        • Version panel
        • Navigation
        • Test bench
        • Application package
          • Get started
      • Environment
        • Users
        • Roles
        • Connectors
        • Properties
        • Languages
        • System events
        • Active directory sync
        • License
        • Devices
        • Branding
        • Reports
      • Monitoring
        • Tasks
        • Applications
        • Help requests
      • Connectors
        • Business systems
          • Database
          • IFS Applications
          • Infor M3
            • M3 Infor API
            • Infor M3 REST
          • Maximo Generic
          • SAP
            • SAP BAPI
              • Basic API
                • BAPI: ZNCFLOW_APPLICATION_COMPONENT
                • BAPI: BAPI_MONITOR_GETLIST
                • BAPI: BAPI_INTERFACE_GETDOCU
                • BAPI: RFC_GET_FUNCTION_INTERFACE
                • BAPI: ZNCFLOW_DDIF_FIELDINFO_GET
          • Oracle Primavera
          • Microsoft Dynamics AX
          • Microsoft Dynamics CRM
          • Microsoft Active Directory
          • Microsoft SharePoint 2013
            • Generic operations
              • Custom list
                • Attachments
                • Create new item
                • Create new item, with field values
                • Delete item
                • Get items by query
                • List all items
                • List fields of items
                • Update item field
              • Document library
                • Check in/out file
                • File management
                • Create sub folder
                • Upload/download
              • Tasks
                • Attachments
                • Predecessors
                • Task information
                • Update task
                • Create new subtask
                • Create new task
              • User operations
                • Group operations
                • Get user by ID
                • Get user by login name
                • List users
        • Communication
          • Email
          • Web page submit
          • FTP
            • Server Operations
            • Directory operations
            • Download Operations
            • File Operations
            • Upload operations
          • SFTP
            • Directory operations
            • Download operations
            • File operations
            • Upload operations
          • Modbus
            • Read operations
            • Write operations
          • External Oauth 2.0 provider
          • Siox
          • REST service
            • REST Project Tool
              • Getting started
              • Operations
                • Parameters
                  • Computed parameters
                • Outputs
              • Models
                • Custom model member
              • Model transform
              • Global output
              • Global parameters
              • Authorization schemes
              • Enumerations
              • Tools
          • Web service
            • Example
              • Webservice example: Connector to Microsoft Dynamics AX
        • Printing
          • BarTender 2016
            • Print
            • Manually select
            • Print from BTXML script
            • Print from BTXML script
            • List printers
          • NiceLabel
          • Html to PDF
        • Utility
          • Flow environment
          • Table Operations
          • Custom .NET
          • Google API
          • Generate Xml Data
          • Generate text
          • File System
            • Directory operations
            • File operations
            • Zip operations
      • FlowScript
        • Variables
        • Operators
        • Functions
          • Text functions
          • Number functions
          • Date functions
          • Advanced functions
        • Table
          • Table functions
        • Programs
        • Formats
        • Script examples
        • AD sync scripting
    • Portal 2
      • Getting started
      • General
        • Add pages and portlets
        • Edit pages
        • Navigation
        • Style
        • Settings
          • List of values management
          • Presentation mode
      • Portlets
        • Chart portlets
          • Column chart
          • Line chart
          • Pie chart
        • Data tree
        • Document viewer
        • Filter
        • Html table
        • KPI portlets
          • KPI card
          • Speedometer
        • Record viewer
        • Table
        • Text
        • Common configuration
    • Portal
      • Get started
      • Options
        • Settings
        • List of values management
        • Global variables management
        • Content access management
        • Translations management
        • Import/export
      • Portlets
        • Table
          • Database source
          • Workflow source
        • Record viewer
        • Process overview
        • Iframe
        • Inbox
        • News viewer
        • Document tree
        • Document list
        • Document viewer
        • Generic document viewer
        • Generic document viewer URL
        • Generic document viewer
        • Filter
        • HTML
        • Text
        • Data visualizer card
        • Data visualizer navigator
        • Visual planning
          • Gantt chart
          • Kanban
          • Resource bucket
          • Scheduler
        • Map
      • Icons
  • 📱Clients
    • Android legacy client
    • iOS client
    • Windows 10 client
    • Web client
    • Windows CE client
  • ❓FAQ
    • How do i find which version of Flow i am running?
  • 📧Contact
Powered by GitBook
On this page
  • Create a workflow
  • First step
  • Get data
  • Use variables
  • Commit and publish
  • Add to menu
  • Run the app

Was this helpful?

  1. Getting started

Develop your first app

PreviousQuick startNextInstallation

Last updated 5 years ago

Was this helpful?

Here is a guide for how to create a simple app.

The app will allow the end-user to create an issue report that will be saved to a database.

As a Flow designer you will get to know how to:

  • Create a new workflow

  • Create a first user step where the user can enter data

  • Fetch and use data from a database

  • Insert data to a database

  • Publish an app

You will need an SQL server database to complete this app, download the database .

Create a workflow

, and create a new workflow:

Click on File and choose New.

  1. Create the first step by right clicking on the green start step and choose Add sequence arrow.

  2. Right-click again and choose Create user step.

  3. Enter a suitable name for the user step label.

  4. Double-click on the User step to enter the user step editor.

  1. Drag a Header object in to the center of the user step editor.

  2. Enter a text in the header, e.g. Welcome.

  3. Drag in a Text input field.

  4. Enter a prompt text, e.g. Enter name.

  5. Enter a target variable, e.g. Name.

  6. Drag in another Text input field and enter a prompt and a target value for email adderss.

  7. Click OK to save your changes.

Tips: Use the test bench to verify what you have done.

Start the test bench by clicking on the play button in the right corner or use the keyboard shortcut Ctrl+Enter.

  1. Right click and choose Create machine step.

  2. Right click on the Machine step and choose Add data arrow, connect the data arrow with the User step.

  3. Double-click on the Machine step to open the machine step editor.

  4. Select connector in the dropdown list.

  5. Select database call type and enter the query.

  6. Enter a variable name, e.g. DS_issueTypes.

  7. Click OK to save your changes.

Code to use:

SELECT [TYPE] "TYPE"
FROM   [dbo].[IssueType] 

Open the User step and configure a list to show the issue types.

  1. Drag in a Menu selection input.

  2. Enter a target variable for the output, e.g. issueType.

  3. Select table variable DS_issueTypes as data source.

  4. Enter a prompt, e.g. Select issue type.

  5. Enter row text, type a { to get a list of available variables, choose the TYPE variable.

  6. Choose TYPE as Field to select, and select Show empty option.

  7. Drag in a Text input field.

  8. Enter a prompt text, e.g. Enter issue description.

  9. Enter a target variable, e.g. issueDesc.

  10. Select multiline.

  11. Click OK to save your changes.

Tips: Use the test bench to verify what you have done.

Start the test bench by clicking on the play button in the right corner or use the keyboard shortcut Ctrl+Enter.

  1. Add another machine step, you can drag and drop a machine step from the Workflow elements area or right-click in the workflow area and select Create machine step.

  2. Use a sequence arrow and connect first user step with the machine step you just added.

  3. Double-click on the machine step to enter the machine step editor.

  4. Select connector in the dropdown list. The database call type should be set to script.

  5. Enter your sql script, enter a { to get a list of available variables, choose the name variable, do the same for the other variables.

  6. Click OK to save your changes.

Tip: Write @out_ to create an output variable for scripts. You can add several @out_ to add more values to the output record.

Code to use:

INSERT INTO [WorkOrder]
           ([NAME]
           ,[EMAIL]
           ,[ISSUE_TYPE]
           ,[ISSUE_DESC]
           ,[REPORT_DATE]
           ,[STATUS])
     VALUES
           (@name
	         ,@email
           ,@issueType
           ,@issueDesc
           ,GETDATE()
           ,'New')


SET @out_issueNumber = SCOPE_IDENTITY()

Add another user step, add one header and one static text field with information about the issue number. Enter a { to get a list of available variables, choose the issueNumber variable.

An app must be published to be available in the Flow clients.

  1. Commit the app by clicking on the check mark in the top left corner of the workflow area.

  2. Leave a comment that describes the change that were made, and click on Commit.

  3. Finally publish the workflow by clicking on the (space ship) Publish button.

For each commit a version will be created, all versions will be listed in the Version history panel. Open an old version by double-clicking on a version in the Version history panel.

  1. Create a menu, right-click in the server content area and choose New -> Menu.

  2. Enter a Title for the menu.

  3. Click on the + and choose Workflow item, select your workflow.

The app is now ready to run in any Flow client.

You can run all apps in the Flow clients on iOS, Android, Windows 10 and Web. You can download the Flow client app from Google store, App store and Microsoft store.

  1. Open the Flow client app, connect to your Flow server and enter username and password.

  2. When you are logged in, you will see the app under the menu tab, click on the app to start.

  3. Fill in the fields and click OK, cancel the execution by clicking the Quit button.

Tip: If your app doesn't appear in the client, check that the menu and user is assigned to the correct role.

First step

Get data

Tip: Use the magic wand to beautify the sql script in the machine step.

Use variables

Tip: Click on the wrench icon(Route 1) to change the button name to a more suitable name so the user understands what will happen when clicking on the button.

Commit and publish

Add to menu

Click on Edit roles in the bottom corner of the menu and check the roles that should have permission to the menu. Learn how to setup a role .

Run the app

🎣
👣
📡
🧙‍♂️
🌱
🔧
🤝
💼
🎠
🌊
here
here
Log in to Flow studio