Removing colors in single select column

[Emanuela]

Hello everyone,

would it be possible to remove the colours in the single select?

[bennhatton]

If you feel comfortable with such technical level, there’s an API function that can help you : Update Single/Multiple Select Options

Here is a little Python script that you can run to remove the colours (before using it, you will have to set three variables :

• my_base_name : the name of the base (for example my_base_name = 'Table1')
• my_col_name : the single select column name of the base (for example my_col_name = 'SingleSelect')
• my_base_uuid : the base unique identifier (or UUID) of the base (you can find it by clicking on your base in the team admin base page)

from seatable_api import Base, context
import requests

base = Base(context.api_token, context.server_url)
base.auth()

my_base_name = 'YOUR_BASE_NAME_HERE'
my_col_name = 'YOUR_SINGLE_SELECT_COLUMN_NAME_HERE'
my_base_uuid = 'YOUR_BASE_UUID_HERE'

single = base.get_column_by_name(my_base_name, my_col_name)
options = []
for opt in single['data']['options']:
    options.append({'id':opt['id'],'textColor':'#FFFFFF','color':'#C2C2C2'})

url = "https://cloud.seatable.io/dtable-server/api/v1/dtables/" + my_base_uuid + "/column-options/"
payload = {
    "table_name": my_base_name,
    "column": my_col_name,
    "options": options
}
headers = {
    "accept": "application/json",
    "content-type": "application/json",
    "authorization": "Bearer " + base.jwt_token
}
response = requests.put(url, json=payload, headers=headers)
print(response.text)

[fsa]

Please follow these instructions.

You can simply choose the color white.

[Emanuela]

Thank you very much.
But as I have the free plan I don’t have the colour settings option. Could you confirm it, please?

[fsa]

Correct, as it says in the article: available with Enterprise.