Is it possible to create a rating column of heart type using graphql?

[ParthAtRewind (Parth)]

Hi There Folks,

I have a question, is it possible to create a rating column with heart instead of stars?

I tried passing settings_str but the API is failing with Unknown argument "settings_str" on field "Mutation.create_column". error

Sample query:

mutation Create_column {
    create_column(
        board_id: "9999999999"
        column_type: rating
        title: "Postman 3H A1"
        description: "This column is created from postman, should have 3 hearts."
        settings_str: "{\"symbol\":\"hearts\",\"color\":\"#e2445c\"}"
    ) {
        archived
        description
        title
        type
        id
        settings_str
    }
}

Thanks!

[diarcollective (Ashley Nowak)]

Hi! Does this article help with what you’re looking for?

The Rating column

[ParthAtRewind (Parth)]

Sadly no.

I want to see if there’s a way to do this via GRAPHQL API

[trevor13 (Trevor Chauvin-DeCaro)]

Hi! Maybe you could try one of these solves?

• Use settings_json Instead:
• In newer API versions, settings_json might be required instead of settings_str.
• Try this modified query:

mutation Create_column {
    create_column(
        board_id: "9999999999",
        column_type: rating,
        title: "Postman 3H A1",
        description: "This column is created from Postman, should have 3 hearts.",
        settings_json: "{\"symbol\":\"❤️\",\"color\":\"#e2445c\"}"
    ) {
        archived
        description
        title
        type
        id
    }
}

If that doesn’t work would using a dropdown or Status column instead and assign heart emojis (, , ) as labels work?

[ParthAtRewind (Parth)]

Sadly, there is no such thing as settings_json, and creating a ratings column as the label column instead won’t work for us.

[trevor13 (Trevor Chauvin-DeCaro)]

Well crap! What about this:

IF({Rating}=1, “”,
IF({Rating}=2, “”,
IF({Rating}=3, “”,
IF({Rating}=4, “”,
IF({Rating}=5, “”, “No Rating”)))))

• This formula replaces stars with hearts dynamically.
• Users can input a number (1–5) in a Numbers column, and the Formula column displays the corresponding hearts.
• While this isn’t a clickable rating system, it provides a visual alternative.