Discussions
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
1st script - Need help to update a customer parent field when a child record changes
First time creating a script. Could really use some help. I have included my script below. Thanks in advance for any help!!!
We have a custom entity field called Last Interaction (date field) that we want to update based on: 1) If a child Work Order changes status to either Revenue Released or Work Completed and the Event Date field is populated and newer than what is currently in the Last Interaction field then set Last Interaction to be the Event Date (since it is newer).
The Work Order could either be created with both of these criteria being met and of course, edited at any later date to satisfy the criteria as well. The script will run on the Work Order record on the afterSubmit operation type. I plan on doing another script for Events but that one will be easier and almost the same, once I get this one figured out.