Hi,
Just wondering, is there a neat way of applying a two-step filter? That is, first filter by a user-selected item then filter by a secondary filter?
Context: I'm creating a master inventory list of multiple items. The user must select from a list of potential items. When a new shipment arrives, but the same inventory #, I want the form to autopopulate with the previous inventory #, rather than have the user type in the text.
To pull the previous inventory #, I'm basing it on this nifty formula: lookup("List","ID",max(lookup("List","Item Child Count","0","ID",true)),"ColumnYouWantOnPreviousItem") from here.
However, I realize that it'll pull the most recent item, regardless of what the item is, which would lead to an inaccurate inventory #.
I then created a hidden calculated column on Sharepoint that merges both the Item Name together with the ID #. However, I'm stuck now as to how to modify the above formula to account for the item name.
Is there an ootb solution, or any pointers as to which direction I should go? Hoping to avoid jQuery and other javascript functionalities, as I have no knowledge.
I realized that "MediaName-ID"-1 would be inaccurate, as the ID value may not exist. Additionally, creating multiple views where only the relevant item shows would be a bit... cumbersome?
Thanks for any hints/tips!!!
