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
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....
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
yes
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.
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.