Help

Re: Fill field with prior values

998 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Conrad_Lindes
5 - Automation Enthusiast
5 - Automation Enthusiast

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

6 Replies 6
adam
5 - Automation Enthusiast
5 - Automation Enthusiast

@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.

jamesvclements
6 - Interface Innovator
6 - Interface Innovator

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

Chris_Lawless1
4 - Data Explorer
4 - Data Explorer

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.)

Thanks, Scott.

Conrad