AnsweredAssumed Answered

Pulling Search Criteria from a Field

Question asked by melcam on Nov 7, 2014
Latest reply on Nov 10, 2014 by user19752

In my solution each record has a unique long SKU (ie 14AAAMBNOV72014) which contains one of 80 possible short SKUS (in this case AAAMB). I need to create a new field and label each record with its correct short SKU. Since there are over 80 short SKUs and the possibility that new ones will be created, I do not want to program the script to manually search for each one. Is it possible to write a script that will pull search criteria from another table with a field of SKUs? So that script first searches for all records containing "AAAMB" in the product table, labeling all found records with the short SKU, and repeating for each record on the SKU List, going through all the records until it runs out and then stops?

 

Thanks!

Outcomes