JckDY

Hi @telly,
The solution that @SunakoChan provided is correct. You'll need JavaScript coding to prevent submission. For more details, you may also check this forum post:
 
-JolliBeng

Hi Telly,
 You can try this: 
<script type="text/javascript">
document.addEventListener('BeforeFormSubmit', function(event) {
  if (condtion) {
    //result if condition is met
  } else {
   event.preventDefault()
  }
});
</script>

Also, check this helpful link: https://howto.caspio.com/datapages/ajax-loading/  

Hi JckDY, API calls are counted on either using Caspio Bridge Plugin for Microsoft Office or your custom program using APIs to access, edit, insert into Caspio's database tables.Insert other media

Hi JckDY, 
I think the maximum number of Calculated fields that you may have on your Results page is 50.
 
-JolliBeng

Yes, there is a length limit of 10,000.

Hello,
You will use the logout link that is created by Caspio from an Authentication. If you edit an authentication, under the Advanced Options, you can change the logout destination to the desired location.

Hi Everyone!
You can now have Calculated Values on your Web Forms. It is similar to Formula Fields and Calculated Fields, you can construct the calculation using functions, logic, constants, values from other fields and SQL expressions.
 
-JolliBeng

Hi JckDY,
The first step in creating a web-based application is to build a normalized table. Make sure that the tables are well-architected accordingly to the needs of your application. You can click the links below:
Introduction to Table and Table Design  
Data Normalization: https://www.youtube.com/watch?v=oexOYUUyQik    
One-to-Many Relationships: https://www.youtube.com/watch?v=IstAk982ntA  
Many-to-Many Relationships: https://www.youtube.com/watch?v=7D8u6Lb2BKU  
 
Caspio also has training materials that can help you in building your applications.
You may want to visit them: 
https://howto.caspio.com/
https://howto.caspio.com/getting-started/
https://www.youtube.com/CaspioInc
 
-JolliBeng