Character Filter For Form Textbox
I am having difficulties with the Character Filter for a textbox in the Forms
We have a label that we have what we call a Reel ID
The 6 digit reel ID has a prefix of R, which we have to have.
In the form we would scan this Reel ID into the first text box, but I am trying to use the Character Filter to eliminate the R, otherwise when it links to our MRP system, it does not recognize the R, only the 6 digit number.
The problem I am having, I go to properties for the text box, and choose the Character Filter and set it to numeric only, then click ok. When I do that, nothing saves. I have tried eliminating the prefix in the label template, but that doesn't work either. Anyone know why this is?
-
I believe it is because you are connected to a database query/filter and those parameters are controlled inside the setup for that here:
0 -
Hi
Not sure if it helps, but on the label where this data field is, if you go to the Transforms tab and Truncation you can discard the 1st character from the left.
You mentioned this links to your ERP system, I assume through the DataBase wizard, under FILTER/QUERY PROMPTS you can also do this there to remove the 1st character scaneed.
Martin
0 -
Thank you both! That was the issue and I got it to work
0
Please sign in to leave a comment.
Comments
3 comments