AnsweredAssumed Answered

default value in a TextField via LookUp ?!

Question asked by bimi82 on Aug 7, 2017
Latest reply on Aug 8, 2017 by bimi82

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

Outcomes