Jump to content

Meekeee

Caspio Rockstar
  • Posts

    307
  • Joined

  • Last visited

  • Days Won

    8

Reputation Activity

  1. Thanks
    Meekeee reacted to telly in Responsive Chart Legend Restriction   
    Hi @FredFarfadoe,

    To achieve that you will need to add a CSS code on the header of the DataPage:

    You can use this:
     
    <style>
    g.highcharts-series-group {
    pointer-events: none!important;
    }
    .highcharts-a11y-proxy-button {
    pointer-events: none!important;
    }   tspan {
    pointer-events: none!important;
    }
    </style>
  2. Thanks
    Meekeee got a reaction from Catra in Chart Style   
    Hi @Catra - you can change it in Styles -> DataPage Elements: Charts


    Legend:


    I hope it helps!
  3. Like
    Meekeee got a reaction from Cherry in How to adjust the space between 2 buttons   
    Hi @Cherry - You can try to use margin-left on this. I created a sample just like yours and this is the result:

    Before:


    After:


    What I did on this is that I find the HTML Container using the browser's inspect and add the CSS in the Header of the DataPage:



    You can copy the code and just change the class based where your HTML Block is placed in your DataPage. 
     
    <style> div[class*="cbFormData cbFormBlock5"] { margin-left: -35px !important; } </style> I hope this helps!
  4. Like
    Meekeee got a reaction from Catra in Use Range in Date Field   
    Hi @Catra - you can try this one:
     
    CASE WHEN [@field:DATE_FIELD] >= CONVERT(datetime, 'mm/dd/yyy', 101) AND [@field:DATE_FIELD] <= CONVERT(datetime, 'mm/dd/yyy', 101) THEN 'TRUE' ELSE 'FALSE' END For more information, you may check this article: 
    https://howto.caspio.com/function-reference/
  5. Thanks
    Meekeee got a reaction from Catra in Export Data from Table   
    You may filter first the table with your desired data and click the Download option. You may check this article for more information:
    https://howto.caspio.com/tables-and-views/managing-data/filtering-data/
  6. Thanks
    Meekeee got a reaction from Catra in Embed Document   
    Hi @Catra- you can embed documents in DataPages, see this article: https://howto.caspio.com/tech-tips-and-articles/advanced-customizations/tech-tip-embed-documents-in-datapages/
    For Dropbox, follow this workaround:
    1. Change the code with this:
    <object style="width:718px; height:700px;" frameborder="0" data="[@field:Attachment]" type="application/pdf"> <embed src="[@field:Attachment]" type="application/pdf" /> </object> You can freely change the height and width. 
    2. Replace the end of the URL with 'raw=1'. Here's an example:
    From: https://www.dropbox.com/Link.pdf?dl=0
    Change it to: https://www.dropbox.com/Link.pdf?raw=1
    Then Disable AJAX of the DataPage  - to disable, check this article: https://howto.caspio.com/datapages/ajax-loading/
  7. Like
    Meekeee got a reaction from Flowers4Algernon in 12-hr Format   
    Your formula is great! Thanks for sharing. Hmm, you can try JavaScript in the DataPage as well?  
    https://stackoverflow.com/questions/13898423/javascript-convert-24-hour-time-of-day-string-to-12-hour-time-with-am-pm-and-no
    https://www.geeksforgeeks.org/convert-time-from-24-hour-clock-to-12-hour-clock-format/
  8. Like
    Meekeee got a reaction from Veretta in Matrix Table   
    Hi @Veretta,
    If this is from an Excel, you can copy and paste the table in HTML Block, just like this one:



    The table will be plain and without borders, you can re-configure it inside the HTML editor. For more information about HTML Editor, see this reference:
    https://howto.caspio.com/datapages/datapage-components/html-blocks/
    I hope this helps. 
  9. Like
    Meekeee got a reaction from pmcfarlain in Conditionally change color of text field in tabular report   
    Hi @pmcfarlain - you may try this forum post
     
    This is the result I had


    My code in HTML Block

     
    <div id="visi-[@field:GUID]"></div> <script> var isi = document.getElementById("visi-[@field:GUID]"); if([@calcfield:1#] < 0 ){ isi.parentNode.parentNode.classList.add('custom-less') } else{ isi.parentNode.parentNode.classList.add('custom-greater'); } </script>
    Header
    <style> [class*="custom-"] * { color: inherit !important; } .custom-less { color: red; background-color: yellow !important; } .custom-greater{ color: black; background-color: transparent !important; } </style> I hope this helps!
  10. Like
    Meekeee reacted to DesiLogi in how to reference field in javascript in tabular 'inline add new' at top of report   
    Hi, I'm trying to use the code below in the footer of a tabular report results section for the 'Inline Add New Record' can use it. The js is code to get the user's computer date/time (not the localization or CB system) and put it in a date/time field. I use this code in submission forms with no issues but don't know how to reference it correctly for a tabular inline add new record. If someone knows how to mod this I'd really appreciate it. 
    <SCRIPT LANGUAGE="JavaScript"> /* Declaration and initialization */ Stamp = new Date(); var v_TimeStamp; Hours = Stamp.getHours() Mins = Stamp.getMinutes(); Secs = Stamp.getSeconds(); /* Attach a prefix with digit '0' if the minutes is less than 10. */ if (Mins < 10) { Mins = "0" + Mins; } /* Construct the value of the v_TimeStamp variable in the format m/d/yyyy hh:mm */ v_TimeStamp=('' + (Stamp.getMonth() + 1) +"/"+Stamp.getDate()+ "/"+Stamp.getFullYear() + ' ' + Hours + ":" + Mins + ":" + Secs); document.getElementById("InsertRecordComments_Actual_Submission_Date").value=v_TimeStamp; </SCRIPT> EDIT: just found the solution right after posting this. In case anyone needs it, tabular inline add uses 'InlineAdd' instead of 'InsertRecord'. Wish everything was so easy!
  11. Like
    Meekeee reacted to autonumber in How to update files using Caspio REST API   
    Hello there! You need to still get the file path of your files and you can use any field as your reference for each of the record.  
    Table Name: File_
    New values of the record: 
    {
    "File_":"/Files/CSS.pdf"
    }
    WHERE Clause:
    ID='QOCISEZA'
     
    - I have a folder that contains the files and use the ID field to reference it. 
  12. Like
    Meekeee got a reaction from Arundhati in PMT calculation for college savings   
    Hi @Arundhati,
    For PMT Calculation, you can check this video as well:
    Hope it helps!
  13. Like
    Meekeee reacted to Vitalikssssss in Line-through in Data   
    Hi @JanineB,
    It looks like the "$" currency sign added by formatting is the reason for element value not been recognized as a number.
    You may add a replace function with regex to remove unwanted characters from value formatted as currency.
    So, your JavaScript would look like this:
    <script> var elems = document.getElementsByTagName("td"); for (var i=0, m=elems.length; i<m; i++) { if (elems[i].innerHTML.replace(/[^0-9\.-]+/g,"") > 0) { elems[i].style.textDecoration = "line-through"; } } </script> Regards,
    vitalikssssss
  14. Thanks
    Meekeee got a reaction from JanineB in Change color   
    You may refer to this forum post as a reference:
     
    then change it to this code:

     
    <style> [class*=cbResultSetHeaderCell]:nth-child(9) a { color: red !important; } </style> a is for the href attribute and color is for the text of it.
     
    I hope it helps!
  15. Like
    Meekeee got a reaction from JanineB in Change color   
    You could change it to this.

     
    <style> td[class*="cbResultSetData"]:nth-of-type(9){ color: red !important; } </style>  
  16. Confused
    Meekeee reacted to taylorswiftlover in Move chat box   
    how do i move the chat box? It is obstructing my view of the table.
  17. Haha
    Meekeee reacted to SinJunYoung in Move chat box   
    If you are referring to the Live Help icon beside your table, you may simply click the icon and the chat pop up should appear afterwards. You may drag the chat away from the view of your table and minimize it afterwards. I do chats a lot and I think support already knows me already hahahaha   Screenshot:
  18. Thanks
    Meekeee reacted to Barbie in Payment   
    Here are the currency that Caspio accepts:
    USD - US Dollars
    AED - United Arab Emirates Dirham
    AFN - Afghan Afghani
    ALL - Albanian Lek
    AMD - Armenian Dram
    ANG - Netherlands Antillean Guilder
    AOA - Angolan Kwanza
    ARS - Argentine Peso
    AUD - Australian Dollars
    AWG - Aruban Florin
    AZN - Azerbaijani Manat
    BAM - Bosnia-Herzegovina Convertible Mark
    BBD - Barbadian Dollar
    BDT - Bangladeshi Taka
    BGN - Bulgarian Lev
    BIF - Burundian Franc
    BMD - Bermudan Dollar
    BND - Brunei Dollar
    BOB - Bolivian Boliviano
    BRL - Brazilian Real
    BSD - Bahamian Dollar
    BWP - Botswanan Pula
    BZD - Belize Dollar
    CAD - Canadian Dollar
    CDF - Congolese Franc
    CHF - Swiss Franc
    CLP - Chilean Peso
    CNY - Chinese Yuan
    COP - Colombian Peso
    CRC - Costa Rican Colón
    CVE - Cape Verdean Escudo
    CZK - Czech Republic Koruna
    DJF - Djiboutian Franc
    DKK - Danish Krone
    DOP - Dominican Peso
    DZD - Algerian Dinar
    EGP - Egyptian Pound
    ETB - Ethiopian Birr
    EUR - Euro
    FJD - Fijian Dollar
    FKP - Falkland Islands Pound
    GBP - British Pound Sterling
    GEL - Georgian Lari
    GIP - Gibraltar Pound
    GMD - Gambian Dalasi
    GNF - Guinean Franc
    GTQ - Guatemalan Quetzal
    GYD - Guyanaese Dollar
    HKD - Hong Kong Dollar
    HNL - Honduran Lempira
    HRK - Croatian Kuna
    HTG - Haitian Gourde
    HUF - Hungarian Forint
    IDR - Indonesian Rupiah
    ILS - Israeli New Sheqel
    INR - Indian Rupee
    ISK - Icelandic Króna
    JMD - Jamaican Dollar
    JPY - Japanese Yen
    KES - Kenyan Shilling
    KGS - Kyrgystani Som
    KHR - Cambodian Riel
    KMF - Comorian Franc
    KRW - South Korean Won
    KYD - Cayman Islands Dollar
    KZT - Kazakhstani Tenge
    LAK - Laotian Kip
    LBP - Lebanese Pound
    LKR - Sri Lankan Rupee
    LRD - Liberian Dollar
    LSL - Lesotho Loti
    MAD - Moroccan Dirham
    MDL - Moldovan Leu
    MGA - Malagasy Ariary
    MKD - Macedonian Denar
    MMK - Myanma Kyat
    MNT - Mongolian Tugrik
    MOP - Macanese Pataca
    MRO - Mauritanian Ouguiya
    MUR - Mauritian Rupee
    MVR - Maldivian Rufiyaa
    MWK - Malawian Kwacha
    MXN - Mexican Peso
    MYR - Malaysian Ringgit
    MZN - Mozambican Metical
    NAD - Namibian Dollar
    NGN - Nigerian Naira
    NIO - Nicaraguan Córdoba
    NOK - Norwegian Krone
    NPR - Nepalese Rupee
    NZD - New Zealand Dollar
    PAB - Panamanian Balboa
    PEN - Peruvian Nuevo Sol
    PGK - Papua New Guinean Kina
    PHP - Philippine Peso
    PKR - Pakistani Rupee
    PLN - Polish ZlotyPYG
    PYG - Paraguayan Guarani
    QAR - Qatari Rial
    RON - Romanian Leu
    RSD - Serbian Dinar
    RUB - Russian Ruble
    RWF - Rwandan Franc
    SAR - Saudi Riyal
    SBD - Solomon Islands Dollar
    SCR - Seychellois Rupee
    SEK - Swedish Krona
    SGD - Singapore Dollar
    SHP - Saint Helena Pound
    SLL - Sierra Leonean Leone
    SOS - Somali Shilling
    SRD - Surinamese Dollar
    STD - São Tomé and Príncipe Dobra
    SZL - Swazi Lilangeni
    THB - Thai Baht
    TJS - Tajikistani Somoni
    TOP - Tongan Pa'anga
    TRY - Turkish Lira
    TTD - Trinidad and Tobago Dollar
    TWD - New Taiwan Dollar
    TZS - Tanzanian Shilling
    UAH - Ukrainian Hryvnia
    UGX - Ugandan Shilling
    UYU - Uruguayan Peso
    UZS - Uzbekistan Som
    VND - Vietnamese Dong
    VUV - Vanuatu Vatu
    WST - Samoan Tala
    XAF - CFA Franc
    XCD - East Caribbean Dollar
    XOF - CFA Franc
    XPF - CFP Franc
    YER - Yemeni Rial
    ZAR - South African Rand
    ZMW - ZMW   Hope this helps.   -Barbie
  19. Thanks
    Meekeee reacted to glissando in Wordpress Deployment Overrides Caspio Settings   
    It does require a login as it has security.  I will post again in a bit to provide you access.  Thanks
  20. Like
    Meekeee reacted to kpcollier in Count Number of Fields In Table   
    Perfect. Thank you!
  21. Thanks
    Meekeee got a reaction from kpcollier in Count Number of Fields In Table   
    Hi @kpcollier,
    You can do this by going to your tables and check the "Fields" from the gear like Setting. Here's a screenshot:

     
    I hope it helps!
  22. Thanks
    Meekeee reacted to jimarch in Filestor URL for Image   
    Yes, this is exactly what I was needing!!!  
  23. Haha
    Meekeee reacted to SunakoChan in Tooltip   
    Hi  @telly,
     
    This is doable, you just need to add <image src="IMAGEURL"> on your hint.

    Sample Result Bellow:

     
  24. Like
    Meekeee got a reaction from geoffdude in Form change due to validation prevents javascript function   
    Are you familiar with the Caspio's article regarding its 13.0 impacted Areas? Here: https://howto.caspio.com/release-notes/caspio-bridge-13-0/13-0-impacted-areas/
    I think your script might need a little modification due to the incompatibility with the new feature of AJAX. Or you can try to check the 'Disable AJAX Loading' on your DataPage.
     
    And test if it will work now. I hope this helps!
  25. Like
    Meekeee reacted to geoffdude in Form change due to validation prevents javascript function   
    Thanks very much .. that was the issue.
    I've used the modified script for many of my pages but just forgot completely on this form to use it. Also, the "Disable AJAX loading" function once checked worked as well. (I have it enabled now though since I've updated the script).
     
    For those that may want to see the updated script that works, here you go.
    <script type="text/javascript"> document.addEventListener('DataPageReady', function (event) { $('input[id="InsertRecordbilling_different"]').click(function(){ if($(this).prop("checked") == true){ /*alert("Checkbox is checked.");*/ parent.document.getElementById('iFrameCaspio').style.height = "860px"; } else if($(this).prop("checked") == false){ /*alert("Checkbox is unchecked.");*/ parent.document.getElementById('iFrameCaspio').style.height = "630px"; } }); }); </script>  
×
×
  • Create New...