does anyone know if you can trigger a WF on CSV im...
# suiteflown
Nicolas Bean
12/14/2020, 3:31 AMdoes anyone know if you can trigger a WF on CSV import that sets an Employee field to the Employee that is doing the CSV import? I am currently setting the field "Employee" on the transaction (PO) on Entry and it is set to trigger via CSV import right now. Mixed results.
Or if a script might be a better option in this case
n
Netsuite Tragic
12/14/2020, 3:45 AMHave you considered another trigger After Submit? Alternatively could you set the Employee as part of the CSV mapping?
n
Nicolas Bean
12/14/2020, 3:49 AMI could, but I would prefer not... maybe I need to trigger all of this after submit.. hmm
Nicolas Bean
12/14/2020, 3:50 AMIs there an easy way to source the ID of the employee performing the import ?
Nicolas Bean
12/14/2020, 4:00 AMI can probably use the runtime module getCurrentUser and then just put user.id into the field with some trigger (maybe before submit would work in this case)
Nicolas Bean
12/14/2020, 4:00 AMits just that my WF has a bunch of actions on beforeSubmit & afterSubmit already... maybe I want to put it on beforeLoad?
n
Netsuite Tragic
12/14/2020, 4:29 AMcan you include it as one of the existing States?
n
Nicolas Bean
12/14/2020, 5:07 AMits on the "entry" state right now
n
Netsuite Tragic
12/14/2020, 5:14 AMthat's why I'm suggesting to include it in one of your existing States and triggers. Maybe that will remove the mixed results
j
Jono
12/14/2020, 5:59 AMWould this work?
wf triggered: after submit > on create
context: csv import.
Action: Set field value > Created By
n
Nicolas Bean
12/15/2020, 1:40 AMyeah that might work, I'll have to test it out and see if I can make it all sync up
Nicolas Bean
12/15/2020, 1:40 AMI have the feeling I'll have to redo my whole WF
4 Views