Very new to this.
Is there a way to create a fill-able form for my employees to fill out and submit. When they submit it, I’d like it to show up as an attachment next to their name in their row. I don’t want to create a new row for each form submission because it’ll add up quick with everyone doing weekly forms.
My employees have to fill out a form every week and submit that so I need a way to keep track of who submitted/when and keep them all together.
Thank you!
Alyssa,
Is there a reason you wouldn’t create a table for “Employees” and a table for “Weekly Form”. The you could create a form for each employee that populates the “Weekly Form” table and relates each form submission to the individual employee.
This would give you a searchable database of all the form entries that a particular employee has submitted.
Alyssa,
Is there a reason you wouldn’t create a table for “Employees” and a table for “Weekly Form”. The you could create a form for each employee that populates the “Weekly Form” table and relates each form submission to the individual employee.
This would give you a searchable database of all the form entries that a particular employee has submitted.
I agree with @Mac on this. If you give each employee a custom URL that pre-fills their name (or pre-selects them from a multi-select list of all employees in an sEmployees] table), matching forms to employees will be very easy, plus it will be a lot easier to review the form contents compared to shuffling through a host of attachments.
I agree with @Mac on this. If you give each employee a custom URL that pre-fills their name (or pre-selects them from a multi-select list of all employees in an [Employees] table), matching forms to employees will be very easy, plus it will be a lot easier to review the form contents compared to shuffling through a host of attachments.
"I need a way to keep track of who submitted/when and keep them all together."
At https://FillinPDF.com an unlimited number of fill in PDF forms can be uploaded free. You can share a link to any form. The recipient of the link can then open the form with one click, make changes to the form, and click "Save" to have the form and data saved back to our server.
A log is automatically created that shows who submitted the form, when and the changes made. The log can be viewed for every form that is submitted, providing a complete historical record for each form. The completed forms are all saved together on one server, for your review. You can combine, email, etc. any form, as needed.
Dean Westover, President
Choices Software, Inc.
Your best bet for this is to use Fillout’s advanced forms for Airtable.
Fillout is 100% free and it offers hundreds of features that Airtable’s native forms don’t offer, including the ability to create custom PDF files from a form submission.
I demonstrate how to do this on this Airtable podcast episode:
I also show off some other advanced Fillout tricks on this podcast episode:
Fillout also gives you tons of other features, such as the ability to update Airtable records using a form, accept payments on forms, display Airtable lookup fields on forms, create new linked records on a form, control access to a form via SSO or email domains or a list of email addresses stored in Airtable, perform math or other live calculations on your forms, create multi-page forms with conditional paths, and much more.
Hope this helps!
If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.