I am trying to create a inventory management app. Within the app I need it to be set to ask fill in the blank questions. For Example: Say the inventory item is an apple, if you go to take away from the inventory, it should ask A: How many are you taking/entering? B: Who is taking the apple? C: Where is the apple coming from? D: Where is the apple going? Once the data is entered I need it to automatically populate in a google sheet so that we can see the total inventory of an item, apples in this case.I am VERY new to this software, so any help that I can get would be great!
Thank You!