Sep 16, 2024 06:38 AM
Is there a way to use automation to automatically store a document in the newly created data record for every newly created data record
Solved! Go to Solution.
Sep 17, 2024 12:51 PM
If your plan including record templates, you can create a template with document and add new records by 'apply template'
Sep 16, 2024 08:58 AM - edited Sep 16, 2024 09:00 AM
Hi,
If the document is always the same I would do the following:
Let's assume your original Table is called: Table A.
Now Create a new Table (Called Table B) with a primary field (called Name - You can populate this field with whatever you need) and just an additional Attachment Field (called "attachement Field") where you will manually upload the document you want to be automatically uploaded.
Then create in the original Table a Linked Record to the "Table B" and add a Lookup Field that refers to the "Attachment Field".
(now you can hide the Linked record to Table B)
Now create the following automation.
Trigger: Table A - When a record is created
Actions:
Action 1: Find Record: Table B - Conditon: Attachment Field: not empty - Maximum record limit: 1
Action 2: Update Record: Table A - Fields: Linked Record Table B - populate with: Field values / Name
This Automation uploads to every created record in Table A the same document (uploaded in Table B)
Sep 16, 2024 10:41 PM
Thanks for the helpful answer. That's what I'll do. the document is an editable PDF file, a checklist to tick off. Is it actually possible to fill out an editable PDF directly in airtable and save it straight away?
Sep 17, 2024 12:38 AM
Good to know that this solution work for you! 🙂
Regarding your seocnd question, I am afraid, that this is possible to edit and save a document directly in Airtable.
Sep 17, 2024 12:51 PM
If your plan including record templates, you can create a template with document and add new records by 'apply template'