Discussions

Expand all | Collapse all

How to show Predecessor Status [Lookup field]

  • 1.  How to show Predecessor Status [Lookup field]

    Posted 03-08-2019 06:55
    How to show if predecessor is completed or status?
    I have table with structure as below, and I would like to pull data from predecessor to know if already completed.

    So in this case in additional column:
    Recored ID# 1338 with Predecessor 1337 would show that previous task was completed.


    I was looking on forum solution but unfortunately failed (some similar conversation started but no solution)
    I tried to set up Same Table to Table relationship but it does not give me what I want as predecessor field is not unique and I recieve Record ID# as Key field.




  • 2.  RE: How to show Predecessor Status [Lookup field]

    Posted 03-08-2019 12:44
    It appear that you only need to deal with a single predecessor per record.

    Try creating a new field called Predeceesor mirror with a formula value of ToNumber(Predecessor])

    Set up a relationship of the rec Reds with themself and use that field as the refr nice field on the right side of the relationship.

    Then use a combined text summary field to float up the status

    Concert that to text with a new formula field

    ToText[My combined text Summary if the status field])

    Let me know if that works as I�ve never actually tried doing that.

    If that works, then there are variations to handle where you have multiple predecessors.


  • 3.  RE: How to show Predecessor Status [Lookup field]

    Posted 03-21-2019 12:26
    Thank you Champion:)

    Actually, I just showed one but I need up to 6:)
    But with the same logic I made 6 relationships, did "lookup" field and it works:)

    Big thanks for help.


  • 4.  RE: How to show Predecessor Status [Lookup field]

    Posted 03-21-2019 12:32
    Thx for letting me know the approach is viable!