Jump to content


Caspio Evangelist
  • Content Count

  • Joined

  • Last visited

  • Days Won


Everything posted by Vitalikssssss

  1. 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 Formatting field settings: Hope this helps. Regards, Vitalikssssss
  2. 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
  3. Hello @ryancys, You may check the following tutorial video for more information related to the deployment of two Datapages in one web-page:
  4. 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
  5. 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. Regards, vitalikssssss
  6. 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
  7. Hi @GusAlford, I believe that you can find an answer in this post: Regards, vitaliksssss
  8. Hi @SDDENR, Perhaps you have the JS which throws an error on the hosting page since you have mentioned that issue can be replicated only on embed page. Try to embed the Datapage on different web-page in your CMS to check if the issues still persist. It would help if you could send us a URL of the web-page in question. Regards, Vitalikssssss
  9. Hi @galen, Please make sure that you do not do the following: - Collecting passwords on Text Fields (using label of the non-Password data type field as "Password"). - And/or have any notification/acknowledgment email that sends passwords in the body. You should contact Caspio Support if it does not help. Regards, Vitalikssssss
  10. Hi @SDDENR, Please check the browser console if there are any errors exist on a web-page where Datapage is deployed. To open the developer console window on Chrome, use the keyboard shortcut Ctrl+Shift+J (on Windows) or Ctrl+Option+J (on Mac). Do you use any CMS? Regards, vitalikssssss
  11. Hi @derek Well, you can add a Virtual field and use it in Condition. In order to get the existing value, you can may use Cascading Elements or Calculated value with SQL expression. Regards, vitalikssssss
  12. Hi @CoreyH, It is possible to create such a layout without declaring table in HTML block. I do not recommend using your approach because it will also need a cumbersome Javascript which would take a value from declared inputs and paste into Caspio inputs (fields). You can use the following feature in order to tweak the layout: 1. "No Label" for a field; 2. "Continue Next Element on the same line"; 3. HTML blocks for labels; You will be able to configure the DP like this: Hope this helps. Regards, vitalikssssss
  13. Hi @randybow, The Date&Time comparison methods is not available in View if you use the formula field as far as I understood. You need to make sure that each logic block of your CASE expression returns Date&Time datatype. Please try the following expression: CASE WHEN [@field:endDate] Is Null THEN CONVERT(Datetime, '06/01/2020', 101) ELSE CONVERT(Datetime, [@field:endDate], 101) END Hope this helps. Regards, vitalikssssss
  14. Hi @DarwinCastro I am glad that my suggestion helped. You can use the following design of task in order to check occurrences per month: Regards, vitalikssssss
  15. Hi @DarwinCastro, You can use Task feature in order to get the desired output. Here is an example of Task which will populate new table with unique record and count of them in the existing one. Hope this helps. Regards, Vitalikssssss
  16. Hi @kpcollier, Try the following JavaScript: <script type="text/javascript"> function formatAsDollars(el) { el.value = el.value.replace(/[^\d]/g,'').replace(/(\d\d?)$/,'$1').replace(/^0+/,'').replace( /\d{1,3}(?=(\d{3})+(?!\d))/g , "$&,"); el.value = el.value ? '$' + el.value : ''; } var fields = ["Subtotal", "MarkUp", "County_Tax", "Misc_Percent", "Freight_Total"]; //specify your fields here fields.forEach(element => { element = "InsertRecord" + element; // replace "InsertRecord" with "EditRecord" for Details/Single Record Update DP document.getElementById(element).onkeyup = function() { formatAsDollars(this); } document.getElementById(element).onchange= function() { formatAsDollars(this); } }); function calculate() { var subTotal = document.getElementById("InsertRecordSubtotal").value.length == 0 ? 0 : (parseFloat(document.getElementById("InsertRecordSubtotal").value.replace(/[$,]+/g,""))); var markUp = document.getElementById("InsertRecordMarkUp").value.length == 0 ? 0 : (parseFloat(document.getElementById("InsertRecordMarkUp").value.replace(/[$,]+/g,""))); var countyTax = document.getElementById("InsertRecordCounty_Tax").value.length == 0 ? 0 : (parseFloat(document.getElementById("InsertRecordCounty_Tax").value.replace(/[$,]+/g,""))); var miscPerc = document.getElementById("InsertRecordMisc_Percent").value.length == 0 ? 0 : (parseFloat(document.getElementById("InsertRecordMisc_Percent").value.replace(/[$,]+/g,""))); var freight = document.getElementById("InsertRecordFreight_Total").value.length == 0 ? 0 : (parseFloat(document.getElementById("InsertRecordFreight_Total").value.replace(/[$,]+/g,""))); var markUpTotal = document.getElementById("InsertRecordMarkUp_Total").value = (subTotal) * (markUp); var countyTaxTotal = document.getElementById("InsertRecordCountyTax_Total").value = (subTotal) * (countyTax); var miscPercTotal = document.getElementById("InsertRecordMisc_Percent_Total").value = (subTotal) * (miscPerc); var total = document.getElementById("cbParamVirtual1").value = (subTotal) + (markUpTotal) + (countyTaxTotal) + (miscPercTotal) + (freight); var dp_el = [ document.getElementById("InsertRecordMarkUp_Total"), document.getElementById("InsertRecordCountyTax_Total"), document.getElementById("InsertRecordMisc_Percent_Total"), document.getElementById("cbParamVirtual1") ]; dp_el.forEach(element => formatAsDollars(element)); } setInterval(calculate, 1500); </script> Regards, vitalikssssss
  17. Hi @norkaman Do you use the following syntax to reference first 2 parameters? [@WID] and [@LBE]? Regards, vitalikssssss
  18. Hi @walker1376, Do you use Trading_Name as a display value i.o. ID in table relationship? I assume that you trying to compare ID with display value. Please send me a screenshot of your Table relationship, so I could give more precise suggestion. Regards, vitalikssssss
  19. Hi @walkerc, You will not be able to build a View with desired output because Joins cannot be configured with OR logic. I can suggested using a filtering criteria on Datapage in order to show the records from Main_Data table to the Contractor. You should use a Main_Data as a data source for your Datapage. Also you should enable authentication which based on "Contractor_Data" table for this Datapage. Finally you can use the following filtering logic: P.S. use TradingName i.o. Record_ID from my sample. Hope this helps. Let me know if you have any questions. Regards, vitalikssssss
  20. Hi @GrahamMoore, You may consider using Weebly (my choice), Yola, WordPress (wordpress.org). Hope this helps. Regards, vitalikssssss
  21. Hi @Farnsbarnes, I am afraid that it is not possible to reference a look up value with any syntax. I can recommend creating a View to join your tables (parent child) and use this view as a datasource for the Datapage. You will be able to reference the parent field by using a parameter picker. Hope this helps. Regards, vitalikssssss
  22. Hi @SonniT, I am pretty much sure that you receive an error because you have used PK_ID field as body parameter. PK_ID is a system field which acts as a record index for Caspio Table. I am afraid that you cannot use this field in body parameters. Try removing this parameter from body to resolve the issue. Please provide us with fields Data type used in the table if you still encounter an issue after removing PK_ID. Regards, vitalikssssss
  23. Hi @EmmePGN, The following script fires the selection check after user clicks on Update button in his form: <script type="text/javascript"> var v_state = "[@field:TypesWrittenComm]" ; var o_state = document.getElementById("EditRecordTypesWrittenComm") ; o_state.multiple = true ; function f_listbox() { if ( v_state.indexOf(",") > 0 ) { for (var i=0 ; i < o_state.options.length; i++ ) { if(o_state[i].value == v_state) { o_state.remove(i); break ; } } var o_st = v_state.split(", ") ; for (var j=0 ; j < o_st.length; j++) { for (var i=0 ; i < o_state.options.length; i++ ) { if(o_st[j]== o_state.options[i].value){ o_state.options[i].selected = true ; break ; } } } } } function check_listbox() { var maximum_selections = 3; var MyListbox = document.getElementsByName("EditRecordTypesWrittenComm")[0]; var number_selections = 0; for (var i=0; i<MyListbox.length; i++) { if (MyListbox.options[i].selected) number_selections++; } if (number_selections>maximum_selections) { alert("You can select only " + maximum_selections + " items"); event.preventDefault(); } } document.addEventListener('BeforeFormSubmit', function(event) { check_listbox(); }); </script> Hope this helps. Regards, vitalikssssss
  24. Hi @Ajumathews, What issues? Did you follow the instruction from this Caspio tutorial? https://www.youtube.com/watch?v=2Y2lcVnMkZI Regards, vitalikssssss
  25. Hi @Chrille, You should use "EditRecord" prefix on Details page in order to reference a field. So, you code should look like this: <script type="text/javascript"> document.addEventListener('BeforeFormSubmit', function (event) { var v3 = '<img src="http://image_url" alt="YES"'; var v2 = document.getElementById("EditRecordKontaktad").value; if (v2 !="") { document.getElementById("EditRecordRingt").value = v3; }}); </script> Hope this helps. Regards, vitalikssssss
  • Create New...