Forum Discussion

brian_s's avatar
brian_s
Qrew Trainee
15 days ago

Question about the limitation of formula fields and dynamic rules.

I have a form that uses dynamic rules to show fields based on a selection from a location box.  This is working as expected.

I added an additional layer where if I chose a GERMAN location, an additional field would pop up above the field with the German translation of the English field label. 

I made the translated field a formula fields with no actual formula so it was literally just a label. Once I set up my rules, I found I got a form error stating that there was a limitation of formula fields with dynamic rules. I believe this limitation was 40 and I had 53 (and needed about 10 more)

I made some changes and the error is gone, but I also have no translations. I started fiddling around and found that I didn't need to use a text formula, and I could use just TEXT and make it read only and it would only show the label.

Does anyone know if this will allow me bypass the limitation on dynamic rules? I am pretty sure the error specifically mentioned formula fields in the limitation, but I wanted to try to confirm before I recreate 50+ fields. 

Thanks. 

Brian

 

 

 

 

 

Forms
  • DonLarson's avatar
    DonLarson
    Qrew Elite
    14 days ago

    Brian,

    I am not sure about the outer limits of the forms.  The real expert on form construction is MarkShnier__You 

    Here is another way to solve this without any form rules.   You will need three fields per piece of data

    EnglishOne    Has the English in it.

    GermanOne   German Translation

    FormulaTextOne

    If([GermanLocation]='true', $GermanOne, $EnglishOne)

    On your form in View Mode, you use the Formula Fields.  When you set a German Location, the formula field will show the translation on your form.   This method also lets you have an infinite number of fields.  As the business case expands, create three fields and add to the form.