# Create a dynamic page in WeWeb for a single record from Airtable **URL:** \ **Category:** Ask us anything\ **Tags:** binding\ **Created:** [August 6, 2023, 10:49pm UTC](https://community.weweb.io/t/create-a-dynamic-page-in-weweb-for-a-single-record-from-airtable/3796 "2023-08-06T22:49:43Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![gary](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/gary/32/4239_2.png) [@gary](https://community.weweb.io/u/gary)\ **Post date:** [August 6, 2023, 10:49pm UTC](https://community.weweb.io/t/create-a-dynamic-page-in-weweb-for-a-single-record-from-airtable/3796/1 "2023-08-06T22:49:43Z")
I am building my first WeWeb application with Airtable as a data source. I’ve been able to bind and display a list of collection items on a page, but I want to create pages that display single records without requiring the user to view the entire collection. For example, I have a table in Airtable called Orders, and I want to create a page in WeWeb for Order Details including information like Order Name, Order Number, Order Total, etc. I want this WeWeb page to be located at [domain.com/orders/{airtable\_record\_id}](http://domain.com/orders/%7Bairtable_record_id%7D). I want users to be able to access these pages _without_ needing to navigate through a collection page. I want the user to receive an email, click on a link, and view the page displaying the Airtable record’s data. But I cannot seems to figure out how to use parameters in a URL path to achieve this. Note that I am not a software engineer, so this may be a basic concept for others, but for me it is unclear even after reviewing the WeWeb documentation. Any guidance would be appreciated. ---
**Author:** ![Joyce](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/joyce/32/13232_2.png) [@Joyce](https://community.weweb.io/u/Joyce)\ **Post date:** [August 7, 2023, 1:26pm UTC](https://community.weweb.io/t/create-a-dynamic-page-in-weweb-for-a-single-record-from-airtable/3796/2 "2023-08-07T13:26:55Z")
Hi @gary 👋 Ok cool, this is completely doable 🙂 The approach will be different depending on whether you’re using a static or dynamic collection. Since it’s a list of orders and I’m guessing you can have thousands if not millions of orders and there’s no need for SEO, I would recommend creating a dynamic collection page. Have you seen [this video](https://youtu.be/mLM8EY0Ub5w?t=683)? In that video, we show 2 approaches to dynamic collection pages, one with a variable, one with an API call. In your case, you’ll need to follow the API call approach. Does that help? ---
**Author:** ![gary](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/gary/32/4239_2.png) [@gary](https://community.weweb.io/u/gary)\ **Post date:** [August 7, 2023, 3:16pm UTC](https://community.weweb.io/t/create-a-dynamic-page-in-weweb-for-a-single-record-from-airtable/3796/3 "2023-08-07T15:16:21Z")
@Joyce Thank you for your quick response and the video. I did watch the video previously before posting here, but since it’s referencing Xano (and I’m using the Airtable integration) I didn’t know if the approach would be the same. Should I be connecting to Airtable using the Airtable API _or_ the WeWeb integration with Airtable? ---
**Author:** ![Joyce](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/joyce/32/13232_2.png) [@Joyce](https://community.weweb.io/u/Joyce)\ **Post date:** [August 7, 2023, 4:42pm UTC](https://community.weweb.io/t/create-a-dynamic-page-in-weweb-for-a-single-record-from-airtable/3796/4 "2023-08-07T16:42:57Z")
Aaaah ok, got it! Didn’t think about that but indeed the approach would be a bit different with Airtable as the database. You’ll need to use the “Filter by formula” feature. Here’s a [video explaining how to do it](https://tella.video/gary-dynamic-with-airtable-adjj). The `SEARCH` formula can be a bit tricky to set up so you might want to refer to [our user docs](https://docs.weweb.io/plugins/data-sources/airtable-data.html#filters-by-formula) on the topic. PS: I’d definitely recommend using our Airtable integration because all the API calls you make with the REST API plugin are visible in the user’s browser and you wouldn’t want to share your secret Airtable key there 🙂 ---
**Author:** ![gary](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/gary/32/4239_2.png) [@gary](https://community.weweb.io/u/gary)\ **Post date:** [August 7, 2023, 5:40pm UTC](https://community.weweb.io/t/create-a-dynamic-page-in-weweb-for-a-single-record-from-airtable/3796/5 "2023-08-07T17:40:16Z")
> [@Joyce](#): > > our user docs Thank you very much for the helpful video! I am now much more clear on how to use WeWeb’s Airtable integration and closer to being unblocked! Unfortunately, now I’m receiving an error which I’ve pasted below. message: “The operation cannot be processed” This is a rather vague error with no error code, so it’s unclear what the problem is. But it is progress regardless. I am grateful for your wonderful assistance here. ---
**Author:** ![gary](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/gary/32/4239_2.png) [@gary](https://community.weweb.io/u/gary)\ **Post date:** [August 7, 2023, 6:15pm UTC](https://community.weweb.io/t/create-a-dynamic-page-in-weweb-for-a-single-record-from-airtable/3796/6 "2023-08-07T18:15:08Z")
Update: Now I’m seeing no data returned for my Order Details collection. The error is below. No data fetched (Empty array) My formula is as folows. ‘SEARCH(" ’ + context.pageParameters[‘order\_id’] + ’ ", Slug)’ **order\_id** is the page parameter, and **Slug** is a formula field I created in Airtable to display the hidden Record ID. And although I can find the same record in Airtable, it’s missing from the API response. Very strange. ---
**Author:** ![gary](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/gary/32/4239_2.png) [@gary](https://community.weweb.io/u/gary)\ **Post date:** [August 7, 2023, 6:27pm UTC](https://community.weweb.io/t/create-a-dynamic-page-in-weweb-for-a-single-record-from-airtable/3796/7 "2023-08-07T18:27:37Z")
Update: At last! The problem I was having with empty results was caused by extra spaces between the " and ’ characters in the formula. Now I’m seeing the record returned via the formula.