Jump to content

Jess147

Members
  • Content Count

    15
  • Joined

  • Last visited

Reputation Activity

  1. Thanks
    Jess147 reacted to JolliBeng in Input Time   
    Hi @Role21,
    Yes, Caspio does not have a time picker option. What you can do is separate the input fields for your date and time fields. That will require some javaScript, you may refer to this Tech Tip for more details.
    You may also check this sample Time Sheet Web Form.
     
    -JolliBeng
  2. Thanks
    Jess147 reacted to Harbinger in Totals   
    Hi @Jess147, First off, I would suggest using a triggered action in your main table to calculate the total of the column, then send the value to another field from the table where you will insert the data. To do this, you will need to add an INSERT block, select the table where you want to insert the data --> Now set the field that will contain the total calculation and send to another field that will receive the value to the selected table.
    Here's the screen capture of my sample triggered action.

     
    I hope this helps.
     
    ~ H
  3. Thanks
    Jess147 reacted to JolliBeng in Totals   
    Hi @Jess147,

    You can achieve that workflow using triggered actions. But first, the records that needs to be calculated should be saved on your table. I suggest that you use Formula fields for calculations or directly calculate it under your triggered actions.

    You may refer to the following links:

    https://howto.caspio.com/tables-and-views/data-types/formula-fields/

    https://howto.caspio.com/tables-and-views/triggered-actions/

    -JolliBeng
  4. Thanks
    Jess147 reacted to JolliBeng in Submission   
    Hi @Jess147,
    You can achieve that using Cascading Elements.
    First, you need to  set your field1 as an AutoComplete field. Filter it by the field on your LookUp table and use Contains.

    Then, set your field2 as a Cascading Dropdown. 
    I hope this helps.
     
    -JolliBeng
  5. Like
    Jess147 reacted to JolliBeng in What should I know about Caspio's free account limitations?   
    Hi overhear,
    Caspio is an online database platform that allows our customers to build customized applications without the requirement of being a programmer or having a background in software development. 
    The important objects that you need to be familiarized with are the following:
    DataPages - these are the various application interfaces that you create in Caspio and deploy to your application portal or website. Examples include web forms, reports, calendars, charts, and more. Some DataPages contain multiple screens, so a simple application may require no more than 3 to 5 DataPages. The limit of deployable DataPages depends on the Caspio plan that you avail. 
    Tables -  these are the ones that hold your data. You can create tables in the Tables area of your App. Data can be submitted into these tables using web forms or imported from external files, such as Excel. Tables can also be exported in various file formats and saved onto your computer. Also, tables only allows a maximum of 255 fields. 
    Authentication - this is used to password-protect your DataPages. 
    Formulas and Calculations - there are different ways on how to perform calculations in Caspio. Formula field - it calculates a value based on other fields in the same table. In the formula field, you create an expression that uses values from fields, constants, or functions. Calculated Values - it is a form element that generates dynamic calculations that automatically update as users interact with your form. Calculated Fields - it allow you to perform dynamic, per-record functions on results and details pages of a Report DataPage. Triggered Actions - allow data manipulation, calculations and sending notifications by constructing application logic with a visual interface. They will be executed on specified events to perform actions on data in your tables.
    I hope the information that I provided helps.
     
    -JolliBeng
  6. Like
    Jess147 reacted to Becca37 in What should I know about Caspio's free account limitations?   
    The thing I find most limiting on the free account is that DataPage limit. Even running into it being an issue on a paid plan due to the number of pages we need.
    A DataPage is a way of displaying or manipulating the data within a table or a view. There's no limit to the number of tables or views or tasks that you have behind the scenes. Just the number of DataPages that are used to expose your data for use.
    Say you have three tables. To create a form to add a record to the first table, well that will take one DataPage. If you want to be able to have your users edit those records they're adding, well, that will take another DataPage. And so on for the other two tables. So there's six pages right there. 
    Other than that lets see ... well, your example of field validation. And this is not free/not-free plan thing, Caspio just has very limited included validations, period. Caspio validates for data type. e.g. if the field in the data table is a number, the DataPage form won't accept alpha characters. It can also check for required input and you can set min characters and max characters. But you'd have to roll (or find) your own javascripts for any other validations or formatting you want done at submit (email addresses, phone number formats, SSN format, etc). 
    Tables and Views are also not what I was personally expecting. Table fields have limited manipulation that can be performed. e.g. you can't pull data in from another table. Even the Views merely join tables in the most basic way and you can't do counts, etc there either. That takes a report DataPage to do the aggregations. Again, I'm just used to much more freedom there.
    DataPages themselves are frustrating for me personally as I constantly bump up against their constraints of "can't do this, can't do that" and sometimes it takes me an hour to track down how to do something that would have taken 2 lines of SQL or C# code.
    All that said, I'm coming from a developer background with 2 decades of designing my own databases, writing queries, stored procedures, etc. and writing the code to get stuff in and out. So I see things here more from a limitation standpoint. But Caspio IS pretty darn powerful in what it can do in a low- to no-code manner, and for the users not used to rolling their own my bet is it's a wonderful beast all around. 
     
  7. Thanks
    Jess147 reacted to JolliBeng in Compute   
    Hi Jess147,
    You can create a Calculated Value for that.
    You can try the following formula:
    CASE 
    WHEN 
    [@field:Amount_Paid] = 1 THEN 5
    WHEN 
    [@field:Amount_Paid] = 2 THEN 20
    WHEN 
    [@field:Amount_Paid] = 3 THEN 35 
    END
     
    You just need to change the field name.
     
    -JolliBeng
×
×
  • Create New...