Jump to content


Caspio Ninja
  • Content Count

  • Joined

  • Last visited

  • Days Won


Barbie last won the day on August 22

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 @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
  2. 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 record
  3. 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
  4. 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
  5. 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
  6. 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
  7. 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^="InsertRecord
  8. 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_1
  9. 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
  10. 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
  11. 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
  12. 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
  13. Hi @taylorswiftlover , If you want to change the color of a specific field 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 fields from your columns. Here's a sample sc
  14. 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
  15. 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;
  • Create New...