Hi everyone, how are you ? please help me with t...
# suitescript
a
Hi everyone, how are you ? please help me with these, Currently, I have two custom records in NetSuite:
customrecordbea_sp_orden_de_cambio
(header) and
customrecordbea_sp_orden_de_cambio_det
(detail). In the header, there is a field
custrecordbea_sp_oc_proyecto
that stores the project associated with the Change Order. In the detail, each line is linked to the header through the field
custrecordbea_sp_oc_orden_cambio
, which is a List/Record of the Change Order and has the "Is Parent" option enabled. Additionally, in the detail, I have a field
custrecordbea_sp_oc_proyecto_st
, which is a List/Record of type "Project" and should be automatically populated with the project from the header to allow filtering of tasks. However, even though I have configured "Sourcing & Filtering" on the
custrecordbea_sp_oc_proyecto_st
field, it is not automatically populating with the project from the header. As a result, the
custrecordbea_sp_oc_tareas
field, which is a List/Record of "Project Task," is not filtering correctly to display only the tasks related to the associated project. How can I ensure that the "Project" field in the detail is automatically populated and that the "Tasks" field only displays tasks related to the project from the header?
a
This is in the UI? I think the sourcing of the project field from the parent to the child will only happen when record is saved, not while they are in the UI editing the parent record. you'll need something client side like a client script to populate the project field on the child lines probably want it to trigger on fieldChanged of the parent project field, and then loop thru the child lines to set that project value on each line
thanks 1
🙏 1