Kuroshi Posted February 28, 2021 Report Share Posted February 28, 2021 Hi, I want to concatenate my records every insert if the Section and Group is the same. Please refer to the sample below: Section Group Name Combined First A 1_testname 1_testname, 2_testname, First A 2_testname 1_testname, 2_testname, Second B 3_testname 3_testname Since the first two record has same section and group, I want to concatenate their name in the 'Combined' field. How to achieve that? Quote Link to comment Share on other sites More sharing options...
0 Barbie Posted February 28, 2021 Report Share Posted February 28, 2021 Hi Batchini, I believe this can be done using triggered action. here's my sample Trigger similar to what you're trying to achieve: I hope this helps. - barbie Quote Link to comment Share on other sites More sharing options...
0 Barbie Posted February 28, 2021 Report Share Posted February 28, 2021 In addition to my last response, you may want to go over these article for more info: https://howto.caspio.com/tables-and-views/triggered-actions/ https://www.caspio.com/webinars/introduction-to-triggered-actions/ Quote Link to comment Share on other sites More sharing options...
Question
Kuroshi
Hi, I want to concatenate my records every insert if the Section and Group is the same. Please refer to the sample below:
Since the first two record has same section and group, I want to concatenate their name in the 'Combined' field.
How to achieve that?
Link to comment
Share on other sites
2 answers 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.