Jump to content


Caspio Guru
  • Posts

  • Joined

  • Last visited

  • Days Won


Everything posted by Barbie

  1. 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
  2. Just to add, you may also want to check out this article and video regarding styles: https://howto.caspio.com/styles/
  3. You're welcome, you may also refer to this howto article to learn more about charts: https://howto.caspio.com/datapages/charts/ -Barbie
  4. 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
  5. Hi, Here's a screenshot on how to achieve your workflow: Hope this helps.
  6. you can also refer to this article regarding Data Types: https://howto.caspio.com/tables-and-views/data-types/
  7. Hi @Batchini, On your table, click the timestamp field and on the right side there will be an options. Click the stamp on update. So that when the users tried to edit the records the time and date will be stamped. Please refer to the screenshot. Hope this helps.
  8. Hi, Just to add some information, you can also check this link: https://howto.caspio.com/function-reference/ Just go to the "MISCELLANEOUS FUNCTIONS AND EXPRESSIONS" and you will see a sample syntax of case when function. Hope this helps. - Barbie
  9. In addition to that, you may want to check out this article: https://howto.caspio.com/function-reference/ Just scroll down to Subqueries in Calculated Fields Thanks
  10. Hi, Just to add some information, I suggest create a calculated field and create a SELECT statement where you will get the values from the other table and then subtract the other field. Here's a sample select statement: ([@field:Payment]) - (SELECT Paid FROM tbl_2_2 WHERE Customer_ID=target.[@field:Customer_ID]) Hope this helps. -Barbie
  11. Hi, Just to update this, here's a documentation regarding Query String: https://howto.caspio.com/parameters/parameters-as-query-string-values/ Hope this helps. -Barbie
  12. 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. -Barbie
  13. Hi @Batchini, Yes, you can achieve by using an SQL expression in Calculated Value or Calculated Fields. You can refer to this article and scroll through the Subqueries in Calculated fields: https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/ there is a sample SELECT statement that will help you achieve your workflow. Hope this helps. -Barbie
  14. Barbie


    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
  15. Just to add information on this you may want to visit our How to article on how to quickly understand what is triggered action: https://howto.caspio.com/tables-and-views/triggered-actions/
  16. 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. -Barbie
  17. Ohh so you need to put the link of your submission form in the Localization. Here's a screenshot on how to: https://c0acs764.caspio.com/dp/ba4a60009a119570a12e4c478dc4/files/3354299 Used the deployed URL of your submission form for the link. -Barbie
  18. Hi @Batchini, What I suggest for this workflow is, create a Search and Submission form and then we will put the link on the Localization. So basically, you will be needing two DataPage here. If you searched a record and it is not existing there will be a link that will redirect you to a submission form otherwise the records will be displayed. Here's a sample DataPage of what I am trying to explain: https://c1acn120.caspio.com/dp/68f07000d1ce52704efb40e99fd6 Hope it helps. -Barbie
  19. Hi @npaulpatrick, Hi just to update, you may also refer to this video on how to create a Multi-Step form Hope this helps. -Barbie
  20. Hi, please try this instead: CASE WHEN [@field:UserName] LIKE '%Emp'THEN 'Employee'ELSE 'Manager' END hope this works -Barbie
  21. Hi @Batchini, Add a Header and Footer and paste this code inside the header: <style> input[id^="Mod0CancelRecord"]{ display: none !important; } </style> And then on the HTML Block please paste this code: <input type="submit" name="Mod0CancelRecord" value="Back" class="cbBackButton"> I hope this works. -Barbie
  22. Hi @joneslovescaspio, You can also use the &nbsp. The &nbsp is a nonbreaking space which keeps words on both sides of it to stay on the same line. While the &emsp is a wide kind of space. Hope this helps. -Barbie
  23. Hi @telly, You may also refer to this article to know more about the function reference: https://howto.caspio.com/function-reference/ -Barbie
  24. Hi @telly, If your field 'First_Employment' is an date/time this formula should work: Can you try this instead: CONVERT(VARCHAR(10), Datediff(year, [@field:First_Employment],GetUTCDate())) + 'years' Hope this works on your end. -Barbie
  25. Hi, This might be a possible workaround for your workflow, I suggest that you create a CASE statement. You need to set the form element of 'Deleted ' 'Approved', and 'Submitted' fields to Calculated value and paste the statements below. For Deleted: CASE WHEN [@field:Deleted]= 1 THEN '[@authfield:Client_Email]' ELSE ' ' END For Approved: CASE WHEN[@field:Approved]= 1 THEN '[@authfield:Client_Email]' ELSE ' ' END For Submitted: CASE WHEN [@field:Submitted]= 1 THEN '[@authfield:Client_Email]' ELSE ' ' END Once the user did not check the check boxes, it will not stamp the user's email. I hope this works for you. -Barbie
  • Create New...