Skip to main content
Question

Updating predecessors in a pipeline

Forum|alt.badge.img+2

Hi all, 

I am creating templates for our projects that contain a set number of tasks done in a specific order. I want to use a pipeline to create and schedule tasks when a new project is created. I'm running into a roadblock where I can't figure out how to keep the predecessors of the tasks so we can set a start date when the project is created, and it will populate all future task dates. 

I hope that makes sense. The pipeline is working fine to create the tasks, but I can't figure out how to set the predecessors. 

Here is my table structure (simplified):

[TABLE] Template Projects
- Project Name

[TABLE] Template Tasks 
- Task Name
- Duration

[TABLE] Template Project/Tasks Associations
- Related Project
- Related Task
- Predecessors

[TABLE] Project 
- Select Template (Related Template Project)
- Start Date

[TABLE] Tasks
- Related Project
- Task Name
- Duration
- Start Date
- Project Finish
- Predecessors

(Please be kind, I am new to this)

Thanks in advance!

This topic has been closed for replies.

Forum|alt.badge.img+9

In this case are you using the native predecessor field type? 

MarkShnierYou
Forum|alt.badge.img+24

You will need to have the Pipeline call the CopyMasterDetailAPI to create the children.  That's going to be the best way. 

You can use the Make Request Pipeline step. 

Mark Shnier. Your Quickbase Coach
Forum|alt.badge.img+2

Sorry I was off a couple days. Yes, I'm using the native predecessor field. I will check out the CopyMasterDetailAPI and see if I can get that to work. Thank you!!! 

Forum|alt.badge.img+2

OK so I might need some help. The 3 Template tables above are in one app (let's call it the Template App) and the Project and Tasks table is in another (Project App)

I get this error: Quickbase reported an error: 2 : Invalid input : Source record does not exist

Below is the URL I'm using in that request. What could I be doing wrong? I was playing around with the source ID and this is where I ended up...  

https://xxxxxx.quickbase.com/db/table_project_id?
a=API_CopyMasterDetail
&destrid=project_record_id
&sourcerid=template_app_id:template_table_id:template_record_id
&destApp=project_app_id
&sourceApp=template_app_id
&ticket=auth_ticket
&apptoken=app_token

Does this look right? Am I completely off here? 

Terms & ConditionsAccessibility statement