I have a submission form where I'm building a comma-separated list of User IDs and a single Description text area.
When submitted, I want to use a Triggered Action to then break down the User ID list (or loop over it), and insert an individual User ID and the Description into another table.
Something like:
User_ID_List = XXXX,YYYY,ZZZZ
Description = (long text block)
For each User_ID in User_ID_List
DO Insert User_ID, Description into MessageTable
Where I would end up with three records inserted into the MessageTable, each with a unique User ID and duplicating the Description field.
This seems doable, but I just don't have the experience with building the Triggered Actions yet.
Any help is appreciated - thanks!