Advanced Feature: Enhance your data with logic

To ease your start into a productive February, we’ve decided to further introduce you to working with our powerful function “Enhance with Excel”. In short, this feature enables you to take any data from e.g. an online source and to enrich them with the logic from your own Excel, e.g. to predefine how the pulled […]

Damian Roller

Features

To ease your start into a productive February, we’ve decided to further introduce you to working with our powerful function that allows you to enhance your data with logic. In short, the feature “Advanced: Enhance with Excel logic” enables you to take any data from e.g. an online source and to enrich them with the logic from your own Excel, e.g. to predefine how the pulled data should be handled or further processed.

How this works

To get started, we are going to import data from a web service. How this works is explained HERE.

import data from a webservice
import data from a webservice 2

After we have connected the web service we would like to use as our basis, we need to select the data with which we’d like to work. As a demo case, we’ve decided to pull the data on all countries in the world via Restcountries.eu.

After importing the data, we select “Advanced: Enhance with Excel logic” in the lower right corner.

select "Advanced: Enhance with Excel logic"

For the next steps, we have prepared a small guide that explains how we can add excel logic to our existing data.
As the first step, we have to download the excel file containing the current data. Please note that the first sheet of the downloaded file acts as a placeholder for content from your data source. Your app will have the latest data here at any given time later!

first step, download the excel file containing the current data

To avoid any conflicts with the data source, we’ve created a second tab to which we add our analysis. In our case, we added a small chart showing the regions of the countries from our data source in an aggregated pie chart.

second tab to which we add our analysis

After adding our analysis, we re-upload the excel sheet and continue the app creation process.

continue the app creation process

The Open as App creator automatically recognizes the elements that we added on our analysis tab, and we can use those in our app. Below you see the pie chart that we created in our Excel sheet inside our app.

recognizes the added elements and use those in our app

With this feature, you can easily enrich your data and make them more meaningful than ever before!
As we are working with live data, your app is always up-to-date!

Any questions left? Hit us up and we are happy to help you!

Category

App App Apps Best Practice Case Studies Events Features Guide Guides Press Uncategorized Webinars

Popular posts

Alexandra Müller

How to optimize your workflow analysis with a smart app 

workflow analysis

Alexandra Müller

Creating digital signatures: All information at a glance

digital signature

Alexandra Müller

Conducting an energy audit: How a smart app can help you

energy audit with app

Alexandra Müller

How can I create my own iPhone app without coding?

creating an iPhone app

Borislav Kiprin

20 innovative Tools for Excel & Google Sheets in 2023

Innovative Tools Excel

Alexandra Müller

Survey tools: The 6 best alternatives to Google Surveys

survey app

Alexandra Müller

Factory acceptance test via app – what you need to know

Factory Acceptance Test per App

Alexandra Müller

Mandatory recording of working hours – how apps can help with the implementation

recording of working hours with apps

Alexandra Müller

How to optimize your manufacturing process plan with apps

Manufacturing process planning with apps

Alexandra Müller

Project management: Why you can’t go without a checklist

Projektmanagement-Checklist

Alexandra Müller

11 good reasons for your business to have an app

Young urban professional man using smart phone in office building indoors. Businessman holding mobile smartphone using app texting sms message wearing suit jacket and bag.

Alexandra Müller

Construction site safety checklist – how an app can improve safety

Checkliste für Baustellensicherheit – mit einer smarten App zu mehr Sicherheit

Alexandra Müller

How much does it cost to develop an app?

Wie hoch sind die Kosten für die Entwicklung einer App?

Alexandra Müller

How to create your digital construction daily log

Digitales Bautagebuch mit Open as App erstellen

Alexandra Müller

Creating CRM systems with Excel

CRM-Systeme mit Excel erstellen

Alexandra Müller

How to make money with no-code apps

make money with no-code apps

Alexandra Müller

The 8 best app makers

Mit einem App-Baukasten einfach eine App selbst erstellen

Alexandra Müller

How can I create an app?

App erstellen - so funktioniert es

Alexandra Müller

Embedding an iframe – what you need to know

Embedding an iframe - step by step

Borislav Kiprin

Create an App With Google Sheets for Your Business

Create an app with Google Sheets

Manfred Streit

How to Turn an Excel Spreadsheet Into an App

Excel spreadsheet into an app

Manfred Streit

The Basic Guide to No-Code Apps and Platforms

basic guide no-code apps

Damian Roller

Self-Service Apps based on Spreadsheets – Three Strategies for Beginners

self service app

Damian Roller

4YFN Barcelona – Hotspot for Innovation & Impact

MWC und 4YFN Barcelona

Damian Roller

Open as App appoints Michael Stoelwinder as new CEO

Michael_Stoelwinder_OpenasApp

Damian Roller

New Pricing Plans in 2021

pricing

Damian Roller

No-Code Tools Comparison: Open as App and Glide Apps

successful no-code tools

Damian Roller

How to boost your workflow automation with no-code apps

workflow-automation-no-code-apps

Borislav Kiprin

Custom mobile app development in Microsoft 365

Custom mobile app development

Damian Roller

How to Select between BI and Excel Data Analysis [Tableau Alternative]

Tableau Alternative

Borislav Kiprin

Enhancing App Security and Data Protection: No-Code Apps

app security

Damian Roller

Bread baking per app – enjoy great home-made bread every day

home made bread

Borislav Kiprin

How to Drive Digital Innovation without the IT Department

digital innovation

Borislav Kiprin

How a Multi-Devices KPI Report App Can Improve Performance

KPI report App

Damian Roller

Best 8 No-Code Apps to Boost Real Estate Agent Performance

Boost real estate agent performance

Borislav Kiprin

Open as App adds the power of non-technical citizen developers to Microsoft 365

microsoft

Let's keep in touch!

Skip form
Form skipped
Newsletter-Girl
workflow analysis

Alexandra Müller

How to optimize your workflow analysis with a smart app 

digital signature

Alexandra Müller

Creating digital signatures: All information at a glance

energy audit with app

Alexandra Müller

Conducting an energy audit: How a smart app can help you

creating an iPhone app

Alexandra Müller

How can I create my own iPhone app without coding?

Innovative Tools Excel

Borislav Kiprin

20 innovative Tools for Excel & Google Sheets in 2023

survey app

Alexandra Müller

Survey tools: The 6 best alternatives to Google Surveys

Factory Acceptance Test per App

Alexandra Müller

Factory acceptance test via app – what you need to know

recording of working hours with apps

Alexandra Müller

Mandatory recording of working hours – how apps can help with the implementation

Manufacturing process planning with apps

Alexandra Müller

How to optimize your manufacturing process plan with apps