Template
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.
Loading...
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.
Data
This is a high-level model of both the data entities and the UI elements in the app.
Loading...