Table of Contents

Solution Training Case

Hello learner!

In this section, we will create together a solution. Under this link you will find video that shows that process step by step. In every part of that case you will also find Documentation.


pic


Overview

This document is a guide to build a small Profitbase Solution. The idea is that the user should get a basic understanding of how to build a planning solution and the most common features of Profitbase LOW CODE.

Using this simple example, we want to show you how the Invision LOW CODE can be easy and fun. The goal of this guide is to build a small solution for a movie collection with ranks and short descriptions using many useful components.

pic


1. Creating and setting up the Workbook

In this section you will find instruction on how to create solution, Structure Folders, and setup Access Control.
See also Interface Introduction Video, Access Control Videos.

  1. Create new solution:

pic


  1. Create folder and Workbook:

pic


  1. Add page and set up the selected properties:

pic


  1. Add your Access Group in Workbook Permissions:

pic


  1. Remember to publish your changes:

pic


2. Themes and styling


In this section you will find instruction on how to change logo and edit System Theme Variables, without using css styles. Here you will find more about Themes and styling.


  1. Open Assets tab and drop your logo to the Image Library.

pic


  1. Open Themes and Styles tab, create new theme, click edit theme images, and find your logo in the dropdown list.

pic


  1. Choose your theme for the workbook.

pic


  1. You can overwrite System Theme Variables in the Main Theme section. Here you will also find sections for Accesibility and Style Sheets.

pic

3. Dimension


In this section you will find instruction on how to create a Dimension.
See also Dimension Videos and step by step documentation.


  1. Right-click on the folder and add a new item.

pic


  1. Add columns in the Schema tab.

pic


  1. Add or automap Attributes.

pic


  1. Create a Hierarchy and add Attributes to it.

pic


  1. Add data and Publish.

pic


4. Filter


In this section you will find instruction on how to create a Filter.
See also Filter Videos, and step by step documentation.


  1. Right-click on the folder and add a new item.

pic


  1. Find a Dimension in the table resources and drag and drop it into the filter container.

pic


  1. Find the filter in the resources and place it in the workbook.

pic


  1. Set up the Loading event for the Workbook or Page.

pic


5. Table View


In this section you will find instruction on how to create and customize a Table View.
See also Table View Videos and step by step documentation.

  1. Right-click on the folder and add a new item.

pic


  1. Find the table view in the resources and place it in the workbook.

pic


  1. Set up the Loading event for the Workbook or Page.

pic


  1. Write a query in the data sourde declaring filter in the first line.

pic


  1. Bind the filter in the table view properties.

pic


  1. Set up the OnSelectionChanged event for the filter.

pic


  1. Add columns in the data grid tab for the table view.

pic


  1. Set up properties.

pic


6. Custom Cell Renderer


In this section you will find instruction on how to customize cells using Custom Cell Renderer. See also Custom Cell Renderer Video and step by step documentation.

  1. Find column that you want to customize, open renderer window and write your code.

pic


  1. To help you we created also some samples that you can use.

pic


7. Table


In this section you will find instruction on how to create a Table.
See also Table Videos and step by step documentation.

  1. Right-click the selected folder in the Solution Explorer to add a new item, choose a Table:

pic

  1. Add columns by drag and drop or using "Add column" option:

pic

  1. Choose the data type:

pic

  1. Add the data:

pic


8. Form Schema


In this section you will find instruction on how to create a Form Schema.
See also Form Schema Videos and step by step documentation.


  1. Right-click the selected folder in the Solution Explorer to add a new item, choose a Form Schema:

pic

  1. Create the Grid:

pic

  1. Create a Model and bind it, remember to use the filter property:

pic

  1. Style Form Schema with CSS:

pic

  1. Add Form Schema to the Workbook:

pic

  1. Check "is Action Link Column" box in properties of the Table View column:

pic

  1. Add OnTapped event in the in the Table View:

pic

  1. Add Load action and SetParamValue to conect the data:

pic