Consider this scenario.
There is an UpdateRecord() event function in a TLS on the Company. When the Company assigned user is changed (comp_primaryuserid) then all the 'In Progress' opportunities belonging to that company are reassigned to the new company…
This will look at the behaviour of the Values collection. For a more complete discussion see the article The Values() Collection .
Imagine a new field called pers_type has been added to the person table and included to the screen personboxlong. The…
A customer needs to know what particular System Action was used to trigger a Table Level Script.
The big problem facing us in this scenario is that the Values() collection usually used in server side scripts to obtain variables passed in from the browser…
The Values() and FormValues() collections are serverside methods 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…
The Values() collection can be used in all serverside scripts to examine the passed in Values from a form.
Create Scripts
Validate Scripts
Tablelevel Scripts
Workflow Scripts
The Values() collection must always have an argument passed to…
I was asked recently about how to create a log of when data was changed within a particular screen. Now the requirement was focussed on the screen and not on the the record. If we had been interested in whenever data in the record changed then of course…
The SID is the session ID value. The SID may be wanted if you are building a string that represents a hyperlink that will be returned to the browser. The SID after all only is needed for a new web request, we do not actually need it within server side…
I have discussed how the Values collection can be used to correct inbound data in the article " Correcting inbound data using Table Level scripts and Values() collection ." This is a further example of how the Values collection can be used. The code sample…
Occasionally we need to be able to correct data that has been submitted to bring it within tolerance. An example of this maybe where someone has chosen a customer credit limit level that is too high and we need to change this to the maximum allowed value…