How to show Predecessor Status [Lookup field]

  • 0
  • 1
  • Question
  • Updated 4 weeks ago
  • Answered
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.


Photo of Adam Krzyzanek

Adam Krzyzanek

  • 266 Points 250 badge 2x thumb
  • Challenged

Posted 1 month ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb
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.
Photo of Adam Krzyzanek

Adam Krzyzanek

  • 266 Points 250 badge 2x thumb
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.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb
Thx for letting me know the approach is viable!