Hi all, I'm looking to filter a select field in a ...
# general
l
Hi all, I'm looking to filter a select field in a sublist once another field in the sublist has been changed. The field I'm looking to filter is a standard NetSuite field. Does anyone know if this is possible? This would be for a Journal Entry. Once the Account has been selected on the line, I would be looking to filter the Name field to show only customers or only suppliers. Thanks
b
i would say no based only on the mutlselect on a sublist part
you cant make a custom transaction line field a multiselect
a
Hi Imason, do you mean a dependent drop down ,i.e. You select Coke in one field and get Coke, Diet coke , Zero in another. IF so, it is pretty standard albeit a bit fiddly.
l
Hi, it's specifically for a journal record. Once the Account field in the sublist has been selected, I would be looking to filter the options in the Name field (to display either Customers or Suppliers). I am unsure if this would be possible though
a
This sounds more of a script to me but just to check what is the use case here. Isnt that standard?
message has been deleted
b
in general i would say nope, sourcing and filtering options are only available for custom fields
and suitescript can only control the select options of fields added through script
a
If needed, you could create a custom field and filter it as required and then have the script copy the value to ‘Name’ field which would otherwise be hidden. Bit of a sledgehammer if you ask me.
l
I've tried adding a custom field through scripting, however seem to be unable to apply the filters through the Client Script once the field has been changed
k
This will have to be a field that natively exists, not a scripted custom field
I would be more inclined to add a line validation script so that if they pick an invalid value it returns an error instead of trying the drop down control
Will work better with CSV imports/etc.
l
Ok will do, thank you!