Jump to content


Caspio Ninja
  • Content Count

  • Joined

  • Last visited

  • Days Won


Barbie last won the day on August 31 2019

Barbie had the most liked content!

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, Can you try pasting this on the Header of your DataPage: <style> div[class*="cbFormMultiSelectText"] { white-space: normal !important; } </style> I hope this works on your end. Thanks,
  2. HI @astroboy, This can be done using JavaScript. Below is the code which you can refer to: <script> document.addEventListener("DataPageReady", function() { button = document.querySelector('input[id^="Test"]'); if (document.getElementById("cbParamVirtual1").checked) { button.style.display = "inline"; } else { button.style.display = "none"; } document.getElementById("cbParamVirtual1").onclick = function() { if (document.getElementById("cbParamVirtual1").checked) { button.style.display = "inline"; } else { button.style.display = "none"; }}}); </script> I hope this works. - Barbie
  3. Hi @astroboy, If you're using a submission form and you want to save the result in the table you need to add a field where you will store the result. Set the form element of that specific field to Calculated Value and paste this formula: CONVERT(VARCHAR, ABS(DATEDIFF( mm, [@field:StartDate], [@field:EndDate]) / 12)) + " Year(s) " + CONVERT(VARCHAR, ABS(DATEDIFF( mm, [@field:StartDate], [@field:EndDate]) % 12)) + " Month(s) " + CONVERT(VARCHAR,ABS(DATEDIFF( dd, DATEADD( mm, DATEDIFF( mm, [@field:StartDate], [@field:EndDate]), [@field:StartDate]), [@field:EndDate]))) + " Day(s)" Make sure to change the field names. I hope this works. Thanks, Barbie
  4. Please use the formula below: CONVERT(FLOAT,SUBSTRING([@field:timefield], 0, (Charindex(':', [@field:timefield], 0))))*60 + CONVERT(FLOAT,SUBSTRING([@field:timefield], (Charindex(':', [@field:timefield], 0)+1), 5)) For more information regarding the function reference, you may want to check out this Howto article: https://howto.caspio.com/function-reference/ Hope this helps. -Barbie
  5. Barbie

    Date today

    Hi @Batchini, You can refer to this Task that I have created to check if your Date field is equals to today's date: https://c0acs764.caspio.com/dp/ba4a60009a119570a12e4c478dc4/files/3606024 Hope this works for you. -Barbie
  6. I have a calculated field on a report page: Datediff(minute,[@field:Start_Time], [@field:End_Time]) This calculates the number of minutes between the start and end time, but I want it to show up at total hours, as in 3.75 hours. I updated it like this: Datediff(minute,[@field:Start_Time], [@field:End_Time])/60 but it gives me a 3 only for an answer.
  7. Hi @Batchini, It seems that some of your fifthfield contains 0 value. What I suggest is to use NULLIF instead of ISNULL. You formula should be like this: (IsNull([@field:firstfield], 0)- IsNull([@field:secondfield], 0)- IsNull([@field:thirdfield], 0)- IsNull([@field:fourthfield], 0)) /NULLIF([@field:fifthfield], 0) I hope this works. -Barbie
  8. Hi Batchini, you can use this instead: CASE WHEN LEFT([@field:Phonenumber], 1) = '0' THEN REPLACE(LTRIM(REPLACE([@field:Phonenumber], '0', ' ')), ' ', '0') ELSE [@field:Phonenumber] END -Barbie
  9. Hi Batchini, may you please try this Case when statement instead? CASE WHEN '[@authfield:BTN_User_Accounts_Permanent_Discount]'='' THEN '0' ELSE '[@authfield:BTN_User_Accounts_Permanent_Discount]' END I changed the IS NULL to ' ' hope it works on you. -Barbie
  10. Hi @Batchini List String, Password, Yes/No, File, and Text (64000) data type fields are not available in relationships and are not shown in these interfaces. Please refer to this HowTo article to know more about Data Types Compatibility: https://howto.caspio.com/tables-and-views/relationships/ Hope this helps. -Barbie
  11. Hi @Batchini, What I suggest is to use the "Specific data field" instead of the Default action link. By that, it will let your users redirected to the Details Page by clicking the field that you set. Please refer to this screenshot: Hope this helps. -Barbie
  12. I want the calendar popup on a sumbission form to be twice the size it is right now. It is very small.
  13. Hi @Batchini, You may also refer to this article: https://blog.online-convert.com/activate-unblock-automatic-downloads-in-google-chrome/ Hope this helps. -Barbie
  14. Hi @Batchini, I believe this is an issue on your browses settings. You may need to change your browser settings for you to be able to download the exported Table. If you are using Chrome, you may follow the steps below: 1. Open Chrome and click on the three dots (Chrome menu). 2. Click on "Settings". 3. Then, click on "Advanced". This will show more advanced settings. 4. Then click "Privacy and security". Then click on "Site Settings". 5. Go to "Automatic downloads". And make sure to enable it. You may refer to this screenshot: I hope it works now. -Barbie
  15. I see, upon checking. You will see "Disable AJAX loading feature" greyed out if you have these following enabled in your DataPage setup: Set the display search form above the result Grid edit Bulk Edit Bulk Delete Sorry for the missed info. Hope this works now. You may also want to check this article: https://howto.caspio.com/datapages/ajax-loading/ -Barbie
  • Create New...