I am trying to create an order form for the company I work for. Right now we get orders through email, where the customer just writes what they want on a paper, takes a picture of it, and emails it to us. I need the madness to stop. So I've been looking to create either a form or an interface of sorts that will allow my customers to be able to input their name, and company info including shipping address, and then they are allowed to input their own part numbers and quantity.
I do not want to create an inventory table for them to be able to choose, as there are thousands of constantly changing parts and numbers. The customers know the numbers they need to use and how many they need.
I am new to Airtable but I do have a decent understanding of how databases are structured and linked relationships. I am having trouble creating the form and allowing the customer to input a number and quantity on their own. If this is too vague, I can explain further on whatever area needs more detail.
My end result is to make it so there is a database of these orders, and no more confusing email strings.
Best answer by TheTimeSavingCo
Hello @golfcartguy4261, I understand your concern and it's good to upgrade things.
To implement this Airtable Form itself enough Basic fields to setup these fields like name(textfield), email(textfield), company(textField). As you've mentioned that you don't give users to allowed any inventory data. Here we can use Airtable form with longText field, Where user just write like {productno1}={quantity1}, {productno2}={quantity2} so on. Right now there are no need to do any relatioship or linking between 2 tables, Just for keep it simple. This is best option if you using Airtable.
These options just to explore some more thing using different forms tools. If you want to give them option to add inventory and quantity on separate box as dyanmically add more field. Then check Multiple Entries fields in Jotform They don't powerful integration with Airtable in that case you need to use Make or Zapier along side with Jotform.
Hello @golfcartguy4261, I understand your concern and it's good to upgrade things.
To implement this Airtable Form itself enough Basic fields to setup these fields like name(textfield), email(textfield), company(textField). As you've mentioned that you don't give users to allowed any inventory data. Here we can use Airtable form with longText field, Where user just write like {productno1}={quantity1}, {productno2}={quantity2} so on. Right now there are no need to do any relatioship or linking between 2 tables, Just for keep it simple. This is best option if you using Airtable.
These options just to explore some more thing using different forms tools. If you want to give them option to add inventory and quantity on separate box as dyanmically add more field. Then check Multiple Entries fields in Jotform They don't powerful integration with Airtable in that case you need to use Make or Zapier along side with Jotform.
Hello @golfcartguy4261, I understand your concern and it's good to upgrade things.
To implement this Airtable Form itself enough Basic fields to setup these fields like name(textfield), email(textfield), company(textField). As you've mentioned that you don't give users to allowed any inventory data. Here we can use Airtable form with longText field, Where user just write like {productno1}={quantity1}, {productno2}={quantity2} so on. Right now there are no need to do any relatioship or linking between 2 tables, Just for keep it simple. This is best option if you using Airtable.
These options just to explore some more thing using different forms tools. If you want to give them option to add inventory and quantity on separate box as dyanmically add more field. Then check Multiple Entries fields in Jotform They don't powerful integration with Airtable in that case you need to use Make or Zapier along side with Jotform.
I am not sure how to accomplish this. I dont quite understand how to allow the user to enter as many as they would like to add, and have them populate the way you have it presented. What field type are you using to allow them to fill out and then add a line?
I am not sure how to accomplish this. I dont quite understand how to allow the user to enter as many as they would like to add, and have them populate the way you have it presented. What field type are you using to allow them to fill out and then add a line?
Ah that's a linked field:
And here's a link to the base in case that's helpful
