Jump to content


Caspio Guru
  • Content Count

  • Joined

  • Last visited

  • Days Won


Barbie last won the day on November 1

Barbie had the most liked content!

1 Follower

About Barbie

  • Rank
    Advanced Member

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Hi @Batchini I can see that already asked this question. Here's the solution I provided on the other forum post which is same by this: https://forums.caspio.com/topic/16790-passed-parameter-based-on-a-condition/#comment-45906
  2. 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
  3. Hi @Batchini, By the way, you can also refer to this article for more information about styles: https://howto.caspio.com/styles/ - Barbie
  4. 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
  5. 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
  6. 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
  7. 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
  8. 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
  9. 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 ab
  10. 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 = 're
  11. 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
  12. 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
  13. 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
  14. 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 t
  15. 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
  • Create New...