More about the Values and FormValues collections

Hints, Tips and Tricks

Technical Hints Tips and Tricks that cover customization and development using Sage CRM. API usage and coding are covered.

More about the Values and FormValues collections

  • Comments 3
  • Likes
This article was updated on 22nd May 2009 to follow the coding convention introduced in Sage CRM 6.2.
The Values() and FormValues() collections are serverside objects that are analogous to the ASP Request.Form() and Request.QueryString() collections. In an ASP page we can see the submitted values of the HTML form by examining the Request.Form() collection:


var strPostCode = Request.Form("addr_postcode");

or the contents of the QueryString using the Request.QueryString() collection


var strSwitchName = Request.QueryString("mode");

The ASP objects like the Request object are not available within the internal COM API of Sage CRM. To access the information passed from the Form we can use either the Values() collection or the FormValues() collection within the serverside code:
  • Create Scripts
  • Validate Scripts
  • TableLevel scripts
  • and Workflow JScript conditions

The Values() collection will allow you to access the data within the fields associated with the EntryBlock (screen) used to build the edit screen for the record. So in editing a company record you would use the CompanyBoxLong screen.

The FormValues() collection will allow you to access the data from within the whole of the HTML form submitted. This means in a screen like the new Company screen when you are actually inserting data to several tables (Company, Person, Address etc) then you can access any of the submitted data. So in an InsertRecord event function of an Company Entity script we could access the submitted address information:

var strPostCode = FormValues("addr_postcode");

The Values collection allows us to do several very clever things for example we can access the QueryString information. Because of this we can even know what the ID of the record being edited is.


Valid = false; 
ErrorStr = Values("key1") ;

Another useful trick is being able to access data that has been delared in fields that have been added to the custom content of the Screens (so not formally part of the Sage CRM screen strcuture and with no corresponding data field in the database). If you add the text

<input name=comp_test value=test>

to the custom content box of the CompanyBoxLong then this value can be accessed in scripts e.g.

var strTestValue = Values("comp_test");

Tablelevel scripts can't access the information in the QueryString. This means if we want to know which record is being updated then we will have to use another method.

Sage CRM provides the internal system variable WhereClause that contains the restriction used to find the record being edited.

The general idea though can be seen from this snippet that could be added to a company tablelevel script UpdateRecord event function.

var myCompany = CRM.FindRecord("company",WhereClause); 
Valid = false; 
ErrorStr = myCompany.comp_companyid;

So we know that we can use the Values() or FormValues() collections to access data passed into Sage CRM but that if we require to access data already in the system we can use the WhereClause to retrieve the data.
  • Hi Jeff,

    How can I get Act value from query string in Validation script ?

    Thanks in Advance


  • You should be able to use Values("act").  e.g.

    Valid = false;

    ErrorStr = Values("act");

  • Sorry to revive an old thread, but would this method allow one to grab and pass values from crm into a custom web form?  For example, we are building a workflow that we want to grab the contact information for the selected company, and pass those values out to a cfm web form.