Prevent a subsequent task from being marked as completed when a Predecessor task has not been completed.

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

Is there any technique for flagging completed tasks when the predecessor task have not yet been completed?  or to prevent a subsequent task as being marked as completed when the Predecessor has not been completed.

Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 69,904 Points 50k badge 2x thumb

Posted 4 years ago

  • 0
  • 1
Photo of Jack

Jack, Champion

  • 50 Points
Yes there is a way.

Firstly create a formula numeric field called Predecessor Link with the formula ToNumber([Predecessor Field Name])

Then create a table to table relationship linking the table to itself using Predecessor link as the reference field.

Pull through any fields you like via the relationship and use this as the basis to drive a form rule to prevent the action you mentioned in your post above.