Jul 27, 2023 03:10 PM
Hi, I'm new to air table (about 2 months in, it's been in place at my company about 2 years)
Some of our employees fill out a form on the flavor/texture of our product, where different categories are rated. That form in imported into another record with all the product information, so I can't see the results from their sampling unless I click the form, then it pops up.
How can I get the information from the form into a spreadsheet? The person I replaced was doing it, but she's gone and didn't explain how to do it.
Jul 27, 2023 07:30 PM - edited Jul 27, 2023 07:30 PM
You can create an Airtable automation that adds a new row to a Google Sheets spreadsheet when a form is submitted.
If you’re using Microsoft Excel, or if you need more advanced functionality than just adding a row to a spreadsheet, you can do all of that with Make’s automations and integrations.
There can be a bit of a learning curve with Make, which is why I created this basic navigation video for Make, along with providing the link to Make’s free training courses.
Jul 27, 2023 09:25 PM
Any chance you could provide screenshots of a before and after for what you want to happen?
Jul 31, 2023 06:21 AM
The first shot is what is on airtable, (just a portion of the record) The column "daily sampling" is a link to a form that is filled out. That information was used to create the spreadsheet in the 2nd shot. That's what I need to figure out. How to pull the information from the working sheet to a spreadsheet.
The information from the spreadsheet is used to create the graph in the 3rd shot.
Aug 03, 2023 12:17 PM
any more suggestions?