Discussions
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
online Custom Record form script to update sales order
Here's the scenario:
I have a scripted form in the customer center that a user will enter an order number, date, and id. This is saved to a custom record.
I then want to, via scheduled script, update a field on the sales order referenced with a pre-determined value.
The problem I have is I don't want the user to have to enter "Sales Order #" in front of the order number, which seems to be necessary to search for the order in the scheduled script.
One thought was to have two fields in the custom record, one free-form text for the user, and one "calculated" field linking to the transaction. While I can concatenate a string to the text field obviously, it doesn't seem to want to post itself to the link field.