issacd

Could you explain to me, so I understand, why was FileMaker unable to find any records unless I entered both of the () symbols?

All solved, I removed all of the "(" and ")" by doing a find and replace for each symbol INDIVIDUALLY. When I tried to remove both at the same time I had an unexpected result. I can now print valid barcode labels and scan them into the search text string field of my custom dialog box without any typing. It was a really STUPID problem I created for myself by having those "(" and ")" in there! Before these modifications, FileMaker would not find any records if I did not also include the "(" and ")" that I had in my inventory number i.e. (1234) (so it would print scan-able barcodes.)

I had a serial number set up for the digits, and I had the parenthesis auto inserted. I took your advise about a calculation field and it worked perfectly, this also will help solve the original issue I had in searching. Now to remove the parenthesis before and after my 4 digit number, what script should I use for that? I tried a couple of different ones, but none worked as expected. Thanks!

I have a button linked to a script that lets me scan a barcode or type an inventory number to quickly find the specific inventory record. I would like to speed up my searching by automatically inserting my required parenthesis "()" at the beginning and end of the 4 digit number I scan into the custom dialog box I set up. How do I do this (what function(s)) should I use? My inventory numbers are all 4 digit numbers (no longer or shorter) and start and end with a parenthesis (so it's barcode scan-able when printed,) they use this format: (1234) My current script is: Enter Find Mode Show Custom Dialog (Search/Cancel Buttons + 1 Field) Perform Find PS. If there is a way to simply tell FileMaker not to require those parenthesis while searching, that would be even easier and cleaner I suspect!