Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Don’t miss your chance to meet our SuiteGurus—NetSuite Support professionals and subject matter experts with extensive experience in select product areas, including OneWorld, Advanced & Basic Accounting, Supply Chain Management, Receivables & Payables, CRM, Account Administration, and the SuiteCloud Platform. Full Conference attendees can prebook exclusive 30-minute one-on-one sessions for your product questions.
Spots are limited! Register through your Agenda Builder and find SuiteGuru under Agenda Enhancements.
Preventing Overwriting
I'm trying to create an online external form that will update a custom record.
In essence; I'm using a serial number field to link the online form to the custom record to prevent duplication (as they are unique). However, this does not prevent someone from coming along, entering the serial number again (or by entering the serial number wrong) and overwriting existing data in the record.
What I want, is to create a check box called "User Submitted" which will be checked on the first instance someone sends in a form and updates a particular record. In the background, a script will run that uses a search to run through all the records. If the check box is already checked, then it should return an alert or prompt saying that the recorded for that serial number has already been submitted.