top of page

ADD COLUMN - CONCATENATE

The 'Add Column' app is used to add an additional column to a table; in this configuration as concatentate of other columns of the same table.

ADD COLUMN - MATH

The 'Add Column' app is used to add an additional column to a table; in this configuration it adds the per item minimum value.

ADD COLUMN - PRODUCT

The 'Add Column' app is used to add an additional column as product as two other columns of the same table.

ADD CUSTOM ROW

The 'Custom Row' app shows how to insert rows in data lists, like partial sums, based on customized insertion criteria.

AUTOFILL

The Auto Fill app automatically fills in source data lists in the custom target format.

AUTOFILL - MULTIPLE SOURCES

The Auto Fill app automatically fills in source data lists from multiple tables in the custom target format.

BUSINESS LETTER (MS-Login)

How to create business letters quickly from list based data and auto-generate pdf in your OneDrive directory (requires MS-Login).

BUSINESS LETTER (PDF Pop-up)

How to create business letters quickly from tables-lists and auto-generate pdf.

BUSINESS PLAN VIA MENUE

With this app you can easily create per Menue a fully integrated P&L, cash flow and balance sheet plan in just a few minutes.

BUSINESS PLAN VIA TABLE

With this app you can easily create a fully integrated P&L, cash flow and balance sheet plan in just a few minutes from an assumption table.

CLEANING DUPLICATES

The Cleaning Duplicates app helps you to remove duplicate entries from your cells.

CLEANING LISTS

The Clean app helps you to clean data lists by punctuation, whitespace or other characters.

CONVERT TO 2 COLUMNS

This App converts a table in a two columns table by adding each header-title into a column named "Label".

CREATE LIST

This App is used to aggregate groups in columns. In this configuration all items per group are listed.

DATA MESSAGING (Recipient)

This app shows ,how a recipient is triggering own actions based on a data change of a Sender.

DATA MESSAGING (Sender)

This app shows, how a sender is sharing his data with one or many recipients. Recipients can then trigger own eventes on any data change.

DECRYPT

The 'Decrypt' App can be used to decrypt data that has been encrypted with the 'Encrypt' app.

DRILL DOWN PIVOT

Using the "Flexmonster Pivot"-App, quick data analysis can be done by displaying your data in a pivot table that can be completely customized.

DRILL DOWN TREE CHART

Render a tree-graph based on an input table.

The overview is presented in an interactive chart based on the D3.js JavaScript library.

DRILL-DOWN PIE CHART

The 'Sunburst'-App visualizes your data in an interactive chart based on the D3.js JavaScript library.

E-MAIL

The E-mail app can be used to automatically send tables or reports on a regular basis or whenever changes have been made to the data source.

ENCRYPT

The 'Encrypt' App can be used to encrypt your data. The data can be decrypted again with the 'Decrypt' app.

EXECUTE BY PARAMETER

This App shows how to run a preconfigured Task with other parameters. Not recommended for beginners.

EXISTING OR NOT

The Crosstab app can be used to summarize and organize data in a different form.

In this configuration, the table is sorted by its elements and an "X" is output for each element found.

EXPAND LISTS

Maintain list data a,b,c.. more easily by expanding each list item to rows and back.

EXTRACT CODE

Extract code components specifying a search pattern.

FETCH MASTER DATA

The ‘Fetch Master Data’ app can be used to fetch and analyse master data among different user groups flexibly and efficiently.

FILE WIZARD (GitHub)

This app shows, how to read files from your Github Repository, transform them and store the transformed files back to Github.

FILE WIZARD (OneDrive)

Read files directly from your One Drive-Account and transform them according to your needs (MS-Login required).

FILL EMPTY ROWS

The "Fill Empty Row-App" can automatically fill empty rows using existing data.

FILTER

Filter your data with complex filter criteria easy and transparent without coding.

FILTER BUCKETS

Filter all groups that contain items of your filter criteria; find e.g. all customers that have bought a special item.

FIND DUPLICATES

Find common text-parts in a list. This App allows to quickly identify common name parts in data lists zur datenbereinigung.

FIND DUPLICATES AND ALLOCATE

