locked
Repeating Table validation problem RRS feed

  • Question


  • I am struggling with one problem. 

    Field X is a form field and lets suppose user enters 200 in it.

    I have a repeating table with 5 columns one of them is Y, i have to validate that user should enter value in Y greater then 200  in first repeating table row.

    How can i do that ? 




    • Changed type Mike Walsh FIN Saturday, October 31, 2009 11:00 AM question
    Friday, October 30, 2009 4:26 PM

Answers

  • Hi Alvin,

    Follow the steps below,

    Select field Y of your repeating table and add data validation as follows

    If Field x  is greater then Field Y   AND
    count(//my:group2) = 1   THEN

    Show this error alert:............



    Ashraf ul Islam
    Sharepoint Consultant
    • Proposed as answer by alvin1985 Monday, November 2, 2009 9:54 AM
    • Marked as answer by Lu Zou-MSFT Tuesday, November 3, 2009 8:40 AM
    Monday, November 2, 2009 2:13 AM

All replies

  • 1. Create numerical field. Let's call it Field1. Set it to 0.
    2. Add addional numerical field to repeating table. Let's call it RepField1. Set it to 0.
    3. In repeating table properties add rule that contains two actions. First action should set RepField1=Field1+1. Second action should set Field1=RepField1.
    4. Let's call field that is needed to be validated ValField1. Go to it's properties, validation tab. Add condtion there, like this: if your ValField1 is less then 200 AND if RepField1 equals to 0 or whatever row you need to validate.
    5. Enter message you want to be displayed on validation fail.
    6. You can hide this RepField1's control from the table or disable it.
    Friday, October 30, 2009 8:07 PM
  • Thanks for reply

    I just want to check it on first repeating table row only. Thanks


    Saturday, October 31, 2009 6:56 AM
  • Hi Alvin,

    Follow the steps below,

    Select field Y of your repeating table and add data validation as follows

    If Field x  is greater then Field Y   AND
    count(//my:group2) = 1   THEN

    Show this error alert:............



    Ashraf ul Islam
    Sharepoint Consultant
    • Proposed as answer by alvin1985 Monday, November 2, 2009 9:54 AM
    • Marked as answer by Lu Zou-MSFT Tuesday, November 3, 2009 8:40 AM
    Monday, November 2, 2009 2:13 AM
  • Brilliant, Thanks Ashraf. 




    Monday, November 2, 2009 9:55 AM