autopopulation of fields?

[jgrisi]

Is there anyway to auto populate fields?

For instance, a form is created with sections that require approval from
different associates, let's say a supervisor, then accounts payable, etc. Is
there anyway to have them fill their name out at the top of the form, and
then have the contents of that text box auto populate other text boxes below?

Thanks.

 

[UKDeluded]

On the fields that you want to autopopulate make a default value that calls,
for example, the data field. If, let's say, you are grabbing from a employee
directory where you have 'ID, Name, Position' and in field 1 you have a drop
down calling that data source with Value=ID and Display=Name you can then
make the default value of 'Position' with (using data fields from the
directory) "@Position[@ID=Name]".
You should then have that field filled out based on the original.
Is this what you were after?

 

[jgrisi]

Thanks. I'll give that a try.

On the fields that you want to autopopulate make a default value that calls,
for example, the data field. If, let's say, you are grabbing from a employee
directory where you have 'ID, Name, Position' and in field 1 you have a drop
down calling that data source with Value=ID and Display=Name you can then
make the default value of 'Position' with (using data fields from the
directory) "@Position[@ID=Name]".
You should then have that field filled out based on the original.
Is this what you were after?

Is there anyway to auto populate fields?

For instance, a form is created with sections that require approval from
different associates, let's say a supervisor, then accounts payable, etc. Is
there anyway to have them fill their name out at the top of the form, and
then have the contents of that text box auto populate other text boxes below?

Thanks.

 

[Khoe]

That doesn't sould very easy, but it sounds like writing code. Please explain
this in more detail step by step if you would.

My question is I have in column A names of employees. As it stands now I
enter in column B their employee number. Over and over, I want excel to
recognize that employee, and put their employee number into column B. How is
this done?

Thanks. I'll give that a try.

On the fields that you want to autopopulate make a default value that calls,
for example, the data field. If, let's say, you are grabbing from a employee
directory where you have 'ID, Name, Position' and in field 1 you have a drop
down calling that data source with Value=ID and Display=Name you can then
make the default value of 'Position' with (using data fields from the
directory) "@Position[@ID=Name]".
You should then have that field filled out based on the original.
Is this what you were after?

Is there anyway to auto populate fields?

For instance, a form is created with sections that require approval from
different associates, let's say a supervisor, then accounts payable, etc. Is
there anyway to have them fill their name out at the top of the form, and
then have the contents of that text box auto populate other text boxes below?

Thanks.