Save the date! Join us on October 16 for our Product Ops launch event. Register here.
May 25, 2023 08:55 PM
My first community post...
In a table Results I have a structure like this:
Category field selects from another table
Process field also selects from another table
Pressures field selects from a third table
Each row of Results has a unique combination of Category - Process - Pressures for which it provides numeric data (analysis results) in subsequent fields. How can I create a lookup with both Category and Process to identify the Pressures and numeric results? Another catch is that Process is also dependent on Category, as not all Processes are available to all Categories.
So ideally the user would choose a Category and then see available Processes. After selecting a Process, they get a report of all the Pressures with the numeric data in a report.
Possible in Airtable?
Solved! Go to Solution.
May 26, 2023 03:52 AM
re: ideally the user would choose a Category and then see available Processes
If you intend to let users submit data via a form, you can look up some third party tools like On2Air Forms, Fillout etc that help with this. Airtable doesn't currently support such functionality
---
re: How can I create a lookup with both Category and Process to identify the Pressures and numeric results?
Hm, could you provide some screenshots of the relevant tables please? I'm finding it hard to visualize how everything works here
May 26, 2023 03:52 AM
re: ideally the user would choose a Category and then see available Processes
If you intend to let users submit data via a form, you can look up some third party tools like On2Air Forms, Fillout etc that help with this. Airtable doesn't currently support such functionality
---
re: How can I create a lookup with both Category and Process to identify the Pressures and numeric results?
Hm, could you provide some screenshots of the relevant tables please? I'm finding it hard to visualize how everything works here
May 26, 2023 04:00 AM
How can I create a lookup with both Category and Process to identify the Pressures and numeric results?
vLookups (like what you used in Excel or Google Sheets) do not exist in Airtable. You need to manually link everything in Airtable, or create an automation that will do the linking for you.
May 28, 2023 05:37 PM
Thanks Adam! I figured out how to do everything with Fillout. 🙏