Any way to automate page creation

  • I’m going to be hacking away at the above page but, you’ll get the issue.

    I have about 75 records in a single table in my base, and hope to add many more. Do I need to create a unique page for each row in my table? I assume I can build a WordPress template that would auto populate the content. I’m gathering that would only work if I manually make a unique page for each first col (ID column) in the Airtable table where the page name matches the page slug.

    What I’m hoping I’m missing is the ability to point a template at a table and the 75 individual pages would be auto-generated.

    Finally, I would love to have individual pages for each row as that should boost SEO significantly.

    I’m using Airtable Pro thanks to them so I can build out this Covid pandemic related site.

    Stay safe and thank you!

    • This topic was modified 4 years, 7 months ago by bizwizkid.

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)

  • Three possibilities pop up in my head when reading this:

    1. I’m not too familiar with this part of Airpress myself, but isn’t the “Virtual Posts” functionality kind of what you’re looking for?
    2. Both Airtable and WordPress have an API. You could write a script (which you trigger either semi-manual or automatically with a cron job) that fetches your new airtable records and creates a post/page for that in wordpress. The theming should handle the actual content, like you say.
      So basically that post/page creation is all you need, and if you’re savvy with the api’s it shouldn’t be that big of a hassle I think.
    3. Another thing you could try is to just use a GET parameter in the url of each post/page, like “?pageID=123”, where the pageID points to a record in your Airtable, and which you read out in your template file and then get the airpress data according this parameter.
      SEO might be a concern here though, and the only way these pages could “exist” in the website tree is to link to them of course, but I’m assuming you’ll have a listing page. And to establish that listing you also have to read out your airpress data, but that shouldn’t be too hard.
    Plugin Author Chester McLaughlin

    (@chetmac)

    Create two pages in WordPress. The first titled “AIRPRESS: List” and the second titled “AIRPRESS: Item”

    Then create two VirtualPosts in Airpress.

    Virtual Post 1
    URL Pattern to Match: ^my-items/?$
    Test URL: my-items/
    Map to this page: AIRPRESS: List
    Leave filter by formula blank for now as this will match all records in the specified table.

    Virtual Post 2
    URL Pattern to Match: ^my-items/([^/]+)/?$
    Test URL: my-items/recXXXXXXX
    filterByFormula: RECORD_ID() = “$1”
    This will search the specified table for a record with the id of recXXXXXXX

    If you’d like help you can schedule a support screenshare at https://chetmac.setmore.com/

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Any way to automate page creation’ is closed to new replies.