Anyone know how to write the logic for a workflow ...
# suiteflow
m
Anyone know how to write the logic for a workflow that I'm working on?  I'm trying to keep new inventory items from being saved without any of the three price level fields being blank or $0.  I know the fields needed are the following:
Copy code
{pricing.pricelevel.id}=18
{pricing.pricelevel.id}=20
{pricing.pricelevel.id}=21
I thought about  CASE WHEN but not sure how to finish out the logic. Any help will be greatly appreciated.
k
This cannot be done with a workflow - this would need to be scripted
m
Any suggestions of where I should start or a good site that can give me an overview of scripts for NetSuite?
k
I wouldn't script this as my first foray into scripting - I'd suggest finding a partner.
Or posting on reddit and finding a freelancer who can do it for cheap
or in #C29J6STC6
a
You could probably setup an alert from a saved search or reminder to catch ones that are saved with the wrong pricing. But Kevin is right a workflow can't trigger from the pricing sublist