Jump to content


Caspio Guru
  • Posts

  • Joined

  • Last visited

  • Days Won


Everything posted by Barbie

  1. Hi Batchini, You can use this CSS code: <style> input[class*="cbResultSetFile"]{ width: 190px !important; } </style> You can also change the 190px based on what width you refer. - Barbie
  2. Hi @Batchini, Let's assume that Table 1 is the Child_tbl_ and Table 2 is the Parent_Tbl. You may refer to the Task configuration below: I hope this works on your end. - Barbie
  3. Hi @Batchini, Yes you need to use a different code because Tabular Report and Gallery report has different structures, You can use this codes below. Put the fields between two HTML blocks. The first HTML Block should consist of this code: <div id="visi[@field:UniqueIDName]"> For the second HTML Block please paste this code: </div> <script> if('[@field:FieldName]' == '') { var isi = document.querySelector("#visi[@field:UniqueIDName] > span:nth-child(5)") isi.style.color='put your preferred color here'; } </script> ------- As I mentioned above, you need to change the nth child based on the position of your field. I hope this works. - Barbie
  4. Hello @Libby, We can achieve this using JavaScript custom coding. You may need to put the fields between two HTML blocks. The first HTML Block should consist of this code: ------- <div id="visi[@field:UniqueIDName]"> ------- For the second HTML Block please paste this code: ------- </div> <script> var isi = document.getElementById('visi[@field:UniqueIDName]').parentNode.parentNode; if('[@field:FieldName]' == " "){ isi.querySelector('td:nth-child(5)').style.backgroundColor = 'yellow'; } else{ isi.querySelector('td:nth-child(5)').style.backgroundColor = 'red'; } </script> You need to change the nth child based on the position of your field. I hope this works. - Barbie
  5. Hi @Batchini, What we can do as a workaround is to create criteria in your Field A and make the other criteria set as a checkbox that once checked, it will display the blank values only. Please refer to these sample screenshots: 1. 2. The first criteria will be the dropdown field and the second criteria will be the checkbox which will check if the records are blank. I hope this helps. - Barbie
  6. Hi @Batchini The Task is returning a Plain Text based on the dropdown option and should be changed to HTML. Please refer to the screenshot below: I hope this works now. Regards, Barbie
  7. Hi @Batchini, I am not sure what's the configuration of your DataPage. But you can try to refer to the CSS code below which might help you. <style> table[id^="cbTable"] > tbody > tr:nth-child(1) > th:nth-child(1):before { content: "Insert Title" !important; } </style> You may need to change the ID and the nth child based on your fields. I hope this helps. - Barbie
  8. Hi @Batchini I believe this can be achieve using Triggered action. Here's a sample screenshot for a sample configuration that you can refer to be The Name and the Age will be the name of the fields that you want to concatenate. Also, this Trigger contains blocks which are 'Insert into' and 'Update'. The Insert Into block works when you insert a new record from the first table and then it will automatically save the concatenated fields in the second table. The Update block will work if in case you update existing records, it will also update the records from the second table. I hope this helps. - Barbie
  9. Hi, You can also check this howto article that will help you generate a link: https://howto.caspio.com/tech-tips-and-articles/common-customizations/how-to-generate-link-menus-and-popup-windows/ - Barbie
  10. Hi @Batchini We can achieve this using CSS code. Please add a Header and Footer on your DataPage and paste the code below. <style> input[name*="cbParamVirtual4"] { pointer-events: none !important; } </style> I hope this works. - Barbie
  11. Hi @DDNex You might want to check this forum post which can help you with hiding a column in a tabular report. I hope this helps. - Barbie
  12. Hi, I had a similar issue before. Based on what I encounter before, you're current workflow can't be achieved if you are updating the records inside the same table. What I suggest is instead of updating the record on the table itself, you can pass or store the ID of the updated record to another table. After that, create a triggered action on the newly added table that will update the actual main table base from the ID you store on the other table. The reason why I suggest to use two tables is because you will encounter a recursion error when you used one table to update the child records just like what you mentioned. I hope this helps. - Barbie
  13. Hi @BiobestJon You can try the code in this article: https://forums.caspio.com/topic/8977-how-to-center-the-details-datapage/#comment-27597 Add a header and footer on your Search form and paste the code in the Header. Please insert the code on the style tag. It should look like this: <style> form[id^="caspioform"] { display: inline-block !important; } div[id^="cbOuterAjaxCtnr"] { display: block !important; text-align: center !important; } </style> I hope this works. - Barbie
  14. Hi @Batchini You may try this code and paste it in the header: <style> .cbResultSetListViewTableOddCell, .cbResultSetListViewTableEvenCell { border-radius: 20px !important; box-shadow: 5px 5px 10px #88888; } </style> You can also find the class style which is highlighted in red above inside the Style itself and add the border-radius and box-shadow if you want to easily apply it on all of your Gallery DataPages. I hope this works. - Barbie
  15. Hi @Batchini, You can checkout this trigger configuration which might help you achieve your workflow: What this trigger does is once you insert a record on the main table and it is not existing on the second table, it will save the records on the second table. Otherwise, it will not save since it is already existing in the said table. I hope this helps. - Barbie
  16. Hi @roattw, yes you are right. Once you used this JavaScript code to hide fields with default values with a certain condition, you might need to remove the rules you configure to hide the same fields as well. Hope this answer your question. - Barbie
  17. Hello @roattw, Once the field is being hidden using rules and this specific field has default value, the value itself will not be stored inside the table once submitted since it is hidden and considered as non existing field. If you want to achieve your current workflow, you may need a JavaScript code that will hide a field based on a checkbox. If you are familiar with Javascript, you may use the code below, paste it in the Footer and play around with it: <script> document.addEventListener("DataPageReady", function() { field = document.querySelector('input[id^="InsertRecordName"]'); label = document.querySelector('label[for*="InsertRecordName"]'); if (document.getElementById("cbParamVirtual1").checked) { field.style.display = "inline"; label.style.display = "inline"; } else { field.style.display = "none"; label.style.display = "none"; } document.getElementById("cbParamVirtual1").onclick = function() { if (document.getElementById("cbParamVirtual1").checked) { field.style.display = "inline"; label.style.display = "inline"; } else { field.style.display = "none"; label.style.display = "none"; }}}); </script> The code above will hide the field if the checkbox is not checked. You can modify the code and change the IDs assigned to it based on the ID of your field inside your DataPage. I hope this works on you end. Regards, Barbie
  18. Hi @Mitch, Yes, @SinJunYoung is right, this can be achieved using CASE WHEN Statement. Considering that once the Autonumber is already more than four digits it will display as is. Here's a sample formula which you can use: CASE WHEN [@field:Number_11] < 10 THEN '000' + (CONVERT(VARCHAR, [@field:Number_11])) + '_' + [@field:Name] WHEN [@field:Number_11] < 100 AND [@field:Number_11] >= 10 THEN '00'+ (CONVERT(VARCHAR, [@field:Number_11])) + '_' + [@field:Name] WHEN [@field:Number_11] >= 100 AND [@field:Number_11] <= 999 THEN '0'+ (CONVERT(VARCHAR, [@field:Number_11])) + '_' + [@field:Name] Else CONVERT(VARCHAR, [@field:Number_11]) + '_' + [@field:Name] END Here's a sample result assuming that the Number_11 field is the Autonumber field : I hope this works on you end. Regards, - Barbie
  19. Hi @Batchini To be able to change the position of the edit button, you may follow these steps: 1. Go to Styles and open the styles that you are using for the DataPage 2. Select Table Layout under Results Page 3. Under Element Type, look for Record Action Column 4. On the Position dropdown, change the position to Left. 5. Click Save then go to your DataPage then apply this Style I hope this helps. - Barbie
  20. Hi @Batchini, In addition, if you want to convert the imported date with the format of mm/dd/yyyy to dd/mm/yyyy you can use this formula: CONVERT(DATETIME, [@field:], 103) - Barbie
  21. Hello, based on the error that you have mentioned it seems that the issue is related to the format of your date values. Our table recognizes the mm/dd/yyyy format. If you're records are on different format, you might encounter this issue. What I can suggest if you really want to use this format, change the DataType from Date/Time to Text instead. Otherwise, change the format of it from dd/mm/yyyy to mm/dd/yyyy. I hope this helps. - Barbie
  22. Hi @Batchini, This is possible using CSS custom coding. You can use the sample code below in the Header of your DataPage. <style> input[name*="cbParamVirtual4"] { pointer-events: none !important; } </style> You need to change the cbParamVirtual4 based on the name of your field. I hope this works. - Barbie
  23. Hi @taylorswiftlover , If you want to change the color of a specific value you can use CSS code. You can create add a header and footer inside your Chart DataPage and paste this code on the Header: <style> rect.highcharts-point.highcharts-color-0:nth-child(1) { fill: #insertcolorhere; } rect.highcharts-point.highcharts-color-0:nth-child(2) { fill: #insertcolorhere; } rect.highcharts-point.highcharts-color-0:nth-child(3) { fill: #insertcolorhere; } </style> The number inside the parenthesis will correspond to the number of values from your columns. Here's a sample screenshot: https://c0acs764.caspio.com/dp/ba4a60009a119570a12e4c478dc4/files/3795862 Based on the screenshot, Central would be equal to 1, East would be equal to 2 and West would be equal to 3. Please note that you need to change the number inside the parenthesis of the corresponding number of the column that you prefer to change the color. I hope this works. Thanks, Barbie
  24. Hi @Batchini, You may want to check this formula: isnull([@field:Prefix],'') + (case when [@field:Prefix] = ' ' then '' else ' ' end)+ isnull( [@field:FirstName],'') + (case when [@field:FirstName] = ' ' then '' else ' ' end) + isnull( [@field:LastName],'') + (case when [@field:LastName] = ' ' then '' else ' ' end)) I hope this works. Regards, Barbie
  25. Hi @Batchini, I have came up with another solution which can achieve this workflow. First Add a Virtual Field then call the Text Area which rich text editor is enabled in the Virtual field. Here's a sample screenshot for reference: You can Hide the Virtual field. Please refer to this screenshot on how to do so: Lastly, add a Header and Footer. On the Footer paste this code: <div id="writing" style="width:90%; text-align:center; margin:0 auto 15px auto; font-size:11px; font-family:sans-serif; color:#000; padding:0 5%"> Total Word Count: <span id="cnt" style="color:red;">0</span> </div> <script type="text/javascript"> document.getElementsByName("cbParamVirtual1")[0].onchange=function() { var string = document.getElementsByName("cbParamVirtual1")[0].value; var wordcount = string.split(/[^\s]+/).length - 1; document.getElementById("cnt").innerHTML = wordcount; }; </script> 'cbParamVirtual1' should be changed based on what virtual field you're using. I hope this works. Thanks, Barbie
  • Create New...