How to Show Data from a spreadsheet in an appsheet form.

AppSheet AppSheet Q&A
, ,
1

Hi everyone,

We own a chain of ice cream shops, and I am putting together an app to make it easier for staff to order and keep track of inventory.

I need to display the stock level (a column of my spreadsheet) of the chosen ice cream on a form, but I can’t figure out how to do it.

Here are screenshots of appsheet and data:

Screenshot 2024-08-20 at 18.28.12 (2).png
Screenshot 2024-08-20 at 18.28.12 (2).png1920×1080 208 KB

Screenshot 2024-08-20 at 18.28.17 (2).png
Screenshot 2024-08-20 at 18.28.17 (2).png1920×1080 205 KB

Screenshot 2024-08-20 at 18.28.36 (2).png
Screenshot 2024-08-20 at 18.28.36 (2).png1920×1080 240 KB

Screenshot 2024-08-20 at 18.33.06 (2).png
Screenshot 2024-08-20 at 18.33.06 (2).png1920×1080 638 KB

Screenshot 2024-08-20 at 18.33.20 2.png
Screenshot 2024-08-20 at 18.33.20 2.png1920×1080 270 KB

Thank you!

2

Try setting [Item ID].[Stock Level] in the App Formula. Make sure the type is correct (I believe number is the right type?)