Qlik Sense Feedback Form - Part 1 or 3

Do you as a BI developer know what your BI users think about your dashboard and how it can be improved?

Perhaps an easy task for a small implementation, you just arrange a meeting... but what if you have many users? And even if you have few users - having a structured way of getting their feedback is probably a good idea.

The idea

It's quite easy to ask your users to send you mails or call you, but that will not be very structured. It's better to set up a simple poll-application in SharePoint or using some known "poll softwares" out there.... But I was thinking that if it was possible to have the "poll application" embedded into the BI solution itself - that would be the best solution, so that's what I set my goal on doing.

I wanted to mimic and digitalize those "Smiley Terminals" that we can find today when leaving a shop in the physical world. Having the users giving feedback to the developer at the moment they are just finished working with the dashboard.

Another goal was to visualize the feedback, immediately, to all users of the dashboard.

I discovered a method doing all those things. For free. Without coding!

In this blog post I will show you how any Qlik Sense Developer can do this, without any database programming skills or even without really any previous web development skills. It is even possible to develop all of this, only using a smartphone (as you know, including the Sense app).

This is how the end result will look like. It is completely done without any coding. Just some copy/paste things!

Tools

The tools used are: Qlik Sense, Qlik Dev Hub and AirTable.

Since you are redaing this, I assume you are aware of what Qlik Sense is, and how to add data with the load editor, and how to add charts and objects to the sheets. You may not be aware of what Qlik Dev Hub and Airtable is. So here is a short introduction:

Qlik Dev Hub, is a site that is delivered by Qlik and installed automatically when you install Qlik Sense Deskrop. With Dev Hub, you can create your own Qlik Extensions, Widgets and Mashups. Of those 3 things, a Widget is the easiest to make and it does not require any programming skills. In its most simple form it can be used as an embedded browser windows that you can use in your app. Read more about the Dev Tool here. There are a lot of material about Dev Hub on the web - just google it.

AirTable, is a kind of a mix between a spreadsheet application and a database, but it is completely in the cloud. And for reasonably sized amounts of data/data traffic, it is free to use. With AirTable you easily create a cloud based database, with multiple tables and fields. You can even do that on their app, with your phone!

To use Airtable, you must create a login on their site. This is free and with this you can create as many databases and tables as you like. Their business model is based on transaction and storage quantity.

What is also great with airtable is their API. I will not use the API very much in this example, to keep my solition simple, but if you know a little bit about HTML and JavaScript, there is so much more than this you can use AirTable for!

In Part 2 of this blog post I go into detail on how to do this, step by step.