Set column as required

User Talk
1

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?

2

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

image
image1130×593 27.8 KB

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

3

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

Is the feature planned by any chance?

4

Not a priority topic. Sorry.

5

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

6

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.