We have a form that was created under 9.2, we have moved to version 10.1 last week. There is a number field for the employee ID. Some are 2 numbers: 59, some are 3 numbers 191, some are 4: 1511. In the field we instructed everyone to use 0059, 0191 and 1511 so the lookups will work. In Forms this lookup still seems to work - HOWEVER when the FORM is submitted the number put in the FORMS database seems to lose the leading zeros and the corresponding workflow that use these 2 or 3 digit fail.
When I look at the tokens in the failed Workflows - the employee id does not have the leading zeros. When I test the query with the id showing in the tokens the lookup fails, when I add the leading zeros the query works. When a employee with a 4 digit ID runs the FORM and the attached Workflow the query is successful.
The query in Workflow is a simple lookup - not a custom query. How do I get FORMS to save all 4 digits including the leading zeros in it's database? OR how do I get workflow to add leading zeros to the simple lookup? OR am I going to have to change the query to a custom query to add in the leading zeros?
Any help would be appreciated. Thanks.