This is the type of field that if you wanted to always enforce that it converts it to a real date. Same thing for product line.Īnd then, a date field. So, the only value that’s valid is the ones that you set up ahead of time. So, you’ll see that size is here, and it’s a pick list, which means you can pick it from the list.
Now, if I scroll down, you’ll see the custom fields. So, I’m just going to pick this first one here. So, from the Inventory tab at the very top, I go to Products, and I just look at any old product that’s in the database. So, if I want to see these fields in action, I’m just going to go to the Product Screen. Notice, we have this color field here and it’s just a plain text field. And then, you may say, “What is this times two, times three?” That just controls how wide the list appears on the screen. So, you can actually control what the actual users can type in there.
So, I’m also going to show you, okay, maybe a manufacturer’s rep name. So, these are the only values that they can actually choose from, for the value for this field. And then, for product line, I also created men’s, women’s, teen, youth. So, for instance, for the sizes, I go ahead and create the values that I want them to have. So, you click on Edit, and then you define one value per line, and these will then appear in a drop down list for the user to choose from. And you would set that here up in this little edit box. You want them to pick it from a list of valid values. You may not want them to have to enter the text by hand. So, for a size custom field, you may want to limit them. So, you maybe still saying, what is a pick list? Well, it’s just a way that you can control what the user is allowed to type in the custom field. And of course, the pick list and the text fields can be different widths, so that they display longer or shorter on your screen. You can have a pick list type, a date type, or a text field type. So, you may be wondering what is data type? What does that mean? Well, you can create different types of fields. I have a manufacturer’s rep name, and a color field that’s called, Text. Then, we have short text fields, medium, long, extra-long. So, I have a size field and I have a data type called, pick list, and then there is a product line field, a date type field. So, in this example, you see that I already have added my own custom fields to this demo database. Just simply scroll down and you’re going to see a section called, Custom Fields. You would go to the Product tab to add a custom field about your products. So here, from the home page, just click on Application Settings. And how do you do that? You go to your application settings to begin with. Many people ask and we add our own data fields to like, products. This is Mike, Finale Inventory, going to give you a short demonstration on Custom Fields.
0 kommentar(er)
