cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

Fields auto populate depending on what is selected from first field

Hi

I am new to Forms and wanted to know if l could possible to the following :

 2 document libraries

Employee information

Further information for employee

Have 4 fields :

On Document Library (Further information for employee) where the Nintex form sit's

FIELD 1 : Employee ID (want to enter in manually myself)

FIELD 2 : Auto Populates - Information from Employee information (Employees Name )

FIELD 3 : Auto Populates - Information from Employee information (Office Location )

FIELD 4 : Auto Populates - Information from Employee information (Managers Name )

Hope that makes sense

thanks

Labels: (2)
0 Kudos
Reply
5 Replies
Workflow Hero

Re: Fields auto populate depending on what is selected from first field

yes, it's possible, however complexity depends on how you'd like to use fields 2-4.

if it's sufficient for you they are just read-only fields, you can easily do it with calculated value control and formula based on lookup() function.

if you would need them to be editable, it would be a bit more complex and it would need a javascript code.

Accept as Solution Reply
Workflow Hero

Re: Fields auto populate depending on what is selected from first field

Hi

Read only would be fine how would l do the formula with that would l still use a list lookup, also for the first field how do l make that a type box that the users enters the employee ID him/herself

As when l use a list lookup l only get the below options :

How do l make it that a user enters the employee ID

Accept as Solution Reply
Workflow Hero

Re: Fields auto populate depending on what is selected from first field

Accept as Solution Reply
Workflow Hero

Re: Fields auto populate depending on what is selected from first field

thanks for that, what about the first field l want that as a free text box but to look in a list to make sure the employee ID exist and if it doesn't to bring up an error

Accept as Solution Reply
Workflow Hero

Re: Fields auto populate depending on what is selected from first field

it's not possible this way (without a javascript).

what you, however, could eg. do is to place a label or textbox control on the form with an alert/warning message and assign it a formatting rule that will show it if an ID doesn't exist and hide it otherwise.

rule's formula should check whether lookup() function as suggested above returns a valid user ID or not.

0 Kudos
Accept as Solution Reply