Number Validation on Columns Total?

  • Hi Adrian,

    I’d like to find out if there’s a way to trigger a validation (preferably realtime) on the number column total?

    My scenario: My number column will represent percentages, and the column total should add up to 100. Any less or more should display a subtle validation message to the fact.

    Hope you could help!

    Cheers,
    Phil

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author ovann86

    (@ovann86)

    Hi Phil,

    I can’t reply with detail right now, but should be able to in the next day or so.

    I would be looking to build two custom validations – JavaScript for front end, then PHP to check on paging/submission (as a just in case).

    The PHP one you may be able to instead pre-fill the column total to a hidden field and set the max to 100 — but it’s been so long since I’ve touched this I can’t remember what it can do ! (i think it can do this though).

    I’ll have a closer look on the weekend.

    Thread Starter Phil Meyer

    (@philmeyer)

    Hi Adrian,

    Thanks a bunch for replying, much appreciated. I look forward to hearing from you on/after the weekend, if you’re able to check it out.

    I had another thought, but don’t break your head on this:

    It would have been great to also be able to use the column total in conditional arguments, such as (in my specific case) to not show the “Next” button in the form page footer if that total is not exactly 100.

    Anyway, I appreciate any input.

    Cheers,
    Phil

    Thread Starter Phil Meyer

    (@philmeyer)

    Hi Adrian,

    Just following up to see if you’ve by any chance managed to take a look at this?

    I was also wondering whether it would be possible for the column total to be referenced by other fields (e.g. setting another field’s default value according to the list column total field).

    Cheers,
    Phil

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Number Validation on Columns Total?’ is closed to new replies.