Use Airtable for all collections including users

Get Help Database
1

I am migrating my collections to Airtable and I am facing an issue with the Users. I have found this closed topic Integrate/Update Adalo User database with Airtable or another 3rd party platform
where it seems that the only solution is to manually bind the Adalo Users collection with another Airtable Users collections by writing custom POST a PUT actions. Is there something I am missing?

This is a serious limitation as using Airtable as a backend for a no-code app is nowadays a go-to since it can stand for a whole admin/erp.

2

Here is a tutorial about connecting to Airtable

It creates and external collection which you and working with like an internal collection.

3

It does not work for the specific ā€œUsersā€ database

4

Hi @clemlaflemme,

Youā€™re right, it doesnā€™t work with ā€œUsersā€ database. Moreover, as far as I know itā€™s not possible to use Airtable to store Users using ā€œExternal usersā€ capability (which is now in beta testing). Such capability needs to have a Login API endpoint, which is not the case in Airtable.

Theoretically, you can create Signup and Login API endpoints by yourself, using some external serviceā€¦ and then try to integrate it into the Airtableā€¦ and then try to integrate all this with Adaloā€¦ but Iā€™m not sure how much time will it take :).

Best,
Victor.

1 Like
5

Hey Vitor. I did it with Directus (GitHub - directus/directus: The Modern Data Stack šŸ° ā€” Directus is an instant REST+GraphQL API and intuitive no-code data collaboration app for any SQL database.), but Adaloā€™s external user auth is a pretty bug right now. I donā€™t see why Adaloā€™s Team is calling it Beta it should be alpha release or even more primitive than that. It may get better along this year but for the production environment I donā€™t trust external auth as it is now.

1 Like
6

Yah dude, tried doing this and it was a little cumbersome to say the least.

1 Like
7

Hi @brunoribeiro,

Interesting. You installed it on some Linux server or there is an easier way (from maintenance perspective)? Could it be somehow installed as a PaaS/SaaS solution?

Best regards, Victor.

8

I am using a Digital Ocean Droplet (NYC3) location. Itā€™s really close to the Adalo server and the latency is almost real-time. There is a one-click option for Directus (https://marketplace.digitalocean.com/apps/directus). So, as self-hosted Directus is free, but you can also use their paid cloud solution. https://directus.io/on-demand-cloud/ I tried many headless options, but none of them was so flexible as Directus.

1 Like
9

Have you tried the nocodb? (https://nocodb.com/)

My idea is to integrate postgres with appsheet and adalo with api rest