Find common word-parts in a list; allocate those common words-parts to the source rows.

FIND GROUP

Find all subgroups in lists. This App is suited to search for common sub-trees in tree like structures.

FIND RANGES

With this App, you can bin data to user defined ranges. This allows a data categorisation.

FORMATTING

The "Format"-App allows you to add formatting information to table columns e.g. to apply date or currency format.

FORMULA

The Formula App recalculates a column. In this example, a function is applied on other columns of the same table.

FORMULA - CONCATENATE

The Formula App recalculates a column. In this example, one column is build as concatenate of other columns of the same table.

GERMAN CITIES

An overview of all cities and towns in Germany.

The overview is presented in interactive charts based on the D3.js JavaScript library.

GET MARKED FIELDS

The 'Get Marked Fields' app extracts all cells highlighted in Excel with e.g. a background colour (only useful for Excel-Add-In).

GROUP AND SUM

The Sum-Up app can be used to group, combine, and mathematically manipulate the data to summarize the data the way you want.

GROUP SUMMARY

The Sum-Up app can be used to group, combine, and mathematically manipulate the data to summarize the data the way you want.

HEADER TO LABEL

The App is very helpful to convert header information of a table into labelling the table items.

INVOICE

With this app you can create a PDF invoice as pop-up from a list of article items.

A single Invoice is generated and can be stored as PDF file.

JOIN

Join two tables if both tables have one ore more common identifier colums.

LIST BY GROUPS

With this app, you can group, combine, and mathematically manipulate the data to summarize it the way you want.

MASK

The 'Mask' App can be used to mask data, e.g. to make numbers or characters unrecognizable by '***'.

NOTE TRACKER

The "Note Tracker"-App helps you easily record notes e.g. to quickly take notes on bills or other items.

REMOVE DUPLICATE ROWS

The ‘Remove Duplicate Rows’ app can be used to remove duplicate rows in a data list. This app can also be used to remove empty records, whitespaces, duplicate values, and specific characters in a data table.

REPLACE

Durchsuche alle Listenelemente einer Tabelle 1, vergleiche ob diese in einer Substitut-Tabelle 2 vorkommen und ersetzte die gefundenen Textstellen mit denen der Substitut-Tabelle.

REPLACE PLACEHOLDER

Replace Placeholder allows to replace a placeholder in column 1 with content of the same row in column 2.

REPLACE PLACEHOLDER - X

Replace Placeholder allows to replace a placeholder in column 1 with content of the same row in column 2.

ROW BY ROW

Use "row by row" to add trailing averages, growth and more to top-to-down data lists.

SAVE MASTER DATA

The ‘Save Master Data’ app can be used to organize master data among different user groups flexibly and efficiently.

SERIES INVOICES (OneDrive)

With this app you can create serial PDF invoices from a list of items and save them in your OneDrive Directory.

SPLIT TO COLUMNS

The "Split"-App lets you separate values and split them into columns. This way you can separate data from each other.

SPLIT TO ROWS

Split a record by whitespace, punctuation, line-break or any other custom divider into rows.

In this configuration, the records are split by punctuation and re-sorted into rows.

SUM GROUPS

This App is used to aggregate groups in columns. In this configuration the Sum of all group items is build.

TEMPLATE ENGINE

Selectively specify the patterns for to be replaced code elements and run as a powerful template engine.

UNION

Combine two tables into one. Merge those columns that have the same column name.

UNIQUE

Generate a table containing only unique records; or generated a table that contains only duplicate records.

WORD LOOKUP

This app allows a pattern search on your data and returns the found patterns. In the current example we search for e-mail addresses and return name and domain separately.

TRANSFORMERS & DATA FLOWS

Welcome to our ever-growing universe of pre-configured, out-of-the-box data transformers and pre-configured data streams.

  • Share data on preset date or event with just a few clicks.

  • Package recurring tasks and spreadsheet calculations into data transformers, reducing manual tasks and sources of error.

  • Free yourself from time-consuming API management between applications and solve this with pre-configured transformers.

 

Enjoy using our free transformers and preconfigured data streams.

bottom of page