General

Re: Automatic field insert

vt_asparagus — Thu, 08 Sep 2005 15:02:32 GMT

Where are you planning to retrieve the email address from? Is the email address in a database (access, sql server), is it being returned from a web service, do you want to get it from active directory? Having that information will dictate the code that needs to be writting in this event handler.

Re: Automatic field insert

Khansolo — Thu, 08 Sep 2005 13:20:00 GMT

Thanks for your help vt_asparagus.

Could you give me an example of what I should put in the event handler? The email address field that I have is a drop down menu with options of various e-mail addressess but I want this to be automatically selected when the contact field is selected. Please help. I'm very new to Jscript.

Re: Automatic field insert

vt_asparagus — Fri, 02 Sep 2005 19:46:47 GMT

Use the OnAfterChange event on the Contact Name field. To quickly add an event, double click on the field, click on data validation button, there is an events dropdown, select OnAfterChange and press the edit button. In that event handler, go out to whatever datasource you have and get the e-mail address.

You cannot use the other two events listed in that dropdown because the DOM is locked and no changes can be committed.

Automatic field insert

Khansolo — Fri, 02 Sep 2005 17:58:47 GMT

Hi,

How do I link 2 fields so that if field 1 contains text, field 2 will automatically fill with a corresponding text. For example, I have two fields called "contact name" and "e-mail address". Once I select a contact name, I want the "e-mail address" field to automatically insert the e-mail address corresonding to that contact name.