Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Fill field with prior values

1287 6
Showing results for 
Search instead for 
Did you mean: 

Is there a way to autofill a field from prior values in the same column?

6 Replies 6

@Conrad_Lindes are you thinking like Excel where you grab the corner of the populated cell and drag it across empty ones in the column and it will intelligently autofill values but adding 1 to the numbers or date? Cause I was looking for that as well!

No, although that would also be nice. I was thinking of autopopulating, as in Excel. For instance, if “cat” had been entered into the animal field in a previous row and then one started typing “c” into the animal field in a new row, “cat” would pop up as an option to fill the field.

Also looking for this intelligent autofill feature. Any solutions yet?

Continuing the discussion from Fill field with prior values:

Also looking for this feature but cannot find anything… Seems no response fro AT in 3 years…

Yes, you can do this, but in a much better way than it is implemented in Excel. It is implemented in a database-like way:

Simply change your field into a single-select or multiple-select. When you enter the field, just start typing. If your value already exists in the matching results, just hit return to accept it. If your value doesn’t exist, just hit return anyways and it will get added to the list for the future.

There are several areas throughout Airtable that work like this. For example, linked fields work the same way. Just start typing and then hit return to accept the matching linked record. If you hit return when no linked records appear, it will create a brand new linked record for you based on what you were typing.

(Also, on an unrelated note, as one of the original people in this thread was looking for, you can do a simple copy-and-paste across rows/columns by dragging the lower right corner of the populated cell across empty ones. Airtable won’t alter the values as you paste them — it will just paste them.)