Ability to have calculated fields on a view.
In SQL I can create calculated fields for a view it would be nice to be able to do that same thing in Caspio view.
Thank you for this idea. We are looking into adding this feature in future product updates.
Come on guys! This is an absolute must have: why are you taking so long to release this?
You pitch yourselves as a platform where you can "say goodbye to outdated legacy systems and start building modern cloud applications with ease", yet it's still impossible to do something as basic as calculate the number of days between a date and the system date in either a table or a view!
I have an access database I would love to move to the cloud, but it's just not possible until this becomes a feature!
Please please please can we have this. At the moment, my only option is to extract to Excel and do a simple calc there. Which defeats the whole purpose of a properly normalised database.
Its been more that 7 years!
Caspio views needs a check box for "distinct", which is the key word in SQL Select that eliminates duplicate records created when 2 tables are joined with inner and outer joins. This is essential.
it would be extremely helpful to be able to use authentification fields as criteria in the View builder. A good view builder could make a great data filter. Views built with other views as the source could do almost anything and eliminate some of the confusion created by too many options and complexity in the Datapage builders.
Not having this is a huge setback. Looks like this feature was planned in Oct, 2017. It is now May, 2020. Can we get an update on a realistic ETA for this?
Wow, just spent ages creating my view and getting everything set up properly, just to find I can't use it in a calculated field!! Aaaargh! Definitely need this ... need to rethink my whole setup now,.
Douglas Vega commented
I would be also useful to create lookup lists, for example I have Users and Roles tables. In a Datapage, I would like to have a Dropdown showing something like "User Name (Role)" but that is not possible, having calculated or formula fields would solve this situation.
life would be so much easier with that.
Roman Dirks commented
This Idea is 4 years ago and it is still a must =(
This would be very useful to run queries base on these calculated fields or send email based on certain conditions that are met.
Greg Griffin commented
So how many votes does something need to get before it is being engineered and put in the Caspio roadmap? Just curious.
This is actually critical to produce a meaningful report metric... I need the min, max and average of something (e.g. average number of students signed up for classes grouped by location/state), then I can produce a report which shows each class attendance and how it compares to the average within the given group (e.g. how each class within a state compares to the average in the state - higher or lower).
Greg Griffin commented
This would solve my problem right now. As it is, I will have to split a table, create multiple Datapages, have a more complicated form and process....all because I can't create a new field and have it be the calculation from a view. :( When I'm asked why I did it that way, the answer will be because of this limitation
If only I had some available votes! This is a Must... It would save so much time and aggravation.
Jan H commented
Calculated fields in views shoud have been an obvious feature. Alternatively, there could be a feature for creating views "from scratch" in some kind of a "SQL-bulider". I suggest a feature something like the MS Query built into Excel, where you ca build a query, and then later edit the SQL with joins, criterias, calulations, headings, formats and so on.
Yes please! we definitely need this option. that would be most helpful.
I have a question about calculated fields. In one of our reports, when the search is done and the results are displayed... On the results page we want to run a specific calculation, but we are not sure how to do it.
ID Name Address Match
1 Susy ....... 3
2 John ........ 11
3 Joe ........ 1
This is similar to how our information is returned on the results page of our report. However, we would like to run a calculated field that would take the value of the "Match" field, search for the same value in the table under ID and return the name in the place of the number. Such that the results would look like this:
ID Name Address Match
1 Susy ....... Joe
2 John ........ Sally
3 Joe ........ Susy
I tried using the following code in Caspio but it failed.
SELECT ([Full_Name]) FROM [Contacts] WHERE [@field:Contact_ID]=[@field:Match]
Henry Coleman commented
This would be incredibly useful, especially if these fields would then be available in data pages so that we can search on the values.