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

[DavidCain]

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:

     

  Thank you!

[TeeSee1]

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