any reason why this condition would be incorrect? ...
# suiteflow
m
any reason why this condition would be incorrect? my WF is running on SO. there is a field on the customer record called Customer Hold 1 with either a Yes or No value - based on this value I which to set a field on the SO. I also tried Customer : Customer Hold 1 = Yes. It's on the Before Record Load trigger.
j
do you have the field ID for the custom field?
try the custom formula and use this - {customer.'custom field ID'} = T
m
As this is a textfield the value I am trying to compare is a 'Yes' - but this also didn't work, nor did entity.custentity_customer_hold_1
j
@mg2017 if the field is a 'yes' or 'no' only, then it is a Boolean field, which needs to be reflected as a T or an F without any quotes.
'Yes' = T and 'No' = F
your fomula should be - {customer.custentity_customer_hold_1} = T
m
But the field is free text
j
Okay then, your formula should work.
may I ask, why is it that this custom field was setup as freeform text? seems to me that a customer hold field should be boolean
If the WF is not working, and that is the formula you are using, there is most likely something wrong with something elsewhere in the WF
m
the field was previously setup just to show if a customer was on hold or not - but now we'd like this info on orders with some highlighting hence the inline html field.
j
There is a standard NetSuite field to put a Customer on Hold.
Either way - you can get the field from the Customer Record to display on the SO by having the custom field ont he SO source from the custom field on the Customer Record
m
you mean to create a custom field on the SO and source the field value from the customer record onto the SO? the issue I have is that the field on the customer record is using a saved search and the store value is not checked therefore I cannot get access to this field
j
Hmm, I'm not sure then. Perhaps somebody else might have a solution for you, sorry!
m
no worries, and thanks!
b
Before load can only be used to set fields on create
m
there must be something odd because I can set the value using the formula and the data type of the field is inline html. the bit that doesn't work is when i apply a condition. i now know why that is - the value I am comparing is from the customer record and that field is using a saved search and has the 'store value' unchecked.
therefore - i am not actually retrieving the value from the customer record.