Jul 13, 2022 02:23 PM
As of right now the inventory department at my company relies on paper forms and it was recently requested that we digitize the form. I don’t need the form to actually place the order, I just need filled out forms to be sent to the inventory manager. However, as I dove into the process, I hit a wall. Is there a good way to convert the attached form into an airtable form?
Jul 14, 2022 02:52 AM
Hey Dustin, in short, nah not really I’m afraid.
You’ll probably want to look into other form software that lets you add tables into the forms like Jotform. Here’s a link to their documentation for the form table: Input Table's Multi Type Columns
In my experience, moving old workflows (or forms in this case) into Airtable rarely works well honestly, and if we could revamp how we’re working as well that would probably be super helpful
For example, if this purchase order form is filled up by people who have access to Airtable, what if they did the following instead?
Vendor
, Item #
, Description
, Quantity
, Date Needed
, Date Received
Date
, Name
, Department
, Reference #
This is just an example, of course, and will be highly dependent on what your company’s workflows are like
Happy to brainstorm further!
Jul 14, 2022 05:49 AM
Airtable doesn’t allow users to design forms or layouts that look exactly like that, except when printing single-page documents from Page Designer.
However, you can create an interface that looks “somewhere in the approximate neighborhood of similarity” to that purchase order.
And then to print it, you can either use Page Designer (if it will always be a one-page PO) or DocuMint (if you need a multi-page PO).
Alternatively, you can use JotForm to design an interactive form that looks like that. Or you could even just keep it in Excel or Google Sheets, and then have the data sent to Airtable using Make.com.
It sounds like you may benefit from having an expert Airtable consultant to help you create this system. If you have a budget for your project, feel free to contact me through my website:
Jul 14, 2022 07:51 AM
Hey @Adam_TheTimeSavingCo, recreating the form isn’t exactly necessary, from what I gathered yesterday from meeting with inventory department, they just need a way to send a digital document to their various departments so they can list what they need. The form doesn’t need to actually place the order, but it does need to communicate to the inventory manager what is needed.
Jul 14, 2022 11:16 PM
Hm, okay. And I take it the departments that need to list what they need do not have access to Airtable?
Jul 15, 2022 06:36 AM
Correct. Some departments don’t even have computers so ideal they want a paper and digital version.
Jul 15, 2022 08:11 PM
Roger that. Hmm, if they don’t have access to Airtable, then that Jotform input table thing is probably going to be the easiest way to deal with this.
So you’d just recreate the paper form in Jotform and then follow this guide to get Jotform to dump that data back into Airtable