Jump to content


Caspio Ninja
  • Posts

  • Joined

  • Last visited

Everything posted by Kuroshi

  1. I am trying to create an HTML DataPage that will redirect based on roles. And upon creating it, and login using an Admin, it redirects to the other page that says 404 error. I am redirecting it to the /dashboard.html and I am deploying my DataPags to weebly. Am i missing something here?
  2. Hi. I am trying to build a search form that will allow me to search 'Any' and display all the records and search 'Blank' records as well. Is there a needed criteria for this? Thanks.
  3. Hi. I am trying to build a search form that will allow me to search 'Any' and display all the records and search 'Blank' records as well. Is there a needed criteria for this? Thanks.
  4. @BarbieThank you so much!!! That worked. Can you also confirm if changing the position of chart title needs this complex JavaScript coding? If yes, can you provide me a reference as well?
  5. Hi, is it possible to remove the vowels from the string? For example, my field name contains 'Kuroshi', it should be returned as Krsh. Is that possible? Do you have any articles for this or a sample formula that I can refer to? Thanks, Kuroshi
  6. Hello, I have a chart and I want to add spacing on the legend items. I tried to check and modify this using CSS since I am familiar with it but with no luck. Do you have other ideas guys? Can you help me?
  7. I want to add a vertical lines in my pivot datapage for better look. Is it possible to dd under styles? If yes, how?
  8. I have this formula: CASE WHEN [@field: Calendar_ID] = ' ' THEN '<a href= "https://accountid.caspio.com/dp/appkey?Calendar_Date=[@field:WorkDays_Date*]&ResourceName=[@field:ResourceName]"> Test </a>' ELSE ' ' END However it is not working as expected. Logic is if the field Calendar_ID is blank, then show the Test link. Link is not showing.
  9. Hello, I requested an RMA twice and encounter some issue while accessing the DataPages. Sometimes, when I access the DataPage with authentication it brings me to a non existing page which has this kinkd of URL: https://accountID.caspio.com?cbr=somenumbershere I am not sure why this is happening. Can you help or do you have any ideas why?
  10. Hello I have a report DataPage specifically Tabular. It contains 20 fields in the results page. I tried to change the width of the specific field but it did not change anything. I also use CSS but with no luck. Can you help?
  11. I have a table that has Triggered action. When records were inserted, it will copy some of the data to other table. However, I tried to import a file to the table as an append and the Triggered action did not fire. But, my triggered is working as expected when I entered or inserted a record directly in the table. Any thoughts?
  12. Hello, I have several fields in a submission form. If the fields are not being populated, I want the submit button disabled. Is this possible under your localization or Styles? Hoping for a response. Thank you.
  13. Hi guys, I have a simple question to make sure that it will work. If I import my Access Database in Caspio and the fields have '-' and '()' in the field names, also if some of the field DataType is set to 'OLE Object', this will be successfully imported in Caspio, right? Or should I remove/change every field?
  14. Hi @Barbiewe have similar workflow and I believe this is the code that I came up to to achieve that: <style> td[class*="cbResultSetData cbResultSetTableCell cbResultSetCalculatedField"] { display: none !important; } </style> You can try that one and I hope that works.
  15. That worked! I tried this on my Details page and it says submit not update. Should I use different code for that? Thnx
  16. I want to add the submit button at the top of the page if in case they are at the top of the page, users can submit the page without scrolling at the bottom part. But I want to remain the submit button at the bottom. Is that possible?
  17. I have here an inline Add form. Is it possible that once an item is already selected, the item will no longer be selected on the same instance? Only one dropdown. So basically, once the option is selected in the dropdown will not be included already once selected.
  18. @BarbieHello now I think I need to compute an overall total as well without the current week criteria. Can you help me with that? Should I remove some of fields in the formula? How?
  19. I want to have a result that will concatenate the Name field if they have the same 'Title' and 'GroupName'. Is that possible using calculations or is there any solution?
  20. Hello, you can also refer to this article for more sql functions: https://howto.caspio.com/function-reference/
  21. That's great, @Barbie. You can use this formula instead: REPLACE(REPLACE(CONVERT(varchar(15), CAST([@field:Date] AS TIME), 100), 'P', ' P'), 'A', ' A') I hope this satisfies your wrkflow now.
  22. Hi @Barbie If you want to have that format, please use the formula below: CASE WHEN CONVERT(VARCHAR, [@field:Date], 108) = '00:00:00' THEN ' ' ELSE CONVERT(VARCHAR,CAST('[@field:Date]' AS TIME),100) END I hope this works now. - Batchini
  23. Kuroshi

    Custom symbol

    how do I put a custom symbol in place of yes/no for a checkbox? I see the custom format but can't figure out how to get a symbol into it?
  24. Is there a way that after a year, I can create a task that will clean my table based on the date field that I have?
  25. Hi. I am trying to find what is the solution for this. I want to be able to calculate the amount assigned to my agent and also deduct the total money owed of this specific agent. Also, I wanted to display the data and compute the data for the current week only. Is this possible using select statement?
  • Create New...