Spreadsheet: 41097d1239608180-autofilling-the-fields-when-typing-just-one-info-records-1
Sheet: Database

[NAME] No. | SSN | First Name | Middle name | Last Name | Date of Birth | City of Birth | Country of Birth | Address | City | State | Zip Code | Sex | Hair | Eyes | HT | WT
B12345678 | 123-45-6789 | FirstN1 | Middle1 | LastN1 | 1963-01-01 00:00:00 | Los Angeles | USA | 1234 Main St #1 | Los Angeles | CA | 12345 | M | [NAME] | Blue | 5' 6" | 150
B12345679 | 123-45-6790 | FirstN2 | Middle2 | LastN2 | 1963-01-02 00:00:00 | Sacramento | USA | 1235 Main St #2 | Sacramento | CA | 12345 | F | Blond | [NAME] | 6' | 155
B12345680 | 123-45-6791 | FirstN3 | Middle3 | LastN3 | 1963-01-03 00:00:00 | Toronto | Canada | 1235 Main St #1 | Toronto | ONT | TNT 1W3 | M | [NAME] | Green | 5' 11" | 160
B12345681 | 123-45-6792 | FirstN4 | Middle4 | LastN4 | 1963-01-04 00:00:00 | Los Angeles | USA | 1236 Main St #2 | Los Angeles | CA | 12345 | F | Red | [NAME] | 5' 6" | 165
B12345682 | 123-45-6793 | FirstN5 | Middle5 | LastN5 | 1963-01-05 00:00:00 | Sacramento | USA | 1236 Main St #1 | Sacramento | CA | 12345 | M | [NAME] | Blue | 6' | 170
B12345683 | 123-45-6794 | FirstN6 | Middle6 | LastN6 | 1963-01-06 00:00:00 | New York | USA | 1237 Main St #2 | New York | CA | 12345 | F | Blond | [NAME] | 5' 11" | 175
B12345684 | 123-45-6795 | FirstN7 | Middle7 | LastN7 | 1963-01-07 00:00:00 | Los Angeles | USA | 1237 Main St #1 | Los Angeles | CA | 12345 | M | [NAME] | Green | 5' 6" | 180
B12345685 | 123-45-6796 | FirstN8 | Middle8 | LastN8 | 1963-01-08 00:00:00 | Sacramento | USA | 1238 Main St #2 | Sacramento | CA | 12345 | F | Red | [NAME] | 6' | 185
B12345686 | 123-45-6797 | FirstN9 | Middle9 | LastN9 | 1963-01-09 00:00:00 | New York | USA | 1238 Main St #1 | New York | CA | 12345 | M | [NAME] | Blue | 5' 11" | 190
B12345687 | 123-45-6798 | FirstN10 | Middle10 | LastN10 | 1963-01-10 00:00:00 | Los Angeles | USA | 1239 Main St #2 | Los Angeles | CA | 12345 | F | Blond | [NAME] | 5' 6" | 195
B12345688 | 123-45-6799 | FirstN11 | Middle11 | LastN11 | 1963-01-11 00:00:00 | Sacramento | USA | 1239 Main St #1 | Sacramento | CA | 12345 | M | [NAME] | Green | 6' | 200
B12345689 | 123-45-6800 | FirstN12 | Middle12 | LastN12 | 1963-01-12 00:00:00 | New York | USA | 1240 Main St #2 | New York | CA | 12345 | F | Red | [NAME] | 5' 11" | 205
B12345690 | 123-45-6801 | FirstN13 | Middle13 | LastN13 | 1963-01-13 00:00:00 | Los Angeles | USA | 1240 Main St #1 | Los Angeles | CA | 12345 | M | [NAME] | Blue | 5' 6" | 210
B12345691 | 123-45-6802 | FirstN14 | Middle14 | LastN14 | 1963-01-14 00:00:00 | Sacramento | USA | 1241 Main St #2 | Sacramento | CA | 12345 | F | Blond | [NAME] | 6' | 215
B12345692 | 123-45-6803 | FirstN15 | Middle15 | LastN15 | 1963-01-15 00:00:00 | New York | USA | 1241 Main St #1 | New York | CA | 12345 | M | [NAME] | Green | 5' 11" | 220
B12345693 | 123-45-6804 | [NAME] | Middle16 | LastN16 | 1963-01-16 00:00:00 | Los Angeles | USA | 1242 Main St #2 | Los Angeles | CA | 12345 | F | Red | Blue | 5' 6" | 225
B12345694 | 123-45-6805 | FirstN17 | Middle17 | LastN17 | 1963-01-17 00:00:00 | Sacramento | USA | 1242 Main St #1 | Sacramento | CA | 12345 | M | [NAME] | [NAME] | 6' | 230
B12345695 | 123-45-6806 | FirstN18 | Middle18 | LastN18 | 1963-01-18 00:00:00 | New York | USA | 1243 Main St #2 | New York | CA | 12345 | F | Blond | Green | 5' 11" | 235
B12345696 | 123-45-6807 | FirstN19 | Middle19 | LastN19 | 1963-01-19 00:00:00 | Los Angeles | USA | 1243 Main St #1 | Los Angeles | CA | 12345 | M | [NAME] | [NAME] | 5' 6" | 240