Hello there,
I am very new to Airtable (just started two days ago) and I am finding that there are so many things that can be done here so I am very eager to learn. So TLDR, me and my friend has a small business where we need to find suppliers and ask for their quotations for bidding purposes. We have been very overwhelmed lately and want to leverage technology to help us automate some of the jobs. I have a problem with configuring the database right and would appreciate any insights from you guys.
Working Process:
Currently, our working process is quite redundant and consumes so much time. So first, the purchase request will be decided by us on what items to buy. Then my colleague will print out those items (Row) along with some potential suppliers (columns), then we will work together to pick which supplier we will ask for each item. Also it should be noted that in each box, there may or may not be past price (if we ask them for quotation before). After that, my colleague has to then input those back into the excel and individually make it table for each supplier. Each supplier will send quotation and we basically just print all those quotes and check together. As you can tell, the problem with this process is that we have no past data to rely (or at least, we are limited in terms of how much we can analyse the data as they are not in standard database format). Hence this is the reason why I want to try using Airtable to emulate this bidding process.
So I have three tables (Request, Price Comparison and Supplier). Request Table has the following fields:
Items (Primary field) [Single line text]
Reference document [Single line text]
Unit [Single select]
Quantity [Number]
Price [Currency]
Supplier [Single select]
Logistics status [Single select]
Price comparison [Link to Price comparison table]
Price comparison Table has the following fields:
Items (Primary field) [Single line text]
Reference document [Single line text]
Unit [Single select]
Quantity [Number]
Price [Currency]
Status [Single select]
Picked [Check box]
Supplier [Link to Supplier table]
Request [Link to Request table]
Suppliers Table has the following fields:
Name (Primary field) [Single line text]
Contact Method [Single select]
Country [Single select]
Price Comparison [Link to Price comparison table]
Request [Link to Request table]
Automations that I have done/ want to do:
- I want it so that after I finished typing out the fields in request table, those same fields will be created in the Price comparison table. This one, I have achieved through automation.
- In the Price comparison table, I added a list view and group by Items. The reason why I want to do this is to be able to type out the suppliers for each items so that it can be seen by my colleagues. However, I am unable to achieve this. When I added new records under those Item group, I would have to refill all the values again; or otherwise, only the Supplier field will be filled and the rest of fields in the record will be blanked. I have tried automations, but I am clueless on how to make it work.
- If this can be achieved then I want to include another automation process to make it so that when I checked the box for certain suppliers in the Price Comparison table (thus signifying that this supplier is confirmed for this item), the Supplier field in Request table will be updated to reflect that.
The fields (except value) in price comparison table are all automated by the entry in Request table. My work flow is that my staff will input the items in the request list. Then I will select which item goes to which suppliers for bidding process. All items will go to multiple suppliers. I want to know if this process can be done purely through Airtable.