Elderberg Posted December 13, 2019 Report Share Posted December 13, 2019 I'm wondering if its possible to run an SQL Select Statement within footer instead of as a calculated field. Quote Link to comment Share on other sites More sharing options...
Meekeee Posted December 20, 2019 Report Share Posted December 20, 2019 Hi @Elderberg, For Header and Footer, you could only use HTML or JavaScript code. Reference: https://howto.caspio.com/datapages/datapage-components/datapage-header-and-footer/ SQL Select Stataments are functions that you could only use Calculated Field and Value. Reference: https://howto.caspio.com/function-reference/ I hope it helps! Quote Link to comment Share on other sites More sharing options...
Johan Posted February 27, 2021 Report Share Posted February 27, 2021 Meekeee, I want to set up a SQL statement to update an external table with information from the current record such as INSERT INTO ... VALUES... Is this possible ? And how/where should I do this ? Quote Link to comment Share on other sites More sharing options...
Barbie Posted February 28, 2021 Report Share Posted February 28, 2021 Hi Johan, I believe this can easily achieve using Triggered/Task. You may refer to this article for more information: https://howto.caspio.com/tasks/ https://howto.caspio.com/tables-and-views/triggered-actions/ - Barbie Quote Link to comment Share on other sites More sharing options...
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.