Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 6128 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

I'm trying to set up a barcode using barcode 3/9 fonts. I would like my calculation to read from my purchase order number. for example: my purchase order number is 01-556792 and i would like my barcode to read 01556792 without dash.

Also in order to create a field using my purchase order number field i need to an asterick "*" before and after the number to make the scanner work! the error i get is "A number, text constant, field name, or "(" is expected here."

Posted

Don't you think that is something worth mentioning? Your profile says 8, and there is no indication in your original post to say otherwise.

I believe this should work for you:

"*" & Substitute ( OrderNumber , "-" , "" ) & "*"

Posted

GREAT! THANK YOU NOW IT WORKS

But I did forget to mention that we would like to remove the last digit.

For example our original PO# 01-556792-1 and we would like the barcode to read "01556792" ONLY remove both dashes adn the last digit after the second dash.

This is also in FM 6.0

Posted (edited)

AWESOME!!!!

THANK YOU SO MUCH FOR YOU HELP TODAY!

Now...that we got our purchase order # to work.

We would also like our job#. For example our job number has to 2 fields

1st field are letters: P, C, X, M, CR

2nd field are numbers: 12345 (5 digits)

for Example our job # are C40354

we would like to create a barcode indicating C40354

this is what i have for the calculation but i got the 2nd fields not teh 1st field which are the letters.

[color:red]"*" & Left( Substitute( Job Type + Job Number , "-" , "" ) , 8 ) & "*"

Also the 1st field for Job Type is a drop down option of:P, C, X, M, CR

[color:black]this is still in FM6

Edited by Guest
Posted

Here's my suggestion: sit down with you already have and with the help file, and figure out how it works. Then you will be able to apply it to your next question (and the one after next).

This topic is 6128 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.