Jump to content
  • 0

Limit to Calculated Fields Per Datapage


spearheading
 Share

Question

Is there a limit placed on the number of calculated fields that you can use in a single datapage?

After inserting my 10th calculated field, 'calculated field' disappears from the Caspio dropdown of insert options, leaving only 'New Section', 'HTML Block', 'Virtual Field',' Header and Footer' and 'Captcha'.

When I remove one of the previously inserted Calculated Fields, reducing the total inserted to 9, the option 'Calculated Field' appears again on the dropdown.

I can't see any reference to this on the Caspio info on Calculated fields but maybe I've missed something.

Link to comment
Share on other sites

6 answers to this question

Recommended Posts

  • 0

I'm looking to see if there is a limit but I don't think there is (will get back to you). In the meantime enter your 10 then start a new section and see if the option re-appears. If so, re-organize your datapage into sections and group your calculated fields accordingly. Let us know if this worked and I'll get back to you with more info asap...../RA

Link to comment
Share on other sites

  • 0

Thanks Ruth,

I've just received a reply from Caspio support, as follows:

'Yes, there is a limit of 10 Calculated fields in Caspio bridge. This limit is set due to some performance concerns. There is a Feature request submitted to our Engineering team to increase the number of Calculated Fields. You may also request for enhancement to this functionality here:

http://ideabox.caspio.com/forums/164206-caspio-bridge'

Unfortunately, I have to say that I'm disappointed on two fronts. One is that I can't easily do what I had thought was straightforward. The other is that there is no mention of this limitation - as far as I can see - anywhere in the 'How To' manuals.

In my opinion, being able to put calculated fields in when you need them should not be an 'enhancement' but part of the standard offering.

Sorry for the rant (I actually really like Caspio) but I spent a lot of time worrying that I had done something wrong when, in fact, I hadn't...

Link to comment
Share on other sites

  • 0

I totally understand and have been there many times...and, as a result I know many ways around these road-blocks. Try the section thing anyway. If that doesn't work, create multiple forms and sync them together with by depoyment, conditional form or other features. I can help if you need it. Give me more detail, in another post, of your project (if you can generally) or email me directly at setupyoursite@yahoo.com..../RA

Link to comment
Share on other sites

  • 0

Hello,

Just wanted to inform you about the new feature in Caspio.
Check this documentation in Caspio’s Help center: https://howto.caspio.com/release-notes/caspio-bridge-13-0/
This release includes a new feature of Calculated value in submission form option that allows you to use a calculated field in one of your field that is saved in your table. 
However, this feature only available in the ‘Submission DataPage’.
You can also check this documentation about calculated value: https://howto.caspio.com/datapages/datapage-components/calculated-values/ 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...