Set column as required

[fpiovesan]

Your Setup:

• SeaTable Cloud (free)

Describe the Question:

Is it possible to set a column as required? So that when a user adds a new record, it will not save unless that specific columns has been filled in?

[rdb]

In a form, either a standalone form or in a form in an app, you can make fields required fields (see below).

It is not possible to define fields as required fields in the table view/page.

[fpiovesan]

Thank you for the answer
Indeed, we would need the option in table view.

Is the feature planned by any chance?

[rdb]

Not a priority topic. Sorry.

[bha]

Hi @fpiovesan,
In the meantime, here are a few things you can do to get relatively close to a resuired behaviour:

• add an asterisk to your column’s name as it’s usually the case for required fields in forms
• add a column description mentioning for example “Required!”, which will add an ⓘ icon next to the column name
• add, for this column, a coloration rule which will display a red background if the cell is empty

Of course, it won’t actually disable entering a row without the column being filled, but it could give people a pretty clear advice that something’s wrong…

Bests,
Benjamin

Bests,
Benjamin

[abaer]

I had quite some success with a few solutions:

• Write a formula that translates “required“-conditions into written hints - and color that formula cell if it’s not empty. If you check multiple cells, that can become a complete line check assistant.
• Use the regex-based syntax checking with some data types.