Forum Discussion

deldridgdeldrid's avatar
deldridgdeldrid
Qrew Trainee
7 years ago

Because [Number of Activities] is a text field, your formula compares the values like it compares text... i.e., in alphabetical order, not numerical order.  Consequently, "1" < "10" < "2" < "3", etc.  You might try creating a new formula-numeric field [Number of Activities - numeric] with the formula

ToNumber([Number of Activities])

and set your dynamic formula rules to use it instead of the [Number of Activities] (text) field.

  • RajHelaiya's avatar
    RajHelaiya
    Qrew Captain
    7 years ago
    Hello, I tried using a fIt still shows activity 1 and activity 10 when number of activities is 10. Doesn't display activity 2 to 9. 
  • deldridgdeldrid's avatar
    deldridgdeldrid
    Qrew Trainee
    7 years ago
    Are you certain you adjusted all of the dynamic form rules to use the new field?  Please show me the formula you used for the new field.
  • RajHelaiya's avatar
    RajHelaiya
    Qrew Captain
    7 years ago
    No of activities is a formula numeric field
  • RajHelaiya's avatar
    RajHelaiya
    Qrew Captain
    7 years ago

  • deldridgdeldrid's avatar
    deldridgdeldrid
    Qrew Trainee
    7 years ago
    Please show me the formula you used for [No of Activities], and also a screenshot of one of the form rules that isn't working... like the one for [Course - No of Activities] >= 3.
  • RajHelaiya's avatar
    RajHelaiya
    Qrew Captain
    7 years ago
    This is the formula I used to convert. It is a formula numeric type. 
  • RajHelaiya's avatar
    RajHelaiya
    Qrew Captain
    7 years ago
  • RajHelaiya's avatar
    RajHelaiya
    Qrew Captain
    7 years ago
    also the dynamic formula mentioned above is the one which is not working
  • deldridgdeldrid's avatar
    deldridgdeldrid
    Qrew Trainee
    7 years ago
    Do your other rules work?  Do they look like these?



    Set up this way, when I have a Course where [Course - Number of Activities] = 4, I see this:

  • deldridgdeldrid's avatar
    deldridgdeldrid
    Qrew Trainee
    7 years ago
    Notice that each field appears in only one rule.  If a field is affected by more than one rule, then the latter rule will "overrule" the earlier one(s).