Jump to content


Caspio Guru
  • Content Count

  • Joined

  • Last visited

  • Days Won


Reputation Activity

  1. Like
    Barbie got a reaction from Inscriptor in Triggered not working when data was imported   
    Hello @Kuroshi
    I am thinking of a workaround for this and came up with this ->  Create a Task instead that has the same functionality as your Triggered action. Task is somehow similar to trigger. However, the task will not fire automatically once you inserted a record. you will need to click the 'Run' task or schedule when will the Task run.
    I hope this helps and works.
    - Barbie
  2. Thanks
    Barbie got a reaction from HeyItsDoug in Hide Search button   
    Hi Watusi,

    You can try to paste this code in your header instead:
    <style> input[class*="cbSearchButton"]{ display:none !important; } </style> I hope this works for you.
  3. Thanks
    Barbie got a reaction from vanderLeest in Hide Search button   
    Hi Watusi,

    You can try to paste this code in your header instead:
    <style> input[class*="cbSearchButton"]{ display:none !important; } </style> I hope this works for you.
  4. Like
    Barbie reacted to Mitch in Formula field - add leading zeros to numeric value   
    Thanks to both of you.  Learned a  lot here.  Great to be a new member with such helpful fellow members!
  5. Like
    Barbie got a reaction from roattw in Conditional fields - fields with default values dont send that value if hidden by rule.   
    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^="InsertRecordName"]'); label = document.querySelector('label[for*="InsertRecordName"]'); if (document.getElementById("cbParamVirtual1").checked) { field.style.display = "inline"; label.style.display = "inline"; } else { field.style.display = "none"; label.style.display = "none"; } document.getElementById("cbParamVirtual1").onclick = function() { if (document.getElementById("cbParamVirtual1").checked) { field.style.display = "inline"; label.style.display = "inline"; } else { field.style.display = "none"; label.style.display = "none"; }}}); </script> The code above will hide the field if the checkbox is not checked. You can modify the code and change the IDs assigned to it based on the ID of your field inside your DataPage.

    I hope this works on you end.

  6. Like
    Barbie got a reaction from ParkLoey in Word Count   
    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;">0</span> </div> <script type="text/javascript"> document.getElementsByName("cbParamVirtual1")[0].onchange=function() { var string = document.getElementsByName("cbParamVirtual1")[0].value; var wordcount = string.split(/[^\s]+/).length - 1; document.getElementById("cnt").innerHTML = wordcount; }; </script> 'cbParamVirtual1' should be changed based on what virtual field you're using.

    I hope this works.

  7. Like
    Barbie got a reaction from Watusi in Dropdown value   
    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.

  8. Thanks
    Barbie got a reaction from Watusi in Hide Search button   
    Hi Watusi,

    You can try to paste this code in your header instead:
    <style> input[class*="cbSearchButton"]{ display:none !important; } </style> I hope this works for you.
  9. Thanks
    Barbie got a reaction from taylorswiftlover in Bar Chart X-Axis Value   
    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
  10. Thanks
    Barbie got a reaction from taylorswiftlover in Centered Report Search   
    Hi @joneslovescaspio,
    You can add the center tag and the close tag of center in the header and Footer. So basically, in your header, you need to paste this 
    <center> <style> table[class*="cbFormTable"] { border: none !important; background: white; } </style> and in the footer just paste the end tag of center.
    </center> Please note that I just added a sample design for your search form using CSS. You can also change that based on what design you prefer.
    Hope it works.

  11. Thanks
    Barbie got a reaction from Meekeee 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
  12. Like
    Barbie got a reaction from DefinitelyNot31337 in Date Range Calendar event   
    Hi @Batchini,

    What I suggest is to create a triggered action and add 3 tables. Below are the steps on how to:
    1. Create Table 1. You will store here all of the information about Events. Screenshot:
    2. Create Table 2. The trigger will be the one to populate this table. Screenshot:

    3. Create the table 3. This will consists of the maximum number of days that the event can last. Screenshot:

    4. Lastly, create a trigger that will populate the table two. Please refer to this:
    Hope this works for you.

  13. Thanks
    Barbie reacted to SinJunYoung in World of Warcraft: Caspio Guild Applications   
    Hello @Subtlety, 
    I think this depends upon what that public forum is trying to achieve. In some cases, Caspio does have a certain feature which you can use but in some, it may require custom codes or in some cases complex ones. Well, for you to better understand Caspio, I think they have their trainings and other stuff that you can utilize. I believe it's here https://www.caspio.com/training. They are conducted during the weekdays and they are free. 
    There are also some features that you may want to check such as Authentication, API Integration, etc. at https://howto.caspio.com.
    Also, I think it is better if you try to fill out the form of their Professional Services team at https://www.caspio.com/services/professional-services/
    I hope this helps you. 
  • Create New...