Field Scripts

From AgileApps Support Wiki
Revision as of 23:32, 4 March 2011 by imported>Aeric (Text replace - 'Setup > Customize > ' to 'Designer > Data & Presentation > ')
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

JavaScript code can be run at these field-level events:

  • On Change: This event happens when a user enters a new value in a field. At this event you can change other fields based on the value a user just entered or change the formatting of the value (such as for a telephone number).
  • On Focus: This event happens when a user moves the focus to a field. At this event you can remind the user what to enter or temporarily change the appearance of the field (set as setting the background color).

See Field Scripting Variables for information on variable syntax.

Compare to Form Scripting and Post Selection JavaScript

Editing Field Scripts

Follow these steps to add or change event scripting for a field:

  1. Click Designer > Data & Presentation > Objects > {object} > Form Layouts
  2. Click the script icon (Script icon.gif) next to a field in the layout
  3. Enter or change the JavaScript in Field On Change Script and/or Field On Focus Script
  4. Click the Save button

Writing Field Scripts

In the HTML document object model (DOM), the current form is named mainForm. For example, the line of code below gets a reference to the current form in the variable named form:

var form = document.mainForm;

You can refer to a field in a form using the name under "Field Name" when you select Designer > Data & Presentation > Objects' > {object} > Fields. For example, the line of code below gets a reference to the firstName field in the variable elem:

var elem = document.mainForm.firstName;

However, you can also use the implicit variable obj to refer to the current field where the event occurred.

Fields have two properties that you can access in code:

  • name: the name of the field
  • value: the value of the field

These examples show using the implicit variable obj with these properties:

alert("Selected field's name: " + obj.name);

alert("Selected field's value: " + obj.value);

Use AJAX and REST to communicate with the platform in JavaScript code.

On Change Examples

In an Opportunity object, calculate a value field based upon a num_users field.

var form = document.mainForm;
if (form.num_users.value != '0')
{
    form.calc_amount.value = form.num_users.value * 20;
}

When a user changes an order, if a discount is given, make sure that approval_required is checked.

var form = document.mainForm;

if (form.discount.value != '0')
{
  form.approval_required.checked = true;
}

When a user enters a first name, capitalize it automatically:

var form = document.mainForm

form test.value = form.test.value.toUpperCase();
// The line above could also be written as:
// obj.value = obj.value.toUpperCase();

When a user changes the job_knowledge_notes field, copy the new value to the dependability_notes field.

document.mainForm.dependability_notes.value = document.mainForm.job_knowledge_notes.value

Display an alert dialog showing the value of a checkbox.

var form = document.mainForm;
var value = form.multicheckbox[0].value;
alert( "Multi Check Box Value is: " + value);

Change the value of text area field based on a variable.

var form = document.mainForm;

if(obj.value == "Record1")
{
    form.multilinetxt1.value = 'First Record';
}
if(obj.value == "Record2")
{
    form.multilinetxt1.value = 'Second Record';
}
else
{
    form.multilinetxt1.value = 'Not first or second record';
}

Change the value of a checkbox field to true when the request amount is large enough.

if(_sdForm[0].request_amount.value > 10000) {
    setCheckboxState(_sdForm, "approval_required", true);
}

On Focus Example

When a user moves the focus to the account name field, remind the user to enter the name capitalized.

var form = document.mainForm;
alert("Please enter the account name in all caps");

Grid Field Scripting

You can run JavaScript code at on change and on focus events in grid fields.

Follow these steps to add event scripting to a grid field:

  1. Click the script icon (Script icon.gif) in the column header of a field in a grid.
  2. Enter the JavaScript in On Change Script and/or On Focus Script.
  3. Click the Save button.

You can refer to these implicit variables in event scripts for grid fields:

  • grid_section: current grid name used as a prefix for field names
  • grid_section_row_id: current row identifier

For example, assume that you have a grid with these field names: full_name, first_name, and last_name. You can create references to these fields with the statements below:

var fullname = eval('document.mainForm.'+grid_section+'full_name');
var firstname = eval('document.mainForm.'+grid_section+'first_name');
var lastname = eval('document.mainForm.'+grid_section+'last_name');

You can then update the full_name field automatically in an on change event script for the first name or last name field with this code:

fullname = firstname.value + ' ' + lastname.value;

Fields that Support Scripting

You can add On Change or On Focus event scripts to any field except the following:

  • Auto Number
  • Component
  • File Attachment
  • Formula
  • Image Attachment
  • Lookup
  • Rich Text Area

Learn More