Add an Item to a Pick List

[Grant]

In this tutorial, I am going to be showing you how to add an item to an existing picklist.

To start, we have this picklist assigned to the text1 field in the Collection Object table:

I want to add Purple to this list.

Step 1: Navigate to the User Tools menu in the navigation bar.

Step 2: Click on Schema Config.

Step 3: Choose your Schema Language.

Step 4: Select the base table that contains the field with your picklist.

Step 5: Choose the field with the picklist you would like to add an item to. Now click on the icon to the right of your pick list in the bottom right.

Step 6: Increase the size limit so that the picklist can contain your newly added items.

Step 7: Click on the green + button to the right of the Pick List Items text. Now you can input your picklist item’s title and value.

Now you are done!

If you have any questions, please let a comment here or send us a message.

[fedoras]

Is it somehow possible to have chained pick lists, so that the selection in one pick list filters the options in the second one and the one thereafter?

[kelshorn1]

How do you add an item to a picklist that was already created in specify?

[markp]

Hi @kelshorn1

Would you mind elaborating a bit on your question, I am having a hard time following. This page covers adding an item to a picklist that already exists in Specify (the picklist is for text1 in table CollectionObject, starts with values [‘Red’, ‘Green’, ‘Blue’] and has the value “Purple” added to it, resulting in [‘Red’, ‘Green’, ‘Blue’, ‘Purple’] after the operation).

Is there a particular picklist that you are interested in adding a value to?

Cheers,
Mark

[kelshorn1]

I’m trying to add an item to the prepType picklist which already exists within Specify. There used to be a way in Specify 7 where you could see all existing picklists and add or delete items and was wondering if there was a similar way to see all picklists in Specify 7.

[markp]

Ah I see! There are two pages about editing the prepType picklist (perhaps this highlights a need to reconcile or otherwise explain the difference between the two pages, I am not sure myself what the difference is)

Edit Preparation Types

Edit Prep Types This doc will explain how to create, update, and remove entries in the Preparation Type table. First, navigate to the User Tools menu, then go to App Resources, then click on the Schema Config and choose a language. Once in the schema config you will scroll down and click on the ‘preparation’ table. Once in the preparation table you will scroll down in the fields to ‘PrepType’ which is under the Relationships section. [Preparations table] On the bottom right under field form…

Edit Preparation Type

Editing the Preparation Type pick list is much different in Specify 7. This brief topic will detail how to create, modify, and delete entries in the Preparation Type table. The preparation type associated with a preparation dictates whether or not it can be used in a transaction such as a loan. In the preptype table, there is a boolean field named isLoanable that controls whether or not preparations with that type can be transacted. If you enter the catalog number for a collection object with …

If neither of these answer your question please let me know and can help further! You can always try out the edit/addition on sp7demofish to see how things work!

[kelshorn1]

Thank you, this is what I was looking for. I was just searching picklists and not prep type so that’s why I didn’t find the pages initially.