4 Replies Latest reply on Jul 27, 2017 4:47 PM by sam.gedert

    Copy Text to a different table and merge text.


      Greets FM Community.  Long time listener, first-time caller....


      I am using CloudMail from 360 works for bulk e-mail management.  To make it more user-friendly for clients I am building an HTML compiler.  I am using the text to HTML custom function from Monkey Bread and a series of other scripts to create the necessary tags for images, tables etc.


      To minimize the number of fields I have to create as well as simplify the overall organization, I want to create all the HTML in a series of records in one table (HTML) and append that HTML text into a single field in another table (CAMPAIGNS) for distribution via CloudMail.


      Because I need the actual HTML as text a merge field won't work. Additionally, and to further complicate matters, I want to keep the script or other method pretty lightweight because I'm compiling it "on the fly" so users can see  changes / updates as the make them.


      Any thoughts, questions or suggestions?


      In gratitude,