I have numbers 00001 to 00014, but have not listed the numbers from 00015 to 00200 yet because I to update photos with a watermark. However, I have records from 00200 onward updated and on the website. Is there a way to include 00015 to 00200 as empty records to maintain the sequence of autonumbering then input the record for 00201 and continue? I hope this makes sense.
thanks Linda
I'm not sure I fully understand your question, but if you're simply looking to insert the missing records, and your table has two fields, one for the number and one for photos, then here are two easy options.
1. You can add new rows in Airtable and type in the missing numbers like 00015, 00016, 00017, etc. in your “Number” field. Leave the photo field empty for now.
2. If you want to do it faster, open Excel or Google Sheets and generate the numbers using this formula - =TEXT(ROW(A1)+14, "00000"). This starts at 00015. Drag it down until you reach 00200. Then copy these numbers and paste it in Airtable.
Taha, Airtable Advisor
Hey
How are you showing the records on your website (which I understand you are doing).
If that is done by embedding an Airtable view, then you can just have the record without attachment on Airtable, but have the view that you are embedding to filter out any records where Attachment field is blank.
Please fell free to provide some more details.
Mike, Consultant @ Automatic Nation
Hm, what issues did you face when adding new records to the table till you hit 00201?
I didn't have a error but wanted to leave rows empty until I go back and load missing records
Hey
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.