AnsweredAssumed Answered

Left (Text;number) Function

Question asked by kingsley47 on Feb 28, 2011
Latest reply on Feb 28, 2011 by kingsley47


Left (Text;number) Function


I have made a field that should return the last four text from another field.

It basically looks like this...

Field 2 = left(Field 1;4)

Now the only issue I'm having is that Field 2 won't populate unless I go in and recommit some of the values in Field 1. So for field 2 to show anything I basically have to go into field 1 and erase the last letter, retype it and then click out of the box. I have over 4500 records that I need this calculation to work for. So recommitting field 1 in every record is not really an option. Could someone help me figure out a way around this? So that field 2 automatically pops up?