Jump to content


Caspio Evangelist
  • Content Count

  • Joined

  • Last visited

  • Days Won


Everything posted by Vitalikssssss

  1. 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:
  2. 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
  3. 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.
  4. Hi @Lamin, Please make sure you disable HTML editor before pasting a code snippet. Regards, vitalikssssss
  5. 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
  6. Hi @Inovix, Perhaps this topic will help. Regards, Vitalikssssss
  7. 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
  8. 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
  9. 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
  10. Hi @vanderLeest You may consider using Formula field for this case. Here is something similar explained: Regards, vitalikssssss
  11. 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
  12. 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.
  13. Hi @Tonie, There is not need to specify the character which you would like to encoded in the code. I assumed that you have a Tabular Report Datapage and created a code based on the link you have provided: <a href="#" id="link-[@cbRecordIndex#]">[@calcfield:1#]</a> <script> // DO NOT TOUCH FROM THIS POINT var params = []; addParameter = function(qs, val){ params.push(`${qs}=${encodeURIComponent(val)}`); } //UP TO THIS POINT var link_id = "link-[@cbRecordIndex#]"; var base_url = "[@app:URL_2]"; addParameter('cid', '[@field:ID]'); addParameter('fn', '[@field:
  14. Hi @CMorris, Values from virtual fields do not have a datatype. You would need to wrap the fields reference with single quotes to make them string type and convert the string to float type. You can use T-SQL function CAST or CONVERT for this. So, your expression will look like this: CASE WHEN '[@cbParamVirtual2]' = 'mm' THEN CAST('[@cbParamVirtual1]' AS FLOAT)/25.4 ELSE CAST('[@cbParamVirtual1]' AS FLOAT) END Regards, vitalikssssss
  15. Hi @roattw, I know it is possible to convert Single Record Update Datapage to Details Datapage, so it could preserve the settings. I think it would not be possible with Submission Form and Single Record form since they have different structures. Regards, Vitalikssssss
  16. @gregbovenkerk, you should consider Calculated value with SQL expression if you would like to show the result on a form (Submission/Details). This features explained in this articles: https://howto.caspio.com/datapages/datapage-components/calculated-values/ https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/ Regards, vitalikssssss
  17. Hi @ivan77 Here is one of the old tutorials. Caspio UI has changed slightly since this video but the concept stays the same.
  18. Hi @Christo, When do you receive this error? It might be related to Timeout redirection to an invalid address. Check advanced settings of your Caspio Authentication and change it to "Same page". Send us a link to your web-page if the issue still persist. Regards, vitalikssssss
  19. Hi @rjvelarde, I think the easiest way to achieve is by using Formula field in the table with CASE expression. e.g. CASE WHEN [@YOUR_FIELD] = 'Follow up' THEN '<span style="color:#ffff00;">'+[@YOUR_FIELD]+'</span>' WHEN [@YOUR_FIELD] = 'Irrigation System' THEN '<span style="color:#0066ff;">'+[@YOUR_FIELD]+'</span>' WHEN [@YOUR_FIELD] = 'New Well' THEN '<span style="color:#009933;">'+[@YOUR_FIELD]+'</span>' ELSE 'Not defined' END Finally, you can render the content of the formula output as HTML if you enable the HTML option in Formatti
  20. It looks like you have selected a Search from instead of Predefined parameters as explained in the video tutorial. You will find the detailed answer in the video tutorial I have sent you above. Regards, vitalikssssss
  21. Hello @ryancys, You may check the following tutorial video for more information related to the deployment of two Datapages in one web-page:
  22. Hi @gregbovenkerk, What Datapage type do you use? It is possible to add Total & Aggregation field on Tabular report in order to get count of records. You can check this article: https://howto.caspio.com/datapages/reports/advanced-reporting/totals-and-aggregations/ Hope this helps. Regards, Vitalikssssss
  23. Hi @ryancys, You would need to use separate from the the search which will be based on Submission Form. You may use Virtual fields for this Submission Form. Virtual fields can pass parameters to the report to filter the data. Also, you would need to embed both Submission Form and Report on single web-page. The concept described in this article: https://howto.caspio.com/tech-tips-and-articles/tech-parameters/add-a-search-interface-to-results-sets-page/ Calculated Value datatype is available on Submission Form and Single Record Update Form. Hope this helps. Re
  24. Hi @Bleman What type of cards you would like to process? With Stripe, you can charge almost any kind of credit or debit card: U.S. businesses can accept Visa, MasterCard, American Express, JCB, Discover, and Diners Club. Australian, Canadian, European, and Japanese businesses can accept Visa, MasterCard, and American Express. Regards, vitalikssssss
  25. Hi @GusAlford, I believe that you can find an answer in this post: Regards, vitaliksssss
  • Create New...