vLookup

[Paul Lynch]

Hi Alex,

I’m trying to pre-populate some fields in a child list when I do a vlookup from the parent list. i.e. in the vlookup section Prefill values in child

Some work and some do not. They are all single line of text fields in both lists.

I think this is something to do with the fact that my internal field names begin with numbers.

So for example one is:

Parent List:

From
%5Fx0031%5F%5Fx002e%5F3%5Fx0020%5FCountry%5Fx0

Child List:

To
Country

Could you confirm if this is the reason (and I guess there is not much I can do).

[Paul Lynch]

Sorry just realised my mistake – I should have used the very useful “Fields” tab to get my internal field names.

Instead I was using the encoded internal field names taken from URL – once I decoded them it works!

So
%5Fx0031%5F%5Fx002e%5F3%5Fx0020%5FCountry%5Fx0

decoded is;
_x0031__x002e_3_x0020_Country_x0

If anyone ever needs to do this I always find this useful:
https://meyerweb.com/eric/tools/dencoder/

[Keith Hudson]

This is an example of how avoiding spaces, special characters and leading numbers when column names saves grief later on. The encoding is done differently in different situations, so it can become very confusing.

[Author]

Posts