cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
bimi82
Nintex Newbie

default value in a TextField via LookUp ?!

Jump to solution

Hello

Is it possible to make a text field show default values via LookUp from a sharepoint list?

The process has 2 stages:

1) once when the user makes the request

2) the approver makes changes to the form

The Currency DropDown option is a choice and has pre-defined currencies

The list below (PlanRates) is the sharepoint custom list:

UPDATE:

I have also added a Calculated Field and connected to the Rate field.
Now at least I have the lookup() function within the calculated field.

It is just a matter of figuring out how to nest the lookup() to the custom list called PlanRates

How do I nest the look(up) to the PlanRates so that

it checks which currency is chosen via the dropdown list and then shows the relevant Value ?

I have a feeling that the currency dropdown also needs to lookup to the custom list PlanRates.
Please suggest and advise .... thanks

0 Kudos
Reply
2 Replies
bimi82
Nintex Newbie

Re: default value in a TextField via LookUp ?!

Jump to solution

Indeed:

I had to create a LookUp Drowp-Down list to link it with the PlanList.

Then based on the selected choice, the Value was showing up.

I also forgot to select the drop down name from the "named controls"

0 Kudos
Reply
bimi82
Nintex Newbie

Re: default value in a TextField via LookUp ?!

Jump to solution

Although, one thing I am puzzled!

what does the "ID" represent?!

Does it filter it from the ID value which is created with each list in sharepoint?

When I replace the ID with "Currency" (refer back to my pictures above) then it won't show the "Value"

why is that?

Reply