maximum limit of 20 derived fields | Discussions

Expand all | Collapse all

maximum limit of 20 derived fields

  • 1.  maximum limit of 20 derived fields

     
    Posted 11-12-2014 08:05

    Is there any way to get around this limit?



  • 2.  RE: maximum limit of 20 derived fields

    Posted 11-12-2014 12:35
    There is no way around that limit.  The only option is to carefully review each form rule and see if you can re-write it in a way which does not "use up" a derived field.  A derived field is one which is a formula or a lookup, basically one that is not a simple data entry field.

    In some cases, you may be able to have a more complex formula fieldbut fewer of them use in the form rules.  For example, if a form rule depends on two formula fields, and you can combine those two fields into a single field by formula for the purpose of a form rule.


  • 3.  RE: maximum limit of 20 derived fields

    Top
    Contributor
    Posted 11-12-2014 14:06
    >Is there any way to get around this limit?

    Use script and you will not hit these arbitrary limits.


  • 4.  RE: maximum limit of 20 derived fields

    Posted 02-22-2017 14:12
    Can you provide some examples, or assist in how you processed scripts?


  • 5.  RE: maximum limit of 20 derived fields

    Top
    Contributor
    Posted 02-22-2017 20:57
    Ask a new question and include a description of exactly what behavior you want irrespective of the limitation on the number of derived fields.

    In a nutshell we would use jQuery to detect various events you want to respond to and in reaction to these events emulate in code the user clicking of the section to toggle the visibility:

    $("#sect_s1Header span.sectionTitle").click();

    This approach is the least invasive of the QuickBase code since we are not directly manipulating the visibility of DOM elements but rather emulating user input.

    This approach can detect a much wider set of events then are hardcoded into the QuickBase form rules.


  • 6.  RE: maximum limit of 20 derived fields

     
    Posted 08-04-2017 17:10
    Hi Dan, I'm confident you can help me on a similar issue here :)

    I have two fields on a form, that if changed, need to pop up a message (display message in form rules) and then require a specific field. This needs to happen if either or both fields change. Right now I'm using a webhook to push the current value of the field into another 'check' field, so that when the record is edited next time, the current and 'check' values won't match, causing the form rule to fire. However, I'm running into the max limit on derived fields due to all the other rules the client has in place. I'm happy to provide further info as needed. Thanks in advance Dan!


  • 7.  RE: maximum limit of 20 derived fields

     
    Posted 01-06-2015 17:32
    I don't know how to do that. Can you point me in the right direction? All I'm looking to do is show specific sections when it is a specific task. I have about 15 different scenarios for this.


  • 8.  RE: maximum limit of 20 derived fields

    Top
    Contributor
    Posted 08-07-2017 14:08
    Just to pile on some since you discuss limits, I have put in feedback, yes generic sounding, but specific to the entire QB program.  There are way too many QB imposed limits that don't need to be there.  Please follow this User Feedback link and vote to try and get QB to remove all the arbitrary limits they have imposed.
    https://quickbase.uservoice.com/forums/111823-quick-base-product-feedback/suggestions/20014867-remove-arbitrary-limits-imposed-in-the-software

    Thanks.


  • 9.  RE: maximum limit of 20 derived fields

    Posted 04-10-2018 13:51
    Thanks Neil!  I added votes to that post.

    Here is another User Feedback link to requesting a removal of those pesky derived field limits.
    I wish I could drop more than 3 votes for this idea, because it causes so much additional energy and time in building viable work-arounds!

    https://quickbase.uservoice.com/forums/111823-quick-base-product-feedback/suggestions/5720434-increase-the-number-of-allowed-derived-fields