Newbies KenR Posted July 21, 2022 Newbies Share Posted July 21, 2022 Hello Loving FM, but very limited skills. I want my drop down value list just to show my OPEN orders. I've created value list, and can see all orders. I have a field in the Orders file with OPEN / Closed status. How do I limit the items in value list = OPEN orders. thanks ken Link to comment Share on other sites More sharing options...
Ocean West Posted July 21, 2022 Share Posted July 21, 2022 Typically what I do is create a calculated field in the orders table, isOpen: Case( orders::status = "open" ; Order::Number ) Then based your value list on the isOpen field it will only display OrderNumbers that are open. Link to comment Share on other sites More sharing options...
Newbies KenR Posted July 21, 2022 Author Newbies Share Posted July 21, 2022 thank you Ocean, I'll dive into this soon as I'm home... Link to comment Share on other sites More sharing options...
bcooney Posted July 22, 2022 Share Posted July 22, 2022 I’m curious, in what scenario are you selecting open orders? Are you relating an open order to another entity? I ask this because you may very well actually need to use Find mode. Also, picking a record is often accomplished using a card window that shows a list of records. That list can be pre-filtered (such as only open orders for customerA in 2022). please describe the use case. Link to comment Share on other sites More sharing options...
Newbies KenR Posted July 22, 2022 Author Newbies Share Posted July 22, 2022 I am relating selected Open orders to my shipping plan. I want to manually select the Order that I plan to ship, and build up a list of orders that will be included in the same shipment (from factory to our warehouse) My present value list works ok, but it shows ALL of my POs (obviously then including all that have already been shipped, and those still in production and not yet ready to ship) So yes, i just want to see open orders in my filter list. The PO table has a field call Open, which has the word "OPEN" loaded. thanks for asking Link to comment Share on other sites More sharing options...
Newbies KenR Posted July 22, 2022 Author Newbies Share Posted July 22, 2022 My current value list is set to .....'use values from field' Link to comment Share on other sites More sharing options...
bcooney Posted July 23, 2022 Share Posted July 23, 2022 Here’s how I’d go about it: user clicks button, add order to shipment. card opens showing all orders that are not already on a shipment that are in “ready to ship” status. (This is done using a find after the card is shown in the show open orders script). user selects 1+ orders on clicking done in card, each selected order’s shipmentId is set. Order status is possibly updated to “pending shipment”. edit: this assumes an order is not split across shipments. Link to comment Share on other sites More sharing options...
Newbies KenR Posted July 23, 2022 Author Newbies Share Posted July 23, 2022 awesome thanks .... will get armed with a coffee and see if I can manage Link to comment Share on other sites More sharing options...
bcooney Posted July 23, 2022 Share Posted July 23, 2022 Do you split orders across shipments? Your data model structure can change. You might need shipment line related to order line. That would be the most complex. if I have time, I’ll out together a demo. You might benefit from my recent blog post on how I do picker windows. https://www.proofgeist.com/blog/2022/06/24/building-a-modular-picker-with-an-ontimer-script Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 614 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now