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.
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
STWAdmin
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!
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.