Implementing a user-based system with Airtable

Ask us anything How do I?
, , , ,
1

Hey WeWeb Community,

Hope you’re all doing great! We’ve got a project update and we could really use your expertise.

In the following video I’ve explained the whole thing: To WeWeb Support (actorsbarcelona) | Loom

Briefly the whole situation:
So, here’s the scoop: Our website, www.actorsbarcelona.com, is where actors showcase their portfolios. Currently, we’ve got this nifty form connected to Airtable. Users fill it out, and bam, their info shows up on the site’s main page.

Now, we’re eyeing a move to WeWeb, aiming to keep this seamless process intact. On our current site, users manage their profiles using the same form. When they make changes, both Airtable and our website update automatically. We’re hoping to keep this magic alive with WeWeb.

Here’s where we’re stuck: We’ve set up a form on WeWeb similar to what we’ve got now, but we’re hitting some snags making it work smoothly. Any chance you could lend us a hand?

We’d be super grateful for any tips, tricks, or pointers you might have. Whether it’s a simple walkthrough, some docs, or even a quick video tutorial, anything to help us nail this transition would be awesome.

In a nutshell, here’s what we’re after:

  1. Getting existing data from Airtable into the form for each user.
  2. Letting users update their info on the same page/form when they log in.
  3. Making sure changes show up in both Airtable and the preview/listing on our site.

Oh, and quick heads-up: We’ve also got linked records in our Airtable setup. Wondering if there’s a way to tweak those and have everything sync up smoothly.

That’s about it! We’re really looking forward to tapping into the WeWeb community’s wisdom. Massive thanks in advance for any help you can offer!

Cheers,
Isaaq

2

Hi @IsaaqGray

So your website displaying portfolio will also be the website with the form, right ?

What do you use currently for your website ? How your user log in ?
You can’t log in using Airtable, but you can log in using a third party system (WeWeb Auth, or your own auth system), and then you will need to have a way to link the records between your auth system and airtable, by adding a column user_id in your airtable rows for exemple, containing the id of the user in the auth system.

Once it’s done your 3 points are doable. You can create a form page and fetch the right airtable record depending of the current user id (by adding a filter on the get record for exemple).
Same for update.

For the points 3 it depends, if your preview listing is on WeWeb and use a dynamic collection linked to Airtable it will be updated automatically. If it’s on another website it depends of how the other website get its data from Airtable, dynamically or statically. If dynamically there is nothing to do, if statically (when the website is published) then you may need a way to trigger a new publish.

3

Hey @Alexis thanks for replying. I’m using WeWeb Auth. So how do I link the records between WeWeb Auth and Airtable, by adding a column user_id in your airtable rows.

A tutorial or step by step tutorial would be very nice. Thanks.