I have created a smartcapture form in a cluoudpage which includes a picklist field that contains a set of values (e.g. product names).
From the moment the user submits the form, I need to store in the target data extension the product name (this is done OOTB) and the product code related to the value selected in the picklist.
For the product code. it is stored in a different data extension that includes the relation between the product name and the code, so I just need to find a way to populate the corresponding product code in the target data extension from the moment the form is submitted. Could it be achieved by using AMPScript or in a different way?