You are viewing limited content. For full access, please sign in.

Question

forms lookup value not defaulting to both fill values

Updated February 22, 2018

asked on February 22, 2018

We are using 10.2.

I am doing a lookup in which I want to populate (fill) 2 different fields with the same resulting value. The second field gets populated but the first one does not. The first field is previously populated from another form but I want this lookup to replace it. The 2nd field is in a collection. There are no restrictions on either field. Any suggestions?

I also tested it by creating 2 different lookups and it still did not work.

My ultimate need is to default the value of the 2nd field into the first. Per below, I tried to set the first field value and that too is not working.

Is there a restriction on overwriting field values from a previous form?

Any assistance is GREATLY appreciated!

0 0

Replies

replied on February 22, 2018

Bonnie,

Data from a previous form is handled the same as user inputs and will not be overwritten unless the change is initiated by a user action.

If you're using a collection, that can introduce complications with formulas because I believe it has "rows" like a table so you may need to use something like INDEX(table.column,1) to specify which one you want.

Additionally, have you confirmed that the lookup is actually pulling back data? I would add a third field to the lookup rule and make sure you're actually getting a value.

0 0

You are not allowed to follow up in this post.

Sign in to reply to this post.

Asked February 22, 2018
Updated February 22, 2018
123 views