Verified Answers

If an answer to your question is correct, click on "Verify Answer" under the "More" button.  The answer will now appear with a checkmark.  Please be sure to always mark answers that resolve your issue as verified.  Your fellow Community members will appreciate it!  Learn more.

  • State Verified Answer
  • Replies replies
    7
  • Subscribers subscribers
    170
  • Views views
    588
  • Users 0 members are here
  • +1 person also asked this people also asked this
Related
Options

Automatically Copying Field Values in SBM

Mohammad Alsharayri

Hi everyone!

I'm exploring the best approach in SBM to automatically copy the value of certain fields (like 'First Name') into corresponding 'Original Value' fields upon submission in the same table. Any recommendations or best practices for achieving this efficiently? I  was thinking of using JavaScript, but I want to double-check if there is another way to do so.

Thanks in advance for your insights!

Parents

  • Verified Answer

    +1

    I solved it by adding a ModScript:

    var record = Shell.Item(); // Get the current item

    // Get the current value of 'Received Date'
    var receivedDateValue = record.GetFieldValue("Received Date");

    // Copy the 'Received Date' value to 'Received Date Original'
    record.SetFieldValue("Received Date Original", receivedDateValue);

    record.Update(); // Commit the changes to the database

Reply

  • Verified Answer

    +1

    I solved it by adding a ModScript:

    var record = Shell.Item(); // Get the current item

    // Get the current value of 'Received Date'
    var receivedDateValue = record.GetFieldValue("Received Date");

    // Copy the 'Received Date' value to 'Received Date Original'
    record.SetFieldValue("Received Date Original", receivedDateValue);

    record.Update(); // Commit the changes to the database

Children

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
Cookies Preferences
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Business Conduct and Ethics
The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.