Jump to content


Caspio Guru
  • Posts

  • Joined

  • Last visited

  • Days Won


Everything posted by Barbie

  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, Barbie
  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
  16. Hi @taylorswiftlover, Upon checking the AJAX wil be grayed out when one of the Editing Options is enabled. (Grid Edit, Bulk Edit, Bulk delete) You may refer to this screen shot: Hope this helps. -Barbie
  17. Hi @telly, You may also refer tot his article: https://howto.caspio.com/styles/using-google-web-fonts/ Hope this helps. -Barbie
  18. Hi @Batchini, You can change the position and colors of chart inside your Styles. You may refer to this: Hope this helps. -Barbie
  19. Hi @Batchini, You can put this &nbsp; on your Display and remove the Value of it.It will now give you a blank value in your drop down option. &nbsp; is an HTML character for a non-breaking space. It's purpose is so that the words won't be broken into two lines by "word-wrap". Since it does that, HTML renders it as a space. Hope this helps. -Barbie
  20. You may need this code to achieve your workflow: .cbResultSetTable * { font-size: 15pt !important; } please change the font size based on what you prefer. Hope it helps. -Barbie
  21. Barbie

    scroll up

    Hi, This workflow is possible when you disabled the Ajax in your DataPage, however, if your reports have a search at the top of it, ajax is not possible to disable. If you really need this functionality, you need to choose the 'Display search form and results on separate screens' instead of the 'Display search form above the results' then disable the Ajax. Hope this helps. -Barbie
  22. Just to add, you may also want to check out this article and video regarding styles: https://howto.caspio.com/styles/
  23. You're welcome, you may also refer to this howto article to learn more about charts: https://howto.caspio.com/datapages/charts/ -Barbie
  24. Hi @taylorswiftlover, For you to be able to achieve your workflow, you need to add another X-axis on your Chart DataPage. Please refer to the screenshots: 1. Choose the 'Use a separate field for each series' in the Data Source settings: 2. Add another X axis: 3. Change the Formatting of your X-axis: Hope this helps. - Barbie
  25. Hi, Here's a screenshot on how to achieve your workflow: Hope this helps.
  • Create New...