We're setting up your new app...

Sample app

INDEX Position Finder

Sample App to demonstrate how to find the INDEX() position of an item from a list

Industry: n/a
The purpose of this app is to demonstrate how you can find the INDEX() position of an item from a list; but also to demonstrate other helpful tools and techniques for working with lists in AppSheet. ----- If you're working with lists in AppSheet (which I guarentee you you will), then eventually you may run into a scenario where you need to know in what position an item sits in a list. - Is it at the front? The back? What number does it sit in the middle? 5? 25? This app will show you how to find such things.

How we built this app

This app features three tables: - Onboarding (for a simple intro page) - Products (for some reference data to work with) - Index_Finder ----------------------------------- Index_Finder is where the real demonstrations are. In that table you'll find demonstrations about how to: - Pull the first/last item from a list - Count how many items are in a list - Find the INDEX() position of a text item (selected from an Enum) - Find the position of a Price item (which, like Number or Decimal types, require a conversion of type before we can work with it) - How to find the position of a manually entered value - How to show a conditional statement informing the user that the value they entered isn't inside the list
This is a preview of the data sets used in the app.


This is a high-level model of both the data entities and the UI elements in the app.
Start for free