> For the complete documentation index, see [llms.txt](https://knowledgebase.qommentary.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://knowledgebase.qommentary.com/qommentary-writeback/custom-data/adding-input-columns/rating.md).

# Rating

**Rating** controls are ideal for applying star grading systems to individual records.

**Data type**: `number`

### Adding a Rating control

1\. Edit your sheet\
2\. Click on the **Qommentary Writeback** extension\
3\. Expand **Input Column** section\
4\. Click on **Add column**

<div align="left"><img src="https://1677646431-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M43RhGzV8Plu0tfknia%2F-MZCvqSqKXuXT2WpbY2f%2F-MZCx6ezSPuMpGDkleyH%2Fimage.png?alt=media&amp;token=c8a0c47a-fd65-447f-9bcf-fb1394cce274" alt=""></div>

5\. Select **Rating** from the dropdown menu

<div align="left"><img src="https://1677646431-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M43RhGzV8Plu0tfknia%2F-MZNzTU6_jJ1Q3lXDg4M%2F-MZO2vIwuIYHpzfTftBY%2Fimage.png?alt=media&amp;token=34a53056-3462-40fe-a616-ab08bc5f7692" alt=""></div>

6\. Add a **label** to be displayed as a column header

<div align="left"><img src="https://1677646431-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M43RhGzV8Plu0tfknia%2F-MZNzTU6_jJ1Q3lXDg4M%2F-MZO39rmzqTam4P6N0DJ%2Fimage.png?alt=media&amp;token=d5806aa3-acda-4791-a760-7bd263cdfa04" alt=""></div>

7\. Add a **field** name

<div align="left"><img src="https://1677646431-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M43RhGzV8Plu0tfknia%2F-MZNzTU6_jJ1Q3lXDg4M%2F-MZO3GSQSUF9pGIsPxLs%2Fimage.png?alt=media&amp;token=37a32be8-49c4-4548-aecd-e2b3e508732f" alt=""></div>

{% hint style="danger" %}
If database is selected as data connection, then field name **must map** to destination table column name.
{% endhint %}

{% hint style="warning" %}
Field name cannot contain spaces.
{% endhint %}

8\. Click on **Done**

**Rating** input column can now be updated and saved.

![](https://1677646431-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M43RhGzV8Plu0tfknia%2F-MZBY7GEVo514uyqybJX%2F-MZBbH8MNP3hX0g024Cs%2Fimage.png?alt=media\&token=3e3579f4-87fc-4255-9b62-cc2ef9dfe0b2)

### Changing max rating value

By default, the Rating control displays a maximum of 5-stars, If you wish to customize the maximum rating value, please follow these steps:

1\. Edit your sheet\
2\. Click on the **Qommentary Writeback** extension\
3\. Expand the **Input Columns** section and **Rating** column\
4\. Update the **Max Rating** field

<div align="left"><img src="https://1677646431-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M43RhGzV8Plu0tfknia%2F-MZBch95IF8sf-4KmKDA%2F-MZBdNKMVGkyipzz2-yX%2Fimage.png?alt=media&amp;token=6c551fc8-5a3a-4307-a97e-652d5beaf3ca" alt=""></div>
