Thanks a lot for this input ! I will try it accordingly.
It can come handy to delete all category and related products but only if the user is 100% sure of what he is doing so I’lll design it accordingly.
Just now I encountered with other problem that is when adding items. The flow is designed so users can only add items from the MASTER ITEMS dropdown. But I encountered that you can add the same item twice, that’s no good.
I am busting my head to understand how to prevent a user to add an item that has already been added. Any ideas on this?
So on which level would they not be able to add the same item twice? You probably can design a query on the items list to check if the signed-in user has added the item or not, and filter the added items out of the choice list.
So I would have the INVENTORY table selected on that collection and it’s displayed filtered by the AIRCRAFT so adding an item in that level would add it in the INVENTORY master and create a row for that Aircraft ID
I will work around the solution you propose but don’t know if I am getting it right…Don’t know how to query the INVENTORY looking for that item
I assume it has to be some kind of query that gets all the items related to that aircraft on that table and after that an IF OR ELSE kind of action that opens a screen if confirmation matches… Let’s see if I could pull it out but I am a bit dizzy lol
Is there a way to make a column that looks up the products that ARE NOT added to an aircraft? that way, the list of items can look in it and that way there will never be a chance for a user to add twice the same item
I made a table that in 1 column it fetches ALL ITEMS, in other column it fetches ALL ITEMS IN AIRCRAFT
So if I can get to make a 3rd column that deletes the matches and just displays the remaining items, I would have ALL ITEMS THAT ARE NOT IN AIRCRAFT and that would be the way to prevent duplicates but I can’t manage to create that 3rd column
I think that would work but I am not capable of knowing the right kind of columns I should use
Hi!
I signed up to make a similar app. would you mind sharing a copy of yours?
I can help you with problems you encounter, but even if you don’t need my help - I would be glad to have a copy of existing app instead of having to figure it out from scratch
