Jump to content


Caspio Ninja
  • Content Count

  • Joined

  • Last visited

  • Days Won


Everything posted by astroboy

  1. You may also check this video tutorial to help you become more familiar with the features that you can use in building your application: https://www.youtube.com/watch?v=TEB-8O0cJZ0 I hope this helps. Cheers!
  2. Hi, For starters, I suggest checking this Ready Made Application from Caspio that might help you in building your application. This is an Online Store application template: https://www.caspio.com/apps/online-store/
  3. Hi there, I have created a workaround to achieve this using a lookup table and triggered actions. Here are my tables: 1. Colors_Select_Table - the table that I use as the data source of my submission form 2. Colors_Lookup - the lookup table that I use as the data source of the drop down field On the Colors_Select_Table, I created a triggered action that deletes the selected color on the lookup table upon insert using the submission form. Here's a screenshot: You may check the actual DataPage using this link: https://c6cmr431.caspio.com/dp/0eee700069a0
  4. Hello @drmt1979, one possible way that I can think of to achieve this is to create a Triggered Action that will stamp the status of the entry as 'completed' upon submit and then you may create a view to filter out the users that have not completed the form based on the status field. You may check the following articles for reference: Triggered Actions - https://howto.caspio.com/tables-and-views/triggered-actions/ View - https://howto.caspio.com/tables-and-views/what-are-views/ I hope this helps. Cheers!
  5. Hello @ServiceBreez, I'm not sure if I fully understood the workflow that you are going for but I think using Rules in your DataPage might help. You may check this article for more information about Rules: https://howto.caspio.com/datapages/forms/conditional-forms/ Cheers!
  6. Hi @JKSGT, I'm not sure if there's a workaround to do this using the standard features but I was able to find this JavaScript discussion about this customization that might be helpful for you to achieve this on your DataPages. You may check the thread here: https://stackoverflow.com/questions/49643120/how-to-disable-previous-dates-in-calendar-javascript Cheers!
  7. Hi there, I hope I'm not too late but here's a HowTo article that I've found that might help in achieving the feature to dynamically add options to dropdown fields. You may check it using this link: https://howto.caspio.com/tech-tips-and-articles/advanced-customizations/automatically-add-options-to-dropdowns-and-listboxes/ Cheers!
  8. Hello @Vilho, Have you already tried clearing your browser's cache to see if that resolves the issue? If not, I suggest doing that to test if the issue is caused by the cache of your browsers. I hope this helps. Cheers!
  9. Hello @ChristopherNORD, I'm not sure if you have considered this already, but did you know that you can modify the timestamp field to also run On Update and not only On Insert? If not, you may want to give this a try and see if that can help achieve this workflow. You can configure your timestamp field by going to your table design and then select the field and check the 'Stamp On Update' checkbox from the right panel of the screen. You may check this screenshot for reference: I hope this helps. Cheers!
  10. Hello princezuko, If the rich text editor is enabled for your text area, the HTML editor is also enabled by default which means that it is auto-fixing the values that you enter. Luckily, I discovered a way to avoid the unnecessary special characters from being saved to your table. Here's how: 1. In your text area, click paste as plain text: 2. Enter the values that you would like to submit from the pop-up window: 3. Click 'OK' and the submitted record will be interpreted on the table as it is.
  11. Hello there, You might want to check your authentication configurations, specifically the 'Timeout and Redirection' and see if you have anything set there that might be causing this issue. You may check this HowTo article for more information: https://howto.caspio.com/authentications-and-connections/authentication/ If this is an isolated case, you may try clearing your browser's cache and see if that works. You may also try to access the DataPage using another browser. I hope this helps. Cheers!
  12. Hi there, I'm not sure how to achieve this using Caspio's standard feature but I've found this JavaScript code that might help you achieve this workflow or at least give you an idea that you can work on. You may check it from this link: https://stackoverflow.com/questions/6060003/removing-an-item-from-a-dropdown-when-selected-in-another-dropdown I hope this helps. Cheers!
  13. Hello there, Records that were submitted using your DataPages made in Caspio will be saved in your table inside your Caspio account. If you want your data to be also saved to your local computer, you may consider exporting your tables. You can check this HowTo article to know more about Exporting Data: https://howto.caspio.com/tables-and-views/exporting-data/ To be honest, I'm kinda confused with your question but I hope this helps. Cheers!
  14. Hello there, I think the closest option to achieve this using Caspio's standard feature is to apply Rules on your DataPages. You may check this HowTo article to know more about Rules and Conditional forms: https://howto.caspio.com/datapages/forms/conditional-forms/ I hope this helps.
  15. This works! But I have another question. I noticed that it is calculating the percent contribution to the entire table but I only want to calculate the percentage for the displayed data which is being filtered by another field, say a company name.
  16. Hello, I would like to create a formula/calculation that will allow me to show what percentage each record into a field contributes to the total sum of that field. Is that possible in Caspio?
  17. I tried to move the title of a chart from middle to left using Styles and CSS but no luck. Is there a workaround to do this?
  18. I have a virtual field that is set as a checkbox and virtual field for the button. If the checkbox is not checked it will hide the virtual field which has the button in it. How do I achieve this inside the DataPage?
  19. I am trying to concatenate my text field and date and time field in calculated field, however, the format of my date and time field has additional 0's at the end of the time. Is there a way to avoid this from happening?
  20. I just started creating my DataPage and I would love to see a logo on top of it. Is there a way to upload an image directly in Caspio and use it on my DataPages?
  21. Can you help me with the formula? I have a field for hired date and end date and I want to display the duration that the employee is with the company. Here's the example result: 1 Year(s) 2 month(s) 26 day(s)
  22. I would like to duplicate a table from one app to another. However, I don't want them to be a shared table. Is there a way to do this?
  23. I'm trying to export files using task but I'm receiving an error that says, "Could not export the file because it has exceeded the limit of 50 MB.". Is there another workaround here?
  24. I'm trying to create a syntax that will count the number of records that are not blank in one particular field. Is there anyway to do this using calculated fields?
  25. I would like to create a scheduled task that runs every 15 mins. However, I can see that 'Hourly' is the lowest frequency available aside from 'Once' and 'On demand'. Is there a possible workaround for this?
  • Create New...