INDEX Position Finder
Sample App to demonstrate how to find the INDEX() position of an item from a list
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.
Also see: tablet mode & fullscreen mode
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.