I have an input field where a user can copy/paste Shipment ID's and click the 'Search' button to query the data on ShipmentID. However, if the user searches for a Shipment ID that does not exist, nothing happens. Instead, I would like a macro to run when the 'Search' action is executed that will open a message box telling you if one or more ShipmentIDs from the input box were not found in the field. Is this possible?
I have included an example file so that this question will make more sense. Thank you for the help.
As an added challenge for you QlikView wizards, it would be ideal if the Message Box would say "The following ShipmentIDs were not found:" and then list the entered values not found in the field.
That's further than I got on this. I would still love to have it show which values were not found, but I don't know where to begin on that... Thanks for your help, Marco.