Calculations In Sumission Forms

[Parma2015]

HI!

I have posted a number og topics about this earlier, but I will not give in until I have a solution (or a qualified answer).

In a report, you have an option to create a calculated field.

I have used this option to pull values through SQL and display it.

So, If it is working in a report page, why is it so tricky to do the same thing in a submisssion form?

I want to pull a value from a table based on values in other fields in a submission form. Could it be that hard?

Could be that there is a conflict between scripts running in the browser vs those running in the database, but then I like to know. I am not a guru, but I know that in VBA, I could do this in a few minutes.

Please?

[Jan]

Hello Parma2015,

 

I am afraid, I do not have a qualification answer, but I have a proposition

The idea to add a Calculated fields to Web Forms has 36 votes now.

You can vote for the idea, and when many users vote, I believe, this feature will be added.

[Parma2015]

HI!

Now I have voted for this feature. In fact, I spent 3 votes :-)

[Kurumi]

Hi @Parma2015,

Good News!

As of July 12, 2018, Caspio introduced new features which you can find here: https://howto.caspio.com/release-notes/caspio-bridge-13-0/

This release includes a new feature, Calculated Values in Submission Forms.  This allows you to generate calculations which you can use for Submission Forms. 

Check these videos for more information:

 

 

 

[JolliBeng]

Hi!

Just to add more information about the Calculated Values: As of Dec. 6, 2016, 

• Calculated Values can use other Calculated Values in Submission Forms.

You may want to check Caspio Bridge 16.0 to know more details about the current release.

 

-JolliBeng