pigaloo Posted April 5, 2001 Share Posted April 5, 2001 I want to have filemaker generate and alphanumeric sku# by combining the contents (or first few characters of the contents) of one field with the contents of a serial number field. IE: first field = elephant serial field = 420 sku field = elephant420 or sku field = eleph420 Thanx 4 Your Help! Link to comment Share on other sites More sharing options...
BobWeaver Posted April 5, 2001 Share Posted April 5, 2001 Make the sku field a text calculated field with the following formula: sku Field = first field & serial field or if you just want the first few characters of the first field (6 for example) then do this: sku field = Left(first field,6) & serial field Link to comment Share on other sites More sharing options...
pigaloo Posted April 5, 2001 Author Share Posted April 5, 2001 Wow!!! Thats even simpler than I thought!! Thanx 4 the speedy Reply Link to comment Share on other sites More sharing options...
Newbies NiteWolf Posted April 12, 2001 Newbies Share Posted April 12, 2001 Just wondering if anyone got this to work? I am having a heck of atime with this calculation. Please assist. nW Link to comment Share on other sites More sharing options...
signal Posted April 13, 2001 Share Posted April 13, 2001 Is your calculation defined to return text or number? Link to comment Share on other sites More sharing options...
pigaloo Posted April 18, 2001 Author Share Posted April 18, 2001 This is the way that i do it. SkuField = Left( FirstField , 5 ) & NumToText( SerialField ) Make sure the calculation result is text. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8430 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 accountSign in
Already have an account? Sign in here.
Sign In Now