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

  • 0
  • 1
  • Question
  • Updated 6 months ago
  • (Edited)


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.
Photo of Vivek Vishwanath

Vivek Vishwanath

  • 474 Points 250 badge 2x thumb

Posted 6 months ago

  • 0
  • 1

Be the first to post a reply!