I am really very greatful for your time and input here. That said, I do understand data integrity and the fundamentals of relationship databases etc. Please forgive my ignorance here, I am relativity new to Airtable and have little experience of Zapier, neither, unfortunately, am I a programmer (one of the reason I am using this platform). Would we be able to use Zapier to inject these Qty values, thus overwriting those already in Airtable by matching records agaisnt the Product SKU (in the way we can do using mapped CSV import), rather than creating new records? If so, do you have any links to where I could best read up on how this is done? To explain in a little more detail, we have a table with a list of products and values associated with each product (Product SKU), such as inventory (Qty). I am interested to hear that we could use Zapier to inject data to an already formed Airtable table though. One day I will bite the bullet and get a handle on developing api connections :slightly_smiling_face: The truth of the matter is that the relative difficulty of generating good api connections (for the uneducated), as compared to using already available simplistic tools built into both our stock management platform (scheduled csv export routines) and the Airtable Import CSV Block is what is putting me off going down the api route. I am sure API would be a far better solution. In contrast, APIs avoid all of these issues. :winking_face: This is why they made the API. With Zapier, you can do more than just connect your apps - you can automate entire processes from beginning to end Check out the following list of triggers and actions you can use with Airtable, SendGrid, and Squarespace. In case it’s not apparent, I have a proclivity to avoid CSVs altogether and not withstanding legacy systems integration, the answer to automated CSV integration is to not do it. Do even more with Airtable + SendGrid + Squarespace. ![]() My curiosity is to understand the underlying requirements and how they could be made better. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |