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.

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.

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.

Thx for letting me know the approach is viable!

@Manny Pinheiro,Actually to show 6 predecessor statuses I created 6 relationship with same table. My Predecessor columns contains same values as KEY and I lookup base on this: ------------------------------Adam Krzyzanek------------------------------

Adam,I have a similar problem. I am trying to think through if there is a way to use Pipelines to solve this instead of creating more relationships. That way it can scale.Here is my stream of consciousness: A Predecessor goes to Complete,The Pipeline looks for SuccessorsIt checks how many other Predecessors are on that TaskIf they are all Complete, the Pipeline marks a CB on the SuccessorI am not sure if Pipelines can do this but I am going to poke around and see if I can make it work.------------------------------Don LarsonPaasporterWestlake OH------------------------------

How to show Predecessor Status [Lookup field]

QuickBaseCoachD
Qrew Captain
7 years ago
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.
- AdamKrzyzanek
  Qrew Captain
  7 years ago
  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.
- QuickBaseCoachD
  Qrew Captain
  7 years ago
  Thx for letting me know the approach is viable!
  - AdamKrzyzanek
    Qrew Captain
    5 years ago
    @Manny Pinheiro,
    
    Actually to show 6 predecessor statuses I created 6 relationship with same table.
    
    My Predecessor columns contains same values as KEY and I lookup base on this:
    
    ------------------------------
    Adam Krzyzanek
    ------------------------------

Forum Discussion

How to show Predecessor Status [Lookup field]

Related Content

Lookup Field not pulling Data

Pipelines: Lookup newest record?

Lookup Field Not Pulling Data

Lookup multiple items from the same table.

Formula checkbox using manual checkbox and lookup formula