Hello,
I’m new all this and i’m trying to add a filter to where the inventory app I’m trying to create only display things in a one-by-one flow. But I can’t seem to find the Filter option under the Data tab or the “fx”. Did it happen to move? Below is process list I was provided:
Add a filter to show one item at a time:
- Click “Add Filter.”
- Field: “Item Order” (from Count Item).
- Condition: “is” (equals).
- Value: Click the “fx” icon, select “Control” sheet, and choose “Current Item Order” (Control!A1).
- This ensures the tab only shows the item whose Item Order matches Control!A1 (starts at 1).
TIA for the help!
Those instructions make no sense. Where did you get them from?
Please add some screenshots so we can better understand what you are trying to do.
I got them from Grok…lol. I’ve attached a screenshot of the steps it told me in order to work in Glide. I’m trying to make it so where the app display’s inventory items to take a count for one-by-one.
hehe, well I’m not interested in a screenshot of what the AI told you, because that’s obviously wrong.
I want to see what you have in Glide. Show me a screen shot from the data editor, and one from the layout editor so I can see what components you are working with.
1 Like
Ah I see. I don’t have much yet, but I’ll attach it. Here’s what I’m trying to do:
Inventory App for a my parents restaurant to where the app will have input one-by-one items for them to enter the Current Count. The Control Tab is meant to keep items in Item Order set(1,2,3, etc).
Inventory is taken twice a week(Thursday and Sunday), so a Prior Count will be present. The app will calculate how much to reorder based on a Min on Hand setting. The app will also provided a suggestive ordering based on past usage calculations. After all inventory has been taken, the app will summarize what to order.
So where is it that you are wanting to apply filtering?
Why do you need this in a one-by-one flow?
I was hoping to apply it on the beginning page? So it filters to only items that need inventory count taken.
It would be much easier for my parents and their staff to do inventory one-by-one flow vs a whole page where the font/text is really small.
How i imagine the app to be was:
- Start Inventory Button
- Current Day Selected(if it’s any day other day Thursday or Sunday and error will occur)
- Inventory begins on Item # 1 in a category(ex. Milk under Dairy Products)
- Page will show Prior Count #, a field to enter Current Count, and a area that show’s Average weekly Usage with a Next Button(clicking the next button saves)
- After all Inventory that needs count is completed, press Submit and it will spit out a summary page of everything needed
