I am struggling with something probably basic.
I have a data form (Opp) with drop-downs looking up other tables (Product & Pack). They are joined by their respective ids and that works smoothly.
I am trying to get the ${opp.name} to be constructed out of Product looked-up name + "_" + Pack looked-up name. The trigger for the ${opp.name} construction is the dropdown change event.
Some of the fields like Products and Packs are lookups to a Product table and a Pack table. In the Opps table, products and packs are referenced by the IDs of the corresponding tables which are loaded as part of the LoadPage of the Opps data form.
I would like to generate (or change) the name of the opportunity automatically (currently testName) every time there is a change event in the Product or in the Page dropdown so that the name looks like ProductName_PackName. In the example above, it would be Dior Show_Mascara.