Jump to content

Auto enter calculations?


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

Recommended Posts

How would I go about doing this? What I want to do is have 3 fields (Type, Skew, ID). The "Type" field is a pop-up window with the words (clothes, food, household) in the window. The Skew window is a number that I type in.

I know how to do everything above. What I don't know how to do is this

Example: When the "Type" field is clicked on and household is selected the letters "hh-" show up in the "ID" field, and when I type in the "skew" field, the skew numbers show up in the "ID" field after the letters that are already there. ie. hh-123456

Hopefully someone knows how to do this.

Heathbo

Link to comment
Share on other sites

I also need to set it up so the computer will see "hh-123456" as a different number from

"fo-123456". So far when I manually enter the info and then try to bring it up through a portal the computer thinks they are the same number and only shows one.

Heathbo

Link to comment
Share on other sites

Try this:

Type (text)

Skew (number) Do you mean SKU?

ID (calculation, text) = Case(

Type = "household", "hh",

Type = "clothes", "cl",

Type = "food", "fo",

"") & "-" & ID

The reason that fo-123456 looks like hh-123456 is that the field it is entered into is a number field, it needs to be a text field.

-bd

Link to comment
Share on other sites

This topic is 7201 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.