Jump to content


Caspio Guru
  • Content Count

  • Joined

  • Last visited

  • Days Won


Everything posted by CoopperBackpack

  1. Hi, Wanted to add the solution about how to add the UpperCase() function to the particular field/fields on the Submission form. You may add the code to the Footer section of the DataPage (do not forget to disable the HTML editor before pasting): < script > document.addEventListener('DataPageReady', upperCaseHandler); const ids = '#InsertRecordFieldOneName, #InsertRecordFieldTwoName, #InsertRecordFieldThreeName'; //replace with your local field names function upperCaseHandler() { document.querySelectorAll(ids).forEach(element => element.addEventListener('change', (eve
  2. Hello @rhinger, As far as I understand this is a Submission Form DataPage ,CASE statement returns correct value and you need to fix only the JavaScript code. 1) Please use the BeforeFormSubmit Caspio event handler. 2) If you set the "LastFourCheck" field as a Calculated Value Form Element as shown on the screenshot then this input field on the Submission form has id that starts from InsertRecord prefix and has dynamic so-called uniqueSuffix. Here is the example: To get the value of this input field, please use the syntax: document.querySelector("input[
  3. Hello @al3sha, I tested the similar statement in my account and the formula is valid. So, it is possible to use this kind of statements in Calculated value field. 1) Please use the GROUP BY clause before the ORDER BY clause. 2) Please note that you need to include in the GROUP BY clause all non-aggregated fields that you added to the SELECT statement. In this example you do not use aggregate functions, so all 3 fields should be included in the GROUP BY clause. 3) In this case you need to add the fields to the ORDER BY clause that are contained in either an aggregate functi
  4. Hello @wimtracking2, As I understood from your inquiry, you store the cities in the field with the Text(255) data type and set this field on the Search page as Listbox -> Allow multiselection And the Search is set like this: If this is the case, it is possible to add the "selected" attribute to the options you want by JavaScript. I added this code to the Footer section on the "Search and Report Wizard - Configure Search Fields" page (the HTML editor is disabled on the Advanced tab before pasting). <script> document.addEventListener('D
  5. Hello @KellanCarson, Please try to set the width in the Styles -> Form/Details -> Layout -> Data Cells -> Cell Width. Regards,
  6. Hello @jeffs88keys, Could you confirm that you want to check the values of 2 fields (text and file) on the Details DataPage and these fields are set as "Display only" form elements? If Text OR File fields are empty, then show the disclaimer like this: Otherwise, show the disclaimer like this:
  7. Hello @Hiperf, The issue can be connected to the exact field name. As far as I understand, the formula is in the Calculated Value field is valid. This means that the field name is PropertyActive (not _PropertyActive). In this case you need to reference the field as EditRecordPropertyActive (without underscore before the field name). I used underscore because it was in the initial script. You may learn more in this post https://forums.caspio.com/topic/4377-js-guide-caspio-form-elements/ Please test the code with this small correction. I tested this solution in my account an
  8. Hello @Hiperf, I would like to add that you need to compare the Yes/No field values with 1 or 0, not with 'Y'/'N'. If this is the Submission form, you may add Virtual field -> set to the Calculated value with formula: SELECT Property1978 FROM tblProperty WHERE PropertyID = target.[@field:SMNPropertyID] In the second Virtual field use the formula: CASE WHEN [@cbParamVirtual1] = 1 THEN 'h.html' ELSE 'i.html' END And add this virtual field 2 as a destination after record submit. Maybe this article is helpful https://howto.caspio.com/tech-tips-a
  9. Hello @Hiperf, It looks like the issue is related to the Hidden element. If you set the Yes/No field as Hidden Form Element it stores no value by default. For example: As a result, with these settings each time the DataPage is submitted, the value in the Yes/No field is updated with the "No" value. It is possible to assign the "Yes" value on load. But with these settings each time the DataPage is submitted, the value in the Yes/No field is updated with the "Yes" value. To solve this, please try another approach: set the Yes/No field as a Calculated
  10. 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://
  11. 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
  12. 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
  13. 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.
  14. 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.
  15. 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.
  16. 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.
  17. 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.
  18. 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.
  19. 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.
  20. 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.
  21. 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.
  22. 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
  23. @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
  24. 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
  25. Hello again @awolagain, 1) If you are referring to the demo application in your account as shown on the screenshot below, this demo is attached by default to showcase the application in Caspio account, etc. You may even delete it. This is up to you. 2) If you are asking about Trial and Free accounts, these are two different plans. As far as I know the Trial account is valid for 14 days and has features that are similar to the paid Grow plan. So each user of the Trial account can review most of the available features. Free account is limited in features, but not
  • Create New...