Join the Webstudio community

Updated 7 months ago

Help connecting AiTable to Webstudio CMS

At a glance

I'm trying to connect AiTable.ai to a collection to host my blog posts. I've been following the video @John Siciliano put up conencting Airtable as the front end, pretty similar set up. I got to the point in the video (about 5:40) where you have to edit the api URL. I tried to enter what John used in the editor, but it's not pulling data. I've looked at the AiTable api docs, but it's beyond anything I can comprehend. Any help is much appreciated!

Attachments

15 comments

BBogdan

use ticks instead of quotes

Plain Text

`${myVariable}`

OOleg Isonen

back ticks

OOleg Isonen

BBryan

Here's what my final expression looks like using AITable. That's farther along than you are now, but you can see that I had to use the SEARCH() text function with filterByFormula.

Attachment

BBryan

https://help.aitable.ai/docs/guide/manual-formula-text-functions#search

BBryan

script_title is the name of my form text input field in Webstudio.
title is my field name in AITable (where to search for what's entered in the form field)

OOleg Isonen

we need a beter UI for such complex queries, so it can be distinct prop/value list instead of one big string

RRonald from 360Creators

Here's what I use with Airtable to get the slug

Attachment

OOleg Isonen

looks like you have no need for single quotes

OOleg Isonen

easerier to read using template syntax:

Plain Text

`http....?whatever${variable}`

RRonald from 360Creators

ohh nice, thanks!

RRonald from 360Creators

Doesn't seem to work. I've tried various things with and without the dollarsign or {}. What am I doing wrong here? Should the {⚡️ Slug} also have a $ sign?

Attachment

RRonald from 360Creators

Plain Text

'https://api.airtable.com/v0/appk2iZaWQLO3Tqvx/tblbYRGFgCo9u2VpB?filterByFormula={⚡️ Slug}= ${system.params.slug}'

BBogdan

Should be backticks `` not single quotes ''

BBogdan

https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Template_literals

Add a reply