Jump to content


Caspio Guru
  • Content Count

  • Joined

  • Last visited

  • Days Won


CoopperBackpack last won the day on April 16

CoopperBackpack had the most liked content!


About CoopperBackpack

  • Rank
    Advanced Member

Recent Profile Visitors

372 profile views
  1. Hello @Iaron7, I am afraid that that there is no ready function in SQL to calculate the greatest common divisor. The solution requires using the loop. So, it looks like this is not possible to calculate the GCD in the Calculated Field. You may find supported function in this article https://howto.caspio.com/function-reference/ As an option, it is possible to make this calculation by the Triggered Actions. The example of the table design: Triggered Action: The output: You may learn more about Triggered Actions in this article if needed https://
  2. Hello @Benades, This information is helpful. As I understand now, you need to insert new records (not to update the existing) to the user_history table every time the new record is inserted to the trading_results table. Let`s say I have the following user_info table: And insert data to the trading_results table: growth - 100, date - 04/15/2021 I receive the following result: The Trigger design: Not sure that this is the result that you are looking for. And if it is the case, maybe some can provide you with more elegant solution
  3. Hello @Benades, If I understand correctly, the user_history is initially empty. And you need to add there the data that is inserted to the trading_results table. And tables are linked with user_id like this: If all above is correct, you may try to build the following Triggered Action: The idea is to create a trigger on the trading_results table that is running on the Insert action. You need to have Inner Join for #inserted table and the user_info table on user_id to check the the user status. And insert the values from #inserted table to the user_histor
  4. Hello @Stepford, You may select one of the two approaches: 1) Change the alignment in the Styles section. In this case, the changes will be applied to all DataPages that use this Style. Please open the Source tab -> All -> find the cbResultSetTableCellNumberDate CSS class using Ctrl-F (or Command-F for Mac) -> change the text-align to right. 2) You may apply the changes to the particular DataPage without changing the Style. To do this you may add Header/Footer elements on the Configure Results Page Fields page and paste the code to the Header.
  5. Hello @virtualHITman, I am glad if my previous reply is helpful. I am afraid that at the moment it is not possible to adjust the width of the columns for PDF file. It`s possible to adjust the Orientation, Page size, and Margins. These options affect the resulting file.
  6. Hello @sfraden, As I understood from you reply and screenshot, you are referring to the Details DataPage. In this case Virtual field that is set to the Calculated value has the following view: Please note that the so-called unique suffix is added to the field id (highlighted on the screenshot). This suffix is dynamic. You may find some information about it in this article https://howto.caspio.com/datapages/ajax-loading/ To get the value from the input please use the selector like this: document.querySelector('input[id^="cbParamVirtual11"]') Hope this helps.
  7. Hello @sfraden, Please try this code: <script> if(document.getElementById("cbParamVirtual11").value == "" ) { window.location.href = 'your URL'; } </script> If it doesn`t work, please specify the DataPage type and the what are trying to achieve.
  8. Hello @Gabrielle, Please note that this dropdown shows the tables that have a unique field. The Authentication can be created using the table with the unique field since it`s required to define the specific user. For example, in this table the email field is set to unique: Feel free to update this thread in case of additional questions.
  9. Hello @Johan, This depends on your Trigger design. I have the following idea (not sure whether it work for you). 1) Let`s say I have a table with several fields (the example is on the screenshot). I`ve add the checkbox_field to the table. 2) I included the checkbox_field to the last Single Record Update DataPage and set it as Hidden -> On load, receive "Yes". 3) And let`s say I want to insert the data to another table on the Update action. The Trigger will run only when the checkbox_field is checked. The condition in the WHERE clause.
  10. Hello @virtualHITman, I had the same issue in my PDF report and fixed it by changing the Header Height value. It is applies to the Footer as well. You may click the Preview button to check if the height you set is enough to not overlap the content of the DataPage or not. Hope this helps.
  11. Hello @Bluedog, As far as I know, this option is still available in the legacy plans and removed in new plans. So, I think, it is a good idea to contact your Account Manager to discuss if it is possible to enable this feature for your account.
  12. Hello @jeffs88keys, It looks like the solution depends on the exact DataPage type. Could you let me know if this is a Tabular Report DataPage or Details DataPage? Do you need to display the statement in each record if this is a Tabular Report DataPage like this? If so, please double-check the condition, since I am afraid it your question it is "when [field1] is blank or if [field2] is blank" for both cases. Also, specify the the data type for [field1], for [field2] it is File data type as I understand.
  13. Hello @Eugene, Since Caspio uses the Highcharts library to render Chart DataPages, I have checked the Highcharts documentation https://api.highcharts.com/highcharts/ I was able to find the solution that allows to add spaces between slices for the usual Pie Chart (not 3D Pie Chart). You may paste this code to the Footer section on the "Chart Wizard - Configure Chart Options" screen of your DataPage. Do not forget to disable the HTML editor on the Advanced tab before pasting the code. I put the borderWidth as 3, please use the value that you need. < scri
  14. @jeffs88keys, As for the parameters, there are 2 ways to pass them: 1) Passing Parameters through Caspio Bridge https://howto.caspio.com/parameters/passing-parameters/ It is more secure, however, this method requires enabled browser cookies for the end-user. 2) Parameters as Query String Values https://howto.caspio.com/parameters/parameters-as-query-string-values/ Since data in the query strings is visible in the end-user’s address bar it is less secure but doesn`t depend on end-user browser settings. For example, if you want to pass a parameter as a query string value, yo
  15. Hello @jeffs88keys, You are correct, please add the HTML block to add the custom button. Since you need a link that looks like a button you may use the following approach: 1) Add the HTML block on the "Configure Details Page Fields" screen, disable the HTML editor on the Advanced tab and paste the code for the link. Replace the URL inside the href attribute with the URL of your Submission form. Add some CSS class for this link. It is class="btn" in this example. <a href="https://111111.caspio.com/dp/AppKey" class="btn">Add a new Record</a> 2) Add Header/Foot
  • Create New...