Let’s say for new rows in my to-do list table, I want the date column to default to today's date and the status to default to "Not Started". To do this, click on the column you want to apply the default to and choose [Column type] options (in this example, we’re looking for Date options or Select list options, respectively).

Screen Shot 2021-04-28 at 12.34.16 PM.png

Then add your option in the Value for new rows field:

Screen Shot 2021-04-28 at 12.34.35 PM.png

You can include a value like "Not Started" or click the little f formula button (or the blue Add formula line) and write something like =Today() .

Some other formula examples:

  1. Set the value to count of rows in table: =thisTable.Count()

  2. Set the numeric value to the next number in sequence starting at 1: =thisTable.NumberCol.Max(0) + 1

  3. Set the date value to next day, starting today: =thisTable.DateCol.Max(Today() - 1) + 1

  4. Set a person as a default value by using the user's email as default, or the =User() formula (see below)

Screen Shot 2021-04-28 at 12.39.30 PM.png
Did this answer your question?