Discussions

 View Only

How to fetch the value of the field from other row?

  • 1.  How to fetch the value of the field from other row?

    Posted 06-08-2018 07:57


    Explanation:

    I have a table, suppose 


    Round            Phase             Field3              Field4
    1                      1                       a
    1                      2                       b
    2                      1                       c
    2                      2                       d

    Here each Round can have many Phases. For example, Round1 has Phase1 and Phase2. Field3 is a Text Field. 


    Condition to be required on Field4:

    • If Phase is 1, then print nothing in the Field4
    • If Phase is not 1, then print the Field3 where phase is 1 while grouping by Round.

    Expected ouput:

    Round            Phase             Field3              Field4
    1                      1                       a
    1                      2                       b                      a
    2                      1                       c
    2                      2                       d                      c


    Is there any way that I can access the value from another row by using IOL or any other method?
    It will be very helpful, If there is any way to access the other rows of the table in the Quickbase.