Jump to content


Caspio Guru
  • Posts

  • Joined

  • Last visited

  • Days Won


Everything posted by Barbie

  1. Hi @Batchini, It might be having an issue with the quotation mark on the a href value. What you can do is to add a Virtual field that will display the link and paste the code below: CASE WHEN [@field:FieldName] = '1' THEN '<a href=' + '"' + 'https://nameofyoursite.html' + '?name=[@field:name]'>Link1</a>' ELSE '<a href='https://nameofyoursite.html'>Link2</a>' END I hope this works. - Barbie
  2. Hi @Batchini, By the way, you can also refer to this article for more information about styles: https://howto.caspio.com/styles/ - Barbie
  3. Hi @Batchini, I understand that you wanted to store the records from table 1 to table 2 if the ID is not existing in table 2. You can refer to this Task configuration that I have created: Again, with this configuration, let's assume that the Child_tbl_ is the 'Table 2' and the 'Parent_tbl' is the 'Table 1. The records will be inserted in table 2 if the ID of the records from Table 1 does not exist on this specific table. I hope this works! - Barbie
  4. Hi @AccessNerd, In addition to what I mentioned above, you may consider using Rules as well which will check what is the role if the user who's logged in then you can configure which section you want to hide. But Rules is only applicable in Submission and Details DataPage. Please refer to this article: https://howto.caspio.com/datapages/forms/conditional-forms/ - Barbie
  5. Hi @AccessNerd, You may want to check this article: https://howto.caspio.com/authentications-and-connections/authentication/record-level-security/restrict-access-to-data-by-user-or-role/ Also, you need to add multiple app parameters base on what you want to display. I hope this helps. - Barbie
  6. 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
  7. 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
  8. 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
  9. 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
  10. 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
  11. 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
  12. 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
  13. 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
  14. 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
  15. 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
  16. 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
  17. 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
  18. 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
  19. 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
  20. 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
  21. 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
  22. 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
  23. 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
  24. 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
  25. 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
  • Create New...