I'm creating a department approval workflow and ru...
# general
r
I'm creating a department approval workflow and running into what looks like either a NetSuite bug or functionality gap. I need to make sure the user is able to be forced to fill in a 'rejection note' field, if they clicker rejection button. On most record types you are able to use the 'go-to record' , workflow action . However, on department's classes and locations, those records are excluded from the list of record types you can go to . I would create a client script but those records are also exempt from creating client scripts for in NetSuite . So as a work around, I've created a user event script that creates a custom record when the department is created . The UE script creates a custom record with a link back to the department record in EDIT context. The UE also populates a field on the department with the corresponding custom record. That is housing the link . That part is all working fine , but when using "go to record " , action in the department approval workflow and the JOIN using the field with the custom records ID , it just redirects to a blank custom record of the same type instead of the corresponding one with the ID reference in the JOIN field. Can't think of another way to force the user to EDIT the record if they so they are forced to fill in the 'rejection note' field.... Has anyone dealt with this with department class or record types and workflows associated with those records?
p
What type of transaction is getting rejected?
m
I’m confused on your process. Is the workflow running on the Department record or on a custom record?
@Pete Kastner I think they are trying to approve the creation of a new Department in the standard departments list. But not 100% sure
r
That is exactly it. The workflow is on the department record itself
But because of the restriction with the record type, I cannot just use the go to record action in edit mode. So I've been trying to use the work around with a custom record that I could go to from the department workflow
m
Ok and you want to use the go to record action to go to a custom record when they click reject?
r
That's it and I've set up the custom record with a hyperlink field that auto fills with a link to the department record + &e=t
m
When does the custom record get created? It sounds like it happens via your script when the department record is created
r
So I select that field in the go-to record action while joining with the ID, which is also on the department record. However, using go to record, sends to a blank page and doesn't join the ID
m
Set Redirect ID in the “Field” field. Not the Record (Join Field) field
Also by adding EDIT content URL to the fields Sublist you are trying to set the value of that field to NULL when the user is redirected to the record
Is that what you want?
r
That was it! Thank you so much @MGBC for the extra set of eyes
m
👍