Versions Compared

Old Version 1

changes.mady.by.user Nikita Kamai

Saved on

compared with

New Version Current

changes.mady.by.user Katerina Kovriga

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space TFAC and version Draft

Overview

                                                   The Source Table:


                                                            The Result:


Use Case №1

Use the ConfiForms TableView and the ConfiForms TableView Merger macros to show the data in a table format and combine them with our app.

Info

Find more information about the ConfiForms app on the documentation site and in the Quick tutorial on how to use ConfiForms TableView and ConfiForms Field to show the data in a table format.

Handy Carousel

Table Filter & ConfiForms TableView

1.  Add the Table Filter macro to the ConfiForms TableView macro. 

Info

Table Filter helps you to filter data, set default sorting, freeze rows and columns, calculate totals and more.

2.  Add filters to the table columns and set filter values.

Handy Carousel

Pivot Table & ConfiForms TableView

3. Add the Pivot table macro to the ConfiForms TableView  macro with filtered data.

Info

Pivot Table allows you to summarize and aggregate your table data.
You can select the following operations: Sum, Count, Min, Max, Average, Literal.

4.  Configure the pivot table.

Handy Carousel

Chart from Table & ConfiForms TableView

5. Add the Chart from Table macro to the already filtered and aggregated ConfiForms TableView macro to visualize data with the help of charts and graphs.

6. Set the parameters of the chart.

Handy Carousel


Use Case №2

Info

You can change the filtration criteria, the pivot table and chart parameters on the fly.
 The changes will be automatically applied to the data from the Office Excel macro.

Info

In this use case filtered data, the pivot table and chart will be automatically updated when the ConfiForms Form is filled in. 

Table Transformer & ConfiForms TableView

1. Add the Table Transformer macro to ConfiForms TableView.

Info

You can place  one or multiple tables within the macro body to merge, look up them or to perform custom calculations.

2. Select one of the presets or switch to the SQL query tab to use a custom SQL query. 

This SQL query allows you to create a new column with data outputted by condition.

Code Block
SELECT *, 
CASE 
WHEN 'Desired salary'<2000
THEN "Approved"
ELSE "Not approved"
END
AS 'Results'
FROM T*
Handy Carousel

Info

You can use the ConfiForms TableView macro with each of our macros separately or combine them according to your needs.