use as airtable back databases and as wix database collection link or airtable wix database synchronization ?

Ask the community
,
1

Hi; I did a lot of research on this subject but I could not find a definitive solution. (I am not a software expert and I do not have code knowledge … unfortunately)

Actually, there are many close solutions or a subject written about it, but nobody has explained it with a clear solution or result.

wix database disadvantages;
1- delete data or copy and paste restricted operation

2- There is no automatic repetitive comparison in csv loading. such an option must be at least for the specified column.

3- There should be simple modules that make the job easier for all types of users, but you must either know a good level of code or hire someone. This is deviating from the wix mission because if I hire someone, why should I deal with it? I would give the website to do it to someone as a whole package business, right?

The airtable has many advantages and is constantly renewing itself. But he has his own disadvantages.

As a result, the combination of wix and airtable can create great work.

just a solution that will provide the need wix and airtable connection.

but how ?

https://www.npmjs.com/package/gatsby-source-airtable

https://awesomejs.dev/for/gatsby/pkg/258254208451478026/

https://dev.to/sethu/how-to-build-a-website-using-gatsby-airtable-in-30-mins-42gm

https://www.digitalocean.com/community/tutorials/gatsbyjs-using-airtable-with-gatsby


There are some methods in this regard, but they are advanced for me. There is an airtable and gastby module in wix, but I don’t know how to proceed or combine solutions including the solutions I sent as an example. If you write me a solution that I can do step by step, I would be very pleased. I’m sure it helps a lot of people.

thanks for helping

2 Likes
2

I’m not sure what your problem is. Your point #1 isn’t accurate. And your point #3 seems to say that Wix Data is too difficult, but yet you are trying to figure out how to use an external database, which is complex to integrate, difficult to configure, and will be more difficult to maintain. As a non-coder, you will especially appreciate the power of connecting data .

I suggest you review the Wix Data documentation . You will see how it even allows non-code solutions in many cases, and most of the coding solutions are straightforward and simple.

Also, refer to the Wix Data and the Wix Dataset APIs.

3

Hi; @Yisrael
thanks for the answer, but! The problem does not include an example configuration here. As I wrote above, as someone who does not know code, it will either take quite a while or you will have to find another way.

I am sharing an example from another platform. As you can see, you can easily add the airtable database as a collection and update it with a button, without writing code or dealing with any additional work (such as super convenience and solutions for creating a wix website). without any code.! (While wix makes site creation so easy and great, I don’t understand why it doesn’t show the same sensitivity on these issues.)

my problem is this;

I want to integrate my airtable databases into the wix database. or I want to create dynamic pages that will display the data in my airtable database on my wix website, and make an interface that I can search the data and display in the repeater.

but without an exemplary configuration model, it seems very difficult or very time-consuming to proceed.

Module pictures of the example that can be made more easily in the portal other than Wix (wix will be very useful to add modules in this regard.)

1143×539 39.8 KB

795×640 29.5 KB

1384×854 131 KB

4

The Airtable database is not integrated with Wix. If you want to integrage with Airtable, see the article Corvid: Working with External Database Collections. Since you are not a coder or IT person, this is probably not an option for you.

5

yes

6

I have published a solution fro beginners / non-techies as a Udemy course here…

https://www.udemy.com/course/integrating-airtable-and-other-3rd-party-api-data-into-wix/learn/lecture/22005838#overview

I give you the Code you need to use the Wix job scheduler to refresh your Airtable data with an automated job once every hour. I use it on my own site. Or you can refresh based on a button click. Up to you. Example using button press is here:

https://www.airtablist.com/example-repeater

7

BTW - To save you some time - Airtable-plus node module returns all Airtable data in one call… It starts to crash at over 1000-2000 records for a reasonable size table. It is not performant. I got it working but abandoned it… instead I wrote my own code that handles the Airtable 100 record pagination and just loops through and loads 100 records at a time…quickly…