Open as App not only allows you to add a list from the excel via the App Designer, it also allows you to customize the list based on some conditions in the excel.
In this tutorial, we will learn how to make the list's contents show or hide using isvisiblecolumn syntax.
DATA SOURCE PREPARATION
The app creation already starts in your Excel spreadsheet. The cleaner the columns and cells are formatted there, the easier you will turn this file into an app.
In this sample excel file, there is a list of columns, Name, Price. The third column contains TRUE or FALSE values which help in the visibility of the list contents in the app.
SELECT DATA SOURCE
In the "Choose your data source" step, Select the file from your PC by clicking on ‘Choose file’ button.
After uploading the excel file in the platform, you will be automatically redirected to the next step in the app creation process.
After creating the app with a list as shown in the screenshot, to show or hide the list contents
- Click on the list element,
- In the Advanced tab, under Raw Definitions add isvisiblecolumn in the Add key area and 3 (third column in the excel file) in the Add value area,
- Click + icon and Save the app.
When you check the app in a mobile, the list contents are shown for which the values were TRUE as shown in the screenshot below.
This feature will be really helpful when the app creator wants to show or hide the list contents based on logged in user, based on checkbox selected (refer the example), and if the user wants to make changes in the excel file without making any changes in the app.
An example app using isvisblecolumn syntax:
This feature works only in the mobile version and currently not supported in the WebClient version.