Hi - we're creating a set of custom records to tra...
# suiteflow
b
Hi - we're creating a set of custom records to track let's call it a contract. Rec 1 - main record - represents the contract and will be created by script one a sales order is approved. Rec 2 - change record - actions in the change record update one or more fields on the rain record - and once the main record is updated, the flag is set to T on the change record. Change records are manually created and then marked as complete once some manual steps, outside Netsuite, are completed. Once the change record is complete is when the field updates would happen. Can we update the two records by a workflow? I'm thinking no since it's multiple record types and even if we could, it would have to be two workflows and scheduled, not even driven.
m
Yes this would need to be 2 separate workflows
and one can't trigger the other so you could do it on a schedule where the 2 work together to check statuses or something, but everything would be on a schedule (every 30 min at most)
You could get a custom workflow action that can update joined records
lastly, you can use the Subscribe to record action to perform changes on one record based off changes from another
For example, a change record is created from the Main record and you subscribe to the change record
then in the main record workflow you can process transitions or actions based on the change record
it could work for you
b
thank you - some things to think about. Have not worked with the subscribe to record action - I'll play around with it. What do you mean by
you could get a custom workflow action
? Would that be by script?
m
Here's our blog post on subscribe to record if you are interested https://www.mavencloud.tech/blogs/post/subscribe-to-record-action
We have a blog post on almost every workflow action type
here's a real world example of how to use subscribe to record action also https://www.mavencloud.tech/blogs/post/create-a-service-dispatch-module-with-workflows
b
thanks so much!
m
We have also built a custom workflow action that would edit/change joined records https://www.mavencloud.tech/enhanced-workflow-actions
it is a script type you can leverage to make custom acitons within your workflows
b
wow- thanks!