AnsweredAssumed Answered

Forms 2013 calculated value lookup shows unwanted prefix

Question asked by chrissnc on Jul 14, 2015
Latest reply on Jul 14, 2015 by mmatsako



I am currently doing a simple calculated value on my form to take the value of a lookup field and return the column beside it in real time on the form.   The logic is sound but the issue I get is the lookup returns the ID number as well as the desired name which results in the calculated value never matching the list.


The value on my list is Sub-Terrain #1 Sub contractor Crew.    The 433 is the ID number on the list and the ;# is just extra helpful.    The question I have is how can I remove the 433:# from my lookup value for my calculated field can match the value correctly.    When I fill the form out the value comes in currently as  Sub-Terrain...




thanks for the help.   I hope this makes sense.