Melwyn

Hi @abdul, are you still working on this node.js API? Cheers Melwyn

Hi @Vitalikssssss, Thank you so much for your message! Unfortunately in your trigger, with the concatenate function, you only retrieve one value that you concatenate to another one value. If you remove the TOP statement, it will fail. Thanks for the JS idea. I'm trying to insert in another table the concatenated result. Which means, with the JS solution, I would have to: - create a data page with a form - this form would have received the concatenated string from previous data page - autosubmit the form This is a lot of work And more seriou

I've found an SQL query similar to what I'd like to accomplish (original post): SELECT Column1, group_concat(Column2) FROM Table GROUP BY Column1 Do you think I can do this in Caspio? Thanks

Dear Community, I have an issue with the Trigger Actions feature: I have one Text field, that I want to populate with the result of a query. On image_1, you can see that I'm trying to say: invoice_leader_number = "result of a query" (Just to let you know, the "invoice_leader_number" is a TEXT). Now you can see that this does not work because "2116: Only one value is expected" (cf. image_2). I've tried a work around by trying to use other functions to kind of transform the result of my query into a "one value" result, but none o