Maximum Number of Calculated Fields in a DataPage

[princezuko]

I'm trying to create an application that deals with many calculations. Before I start building my app, I would like to know how many calculated fields can I add to a Reports DataPage?

[astroboy]

The answer to your question is 50. You can add up to 50 calculated fields in your Reports DataPage.

Just now, princezuko said:

I'm trying to create an application that deals with many calculations. Before I start building my app, I would like to know how many calculated fields can I add to a Reports DataPage?

 

[princezuko]

Just now, astroboy said:

The answer to your question is 50. You can add up to 50 calculated fields in your Reports DataPage.

 

How about for submission forms, what is the maximum number of calculated values that I can add on the DataPage?

[astroboy]

Just now, princezuko said:

How about for submission forms, what is the maximum number of calculated values that I can add on the DataPage?

Same goes for Report DataPages, you can add up to 50 calculated values.

[astroboy]

If you are also looking for functions, expressions and operators that you can use in Calculated fields, Aggregations, Formula fields, and Calculated value - you may check this HowTo article:

https://howto.caspio.com/function-reference/

[princezuko]

1 minute ago, astroboy said:

If you are also looking for functions, expressions and operators that you can use in Calculated fields, Aggregations, Formula fields, and Calculated value - you may check this HowTo article:

https://howto.caspio.com/function-reference/

That's helpful! Are there other learning materials that I can use as references?

[astroboy]

1 minute ago, princezuko said:

That's helpful! Are there other learning materials that I can use as references?

Yes there are video tutorials that you can to know more about Calculated fields and values. Here are some:

Using Calculated Values in Submission Forms - https://www.youtube.com/watch?v=SoEThdMCZmU
Using SQL Statements in Calculated Fields - https://www.youtube.com/watch?v=15zAruBT3LA
How to Create Formula Fields in Caspio - https://www.youtube.com/watch?v=f59wUm0JV_c

[astroboy]

In addition to this, if you are trying to add formulas on the table level and not on the DataPage, you may utilize using formula fields instead. Here's another HowTo article:

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