Jump to content


Caspio Evangelist
  • Content Count

  • Joined

  • Last visited

  • Days Won


Everything posted by Vitalikssssss

  1. Hi @Vincent, Your data needs to reside in Caspio tables in order to work with it via Datapages. You may check this article which explains how you can import your date: https://howto.caspio.com/tables-and-views/importing-data/ You may also consider using REST API for transferring the data from you database into Caspio: https://howto.caspio.com/web-services-api/rest-api/ Hope this helps. Regards, vitalikssssss
  2. Hi @Elderberg, You may add underscore after the field name if you would like to reference Virtual field #2^ document.querySelector('[id*=cbParamVirtual2_]'); Regards, vitalikssssss
  3. Hi @Talmax, Here is some information which should help: 1. You may use the following syntax to receive the parameter in custom elements such as <div> located in Datapage: [@PARAMETER_NAME] 2. You may use timeout redirection settings if you have authentication enabled. 3. Make sure that you pass the parameter which identifies the record which will be shown. e.g. if you try to open below Datapage you would need to pass parameter with a name Record_ID and it should look like the following. https://xxxxxxx.caspio.com/dp/xxxxxxx273ac9f6ff0a41199812?Record_ID
  4. Hi @NickO, It looks like it possible only with Collapsible group --> Collapsed by default settings enabled: You may use the following JS if you have the same type in your Datapage: <script type="text/javascript"> document.addEventListener('DataPageReady', hideRows); function hideRows () { document.querySelectorAll("td[class*='cbResultSetGroup1LabelCellNumberDate']").forEach(function (el) { if (el.innerHTML < 1000) { //replace this value with the one which you would like to set as target el.parentNode.style.display = 'none'; }
  5. Hi @cdutoit62, Please specify what form element do you use for the field "Odometer reading of previous refill". It looks like a Cascading dropdown but it is better to be sure. Regards, vitalikssssss
  6. Hi @NickO, I think you need to simply combine the condition for assigning 'Primary' value with OR logic operator. Perhaps you should try the following expression: CASE WHEN [@calcfield:3] = 2 OR [@calcfield:4] = 2 OR [@calcfield:5] = 2 OR [@calcfield:6] = 2 OR [@calcfield:7] = 2 OR [@calcfield:8] = 2 OR [@calcfield:9] = 2 OR [@calcfield:10] = 2 OR [@calcfield:11] = 2 OR [@calcfield:12] = 2 OR [@calcfield:13] = 2 OR [@calcfield:14] = 2 OR [@calcfield:15] = 2 OR [@calcfield:16] = 2 OR [@calcfield:17] = 2 THEN 'PRIMARY' ELSE 'NOT' END
  7. Hi @JDEV101, I doubt that it would be possible to replicate the same type of filtering but you can get close to it. You may look into creating a separate form based on Submission form with Virtual fields which will act as a Search Form by passing parameters to the Report. This concept explained in this tutorial video: https://www.youtube.com/watch?v=K3CKFjuSIt4 You may make you Submission form interactive by using Rules: https://www.youtube.com/watch?v=K3CKFjuSIt4 Hope this helps. Regards, vitalikssssss
  8. Hi @streetsmart, Make sure that you have disabled AJAX loading because this solution quite old and do not support AJAX. Regards, vitalikssssss
  9. Hi @Empbusk, The requested part is actually covered in the following tutorial video. You would need to use a Details Datapage along with calculated field in order get the count of number of records. Also, some HTML/CSS will be required to apply box styling of the element. Hope this helps.
  10. Hi @DesiLogi, Perhaps you can use CSS instead of JS to hide the Datapage. Try putting this code in DP Header: <style> #caspioform { display: none; } </style>
  11. Hi @Lamin, I think you a referring to Wordpress.com which actually do not support 3rd party Javascript codes. I can recommend using Wordpress.org, Weebly, Yola CMS for deployment of Caspio Datapages. Regards, vitalikssssss
  12. Hi @DonateGood, You can use Triggered Action feature in order to create this type of functionality. 1. You need to add new field based on which Triggered Action executes. 2. Create a Triggered action which will fire on update event. Note: You will need to use two blocks. First block "Insert" going to copy the record if the checkbox is checked and the second one "Update" will uncheck the box after copy has been made. Please note that you will need to click on "Refresh" button in order to see new records which has been copied. Hope this helps.
  13. Hi @jeffd2652, Date&Time stored in Caspio table always use a US formatting and there is no way to change this setting. You can use Localization in order to change the format how it appears in Datapages. Regards, vitalikssssss
  14. Hi @kenni11, It is doable in Caspio. You need to use a Submission Form type of Datapage along with Calculated value form element. Here is a video which covers above features of Caspio:
  15. Vitalikssssss


    Hi @DruidCtba, Indeed, Free account do not have access to features like Triggered Actions or Calculated value. You may use Formula field with CASE logic in table level. Formula fields available in Free account. https://howto.caspio.com/tables-and-views/data-types/formula-fields/ Your CASE expression can look like this. CASE WHEN [@FIELD_A] = '' THEN [@FIELD_B] ELSE [@FIELD_A] END Hope this helps. Regards, Vitalikssssss
  16. Hi @ababcock, I think the issue caused by the invalid way how you try to reference the Update button. document.getElementById('Mod0EditRecord').onmouseover = ... Caspio has recently introduced some changes in the way how ID of the element is generated. Unique postfix has been added to each element of a Datapage. You can use CSS selectors to get the element by partial name e.g. document.querySelector("input[id^='Mod0EditRecord']") or by using class to refer to the Update button e.g. document.getElementsByClassName('cbUpdateButton')[0]; Hope this helps.
  17. Hi @Lamin, Please make sure you disable HTML editor before pasting a code snippet. Regards, vitalikssssss
  18. Vitalikssssss


    Hi @DruidCtba, In regards to your questions: 1. Datapage and columns width adjusted automatically in order to fill out the container where it is embedded and to fit content of columns. You can define the width of the columns as explained in this article: https://howto.caspio.com/datapages/datapage-components/field-configuration-options/field-and-column-width/ Quite often this setting gets overwritten if Datapage do not fit the container. You can define width of the Datapage (container) as explained in this article: https://howto.caspio.com/styles/fix-the-width-of-the-d
  19. Hi @Inovix, Perhaps this topic will help. Regards, Vitalikssssss
  20. Hi @Roosta, I have run into the same issue over the year ago. You may use desktop app such GreenShot which has an option to upload screenshot to the external hosting. You can copy URL of the image and past inside your posts in Community Forum with this option in the editor. Regards, vitalikssssss
  21. Hi @vanderLeest, Please make sure that you use the expression in Formula field, since Calculated field/Calculated value do not support HTML output. Also, you need to tweak your expression because concatenation with "+" available only for string type. Also both logic block should return same datatype. CASE WHEN [@field:MS_InvAmount] > [@field:MS_Budget] THEN '<span style="color:#ffff00;">'+CAST([@field:MS_InvAmount] AS nvarchar)+'</span>' ELSE CAST([@field:MS_InvAmount] as nvarchar) END Hope this helps. Regards, vitalikssssss
  22. Hi @Ras2019, I assume that you have an element with fixed width which do not fit the container in mobile view. It would be easier to provide more specific suggestion if you share a link to this page. Regards, Vitalikssssss
  23. Hi @vanderLeest You may consider using Formula field for this case. Here is something similar explained: Regards, vitalikssssss
  24. Hi @mgredmond, You can add your actual field into submission form and use Calculated value form element to reference the result of Virtual field. Advanced Calculated value settings allows you to hide field. The formula expression will need to have a CASE logic block because Calculated value works with "Value" section of dropdown. It might look like this: Hope it helps. Regards, Vitalikssssss
  25. Caspio Bridge 21.0 release brought a Tasks\Trigger enhancement which solve this case without complex Trigger\Tasks. There is a new block added to Triggered Action called "Table variable" which forms a table. You can insert table variable into email body and it will be formed link a table (HTML format enabled): Hope it helps someone.
  • Create New...