When setting up a Workflow, you will first need to set up a trigger event to determine when the Action will run. For a list of Trigger Events see our article here: Workflow Trigger Events.
There are a variety of scenarios where you will benefit from automation the linking of Child and Parent Records via workflow. We offer four different methods to help you to keep appropriate Record hierarchies.
Link Child Records
This action will look for all Child records that match a given filter criteria and link these Records to the Parent Record that the Workflow was triggered from.
To demonstrate this workflow we will look at an example of linking Contacts to a Supplier when a new Supplier Record is created. In this scenario, a number of Contacts have already been created and then a Parent Supplier App has been added that associates these Contacts to a Supplier.
First select 'Update Record' as the Action and 'Link Child Records' as the Result.
Next select the Child App that you would like the Parent Record to find it's Child Records from. For our example we are adding the Workflow to the Supplier App and are Target App to find Child Contact Records to Link is the Contact App.
Then you will need to add the filter criteria that decides which Child Records are going to Link to the Parent. Click on the filter icon in the right of the box for the Target App Filter and it will pop up a message to give you a warning that you are overwriting the existing filter. Confirm that this is what you would like to do and it will open a filter pane where you can add your link criteria.
There should be one Filter criteria that can be used as a match of values so the Parent Record knows which Children to Link. In this case we click 'Add A Filter' and in the first drop down we select a Field from the Child Contacts App (Supplier). Next we select the logic that this value needs to equal a Trigger App Field which means it needs to match a value in a Field from our Parent Supplier App that is triggering the Workflow. We have selected the Supplier Field in the Parent Supplier App for the value to match to. You can add additional filter criteria if you need to. Once you have completed this click on the tick in the top right of the pane and it will add your filter.
Note: If no Target App Filter has been set then the workflow will link all child records.
Now that we have set this up, when a User adds a Supplier Record, it will look for all Contact Records where the Supplier Name matches and link those to the new Supplier
An additional option is to Ignore Access Rights. By selecting this it will mean that the User triggering the Event on the Supplier Record will not need access to the Contact Record in order for the Link to occur. If it is not selected then a Child Record will only link to a Parent Record if the User triggering the Workflow has Full Access to the Child Record.
Note: If no Target App Filter has been set then the workflow will link all child records.
Copy and Link Child Records
This Workflow Action is similar to the Link Child Records Workflow but will make a Copy of the Child record to link to the Parent instead of Linking the original Record it finds in the Link filter.
A common use for this Workflow is to Copy and Link a set of master Child Question Records to a Parent Assessment on creation of the Assessment.
First select 'Update Record' as the Action and 'Copy & Link Child Records' as the Result.
Next select the Child App that you would like the Parent Record to copy and link Child Records from. We are adding the Workflow to the Assessment App and our Target App is the Question App to copy and link Child Question Records.
Then you will need to add the filter criteria that decides which Child Records are going to be copied and Linked to the Parent. Click on the filter icon in the right of the box for the Target App Filter and it will pop up a message to give you a warning that you are overwriting the existing filter. Confirm that this is what you would like to do and it will open a filter pane where you can add your link criteria.
In our example we our only copying from a master set of Child Questions so our first filter criteria would be to narrow down the selection by this. Click on Add A Filter, then select a Field from the Child App with the logic and value this Field must meet. We have selected that the Field 'Is Master?' in the Question App needs to be true. We can also filter down further by saying that a Field in the Child App needs to match a value from the Parent App. Select the Field from the Child App, then the logic and that it needs to match a value in a Field form the Trigger App which is the Parent Record causing the workflow. Our example says that the Assessment Area on the Question Record needs to match the Area stated on the Parent Assessment record. Once you have completed this click on the tick in the top right of the pane and it will add your filter.
Note: When copying and linking records from a master list of records it is important to not let the copied records join the master set. We can make use of a Template Copy which can exclude certain Field values from the Record copy to keep the master list clean. Here we would set a property on the Field 'Is Master?' to be 'Exclude from templated record copy' and it will not copy the value of true but set it to false on copy of the Question.
Note: If no Target App Filter has been set then the workflow will copy and link all child records.
Now that we have set this up, when a User adds a new Assessment record, it will look for all the Master Questions in the Assessment Area chosen and copy and link that set of Child Questions to the Parent Assessment.
An additional option is to Ignore Access Rights. By selecting this it will mean that the User triggering the Event on the Assessment will not need access to the Question Records in order for the Link to occur. If it is not selected then a Child Record will only link to a Parent Record if the User triggering the Workflow has Full Access to the Child Records.
There are some further options that can determine the type of Record copy that is performed.
Templated Copy? For each Field in an App you can set a property on the Field to 'Exclude This Field From Templated Record Copies' If this property has been set for the certain Fields and you choose to use a Templated Copy, it will not copy the values from these Fields when it copies the Record.
Copy Notes / Comments / Attachments / History? These options provide you with a more granular choice of the Record copy that you would like. Notes will copy values from Notes Fields. Attachments and Comments will copy any that have been added to these areas of the Record. History will copy the Audit Trail for the Record, by not selecting this it will start the Audit Trail from the point the Record is Copied.
You can also choose to bring back a set number of Child records at Random from those that meet the Target App Filter criteria. To do this select 'Is Random?' and then choose the number of Child Records that you would like to be copied and linked.
Link To Parent Record
This is a feature that can be used when creating or updating Child records outside of the context of the Parent Record. Our example here will be creating a new Child Invoice and linking it to a Parent Client Record.
Create a new Workflow action and set 'Update Record' as the Action and 'Link To Parent Record' as the Result.
Note: The Link To Parent Record option will only appear if you are adding the Workflow to a Child App.
Next select the App that you would like the Child Records to find a Parent to link to. In our example we are adding the Workflow to the Invoice App and are Target App to find a Parent to Link to is the Client App.
Then you will need to add the filter criteria that decides which Parent the Child is going to link to. Click on the filter icon in the right of the box for the Target App Filter and it will pop up a message to give you a warning that you are overwriting the existing filter. Confirm that this is what you would like to do and it will open a filter pane where you can add your link criteria.
There should be one Filter criteria that can be used as a match of values so the Child record knows which Parent to link to. In this case we click 'Add A Filter' and in the first drop down we select a Field from the Parent Client App (ClientID). Next we select the logic that this value needs to equal a Trigger App Field which means it needs to match a value in a Field from our Child Invoice App that is triggering the Workflow. We have selected the Client ID Field in the Child Invoice App for the value to match to. You can add additional filter criteria if you need to. Once you have completed this click on the tick in the top right of the pane and it will add your filter.
What this now means is that a User can create an Invoice and enter the Client ID that it relates to. The workflow will then find the Parent Client record that has that Client ID and link the Invoice to it.
An additional option is to Ignore Access Rights. By selecting this it will mean that the User triggering the Event on the Invoice will not need access to the Client record in order for the Link to occur. If it is not selected then a Child Record will only link to a Parent Record if the User triggering the Workflow has Full Access to the Parent Record.
If we want this workflow to also run every time the Client ID is updated in case it changes on the Invoice, then we could add this workflow again with a Field Updated trigger.
Note: If more than one Parent Record matches the filter criteria then the Child Record will link to the first Parent Record that it finds. A Child Record can only have one Parent Record
Comments
0 comments
Article is closed for comments.