PLEASE NOTE: These forums are no longer utilized and are provided as an archive for informational purposes only. All support issues will be handled via email using our support ticket system. For more detailed information on this change, please see this blog post.

Duplicate test on calculated field

  1. Hi all,
    i'm trying to make a control on 3 numeric fields in a form, exploiting the calculation function of a fourth numeric field that has to make the sum of the first 3 fileds checking the "No Duplicate" rule.
    Unfortunately it's not working, because, despite the role, the form is send anyway with no errors.
    Is there any chance to make working the role on calculation filed, or some modification i can do?

    Thanks

    Posted 12 years ago on Tuesday May 8, 2012 | Permalink
  2. So you are saying that on each of the 3 number fields you don't want duplicates on those fields or you don't want duplicates on the 4th field or you don't want duplicates on any of the 4 number fields? Can you post a link to your form?

    Posted 12 years ago on Tuesday May 8, 2012 | Permalink
  3. Simply i don't want duplicate in the 4th field (that is an automatic value due the sum of the fields 1 + fields 2 + fields 3)

    Posted 12 years ago on Wednesday May 9, 2012 | Permalink
  4. I did a quick test locally and this worked fine. I entered "2" in each of the three number fields which resulted in "6", then submitted and it went through. Then I did the same thing again and got this: Screenshot

    Are you running the latest versions of WP and GF? Can you post a link to your form?

    Posted 12 years ago on Wednesday May 9, 2012 | Permalink
  5. I made other test...
    If you use little numbers it effectively works.
    2+2+2+2=8 WORK.

    But using large numbers the problem occurs.
    In my case i've:
    Field 1: "150"
    Filed 2: "1259" (corresponding to an hour)
    Filed 3: "2499" (corresponding to an import)
    Filed 4: "05022012" (corresponding to a date)

    Field 5 (SUM): 5.025.920

    The form let me insert this value more than one time...

    So i think it's a bug if it's working for little numbers and not for big ones.

    Posted 12 years ago on Thursday May 10, 2012 | Permalink
  6. Can you export your form and send the XML file to me to rob@rocketgenius.com and reference this post.

    Posted 12 years ago on Thursday May 10, 2012 | Permalink
  7. Sent...

    Thank you.

    Posted 12 years ago on Thursday May 10, 2012 | Permalink
  8. Hi Rob,
    any news for me?

    Posted 12 years ago on Tuesday May 15, 2012 | Permalink
  9. Just emailed you.

    Posted 12 years ago on Tuesday May 15, 2012 | Permalink
  10. Thank you very much!
    Works perfectly.

    Posted 12 years ago on Thursday May 17, 2012 | Permalink
  11. Right on, thanks for letting us know!

    Posted 12 years ago on Thursday May 17, 2012 | Permalink

This topic has been resolved and has been closed to new replies.