Mar 04, 2023 08:07 AM
I have a file with booking/reservation information, which is updated once a week.
Since the export is different from the table (names, etc), I have to adjust the fields for the import every single time when I import the information again.
Is there a way to simplify this with an external, 3frd party, integration?
Thanks for your help.
Mar 04, 2023 11:45 PM
What file type is it? If it's a CSV, tools like Zapier, Make etc can read CSV files and you can connect that to actions that will create records in Airtable as needed
Out of curiousity, any chance you can just cut out using the file entirely and use Zapier / Make etc to pull data from your source directly instead?
Mar 05, 2023 08:20 AM
I can't access the source software directly, unfortunately. It's that good, that they don't even have all fields in their export. Still manual work needs to be done. We are planning to develop everything with airtable slowly.
I will look into zapier / make. Thanks.
Mar 05, 2023 06:01 PM
Roger that. I forgot to mention that Airtable has its own Sync API that you could maybe also use for this? Documentation
Best of luck. I'm really curious about how you end up handling this issue as well, and if you could let me know what you settle on in the future I'd really appreciate it! No worries either way
Mar 12, 2023 12:39 PM
Unfortunately, I could not get a Zapier-based import with field mapping. So technically, the records can be created or imported, but I can't select where the data will go.
I will stop wasting time and think of another solution until there is better support with Zapier.
In case one of you has better success, please let me know.