Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Mar 11, 2018 09:30 AM
Is it possible to pass variables from a webpage of mine to my base view it so that airtable is “prefiltered” for the user according to how they on the webpage?
I imagine something like a drop down menu on the website where people can filter and search for specific rows in the airtable view that they get sent to.
Thanks!
Mar 11, 2018 10:16 AM
Hi Henry, yes this is done using URLs and Airtable’s query language - it takes you to the data in a tabular format though, and not in an actual Airtable view. I have set up quite a few including this very basic example:
I’m not sure I can think of how to get to the precise behaviour you describe, where the user opens a pre-filtered Airtable with the same front-end etc, but if the table version (above) would be of interest please let me know. In my example the results show in an iframe but you could do this in a number of alternative ways. The API documentation for your particular base will show how to construct URL queries as needed.
All the best,
Oli
Mar 11, 2018 11:52 AM
Oli,
This is precisely what I am envisioning! Thank you for the image example it is very clear. What is the best way we can connect?
Mar 11, 2018 01:19 PM
Oh that’s good to hear, glad it is helpful :slightly_smiling_face: ️
I work exclusively through Fiverr https://www.fiverr.com/s2/e5494ef495
Have set my profile there to Vacation Mode while I work through a relatively busy patch with many projects; but if you sign up using the link above, and message my profile, we can discuss the details then create a custom Gig to make sure you get exactly what you’re looking for. Hope that sounds good! Any issues sending my profile a message, please let me know below and I can help.
Looking forward to finding out more about your project.
All the best,
Oli
Mar 11, 2018 08:54 PM
Hi Henry,
I could help you out on this.
Feel free to email me on andrewjohnson56782@gmail.com
Best Wishes,
Andrew
Mar 13, 2018 01:38 PM
Hi Henry,
As @Oli_Steadman said you can do that using Airtable’s API.
In this quick example, only data for fields selected will be included into the table.
Using the API you can display data according to any parameter you need and even update or transform records.
Regards.