![]() Additionally, any information that is needed to help me with this I can post upon request. So, ultimately, I’m looking for direction on how to best integrate Excel (for reporting) with my Airtable environment. When I search the forums for Excel I can’t find any reference to it, which seems strange given, I expected my use case to be very common. I assumed integrating Excel would be easy, but as I mentioned earlier, I have not been able to make it work. That and I’m trying to move as much of the work onto an iPad as possible as that’s the platform most often used by the players and myself. but have no experience with JSON, Java or other web based tools.įrankly I’d use SQL Server or Access as the back end but making those available online given that this is all voluntary work and there is zero budget has proven difficult. Total rows is correct, but I can’t see any of the fields. I can get the connection created, but I only get a single field of “Record” values. I’ve attempted to connect Excel to Airtable with little success. Copy and paste into Excel’s advanced power query editor the. If you are looking to just copy and paste the code you need without much explanation, ignore the details :slightlysmilingface: Details. The next logical step is to create the output I need. Here is a way to automatically pull information from airtable into Excel via power-Query using a bit of coding. I’ve even been able to create and post the “forms” for users to input data and respond to events with their “bids”. Having done table design and DW/BI work in the past, I was able to build the table structure and views without any difficulty once I learned how the table linking worked in Airtable. The multiplayer game does not have any admin tools leaving us to develop our own solutions. I have setup AirTable to support a gaming group of which I’m the admin. I was going to post in the API section, but this seemed like a “broader” section to start with. If not, please direct me to the correct one. All they’d have to do is allow us to use this function as an action with their new automations.Īnd no, attachments would not get backed up that way, but has a stand-alone automated solution for that too and it works really well.Hopefully I’m posting this in the correct section. (If only Airtable had a better way to re-arrange / rename tables with lots of fields…)Īirtable’s own “Export to CSV” function doesn’t have that “garbage text” problem. ![]() It’s just that my inventory table has so many fields (120+) that adding even more just to work around the “garbage text” problem makes it a nightmare to work with. That way the additional field shows actual “text” that doesn’t turn into garbage text once exported. The “workaround” is to add an extra field next to every linked record field and configure it either as a “lookup” or as a “formula” field (pointing to the linked field). WRITER (CSV) | recgbyplnp4Qy7BOVQ (CSV) - when exported through Airtable’s CSV API (which or use). WRITER (Airtable Linked Field) | Steven King - becomes When backed up as CSV through an outside service ( for example), a linked record field does not come across as a name (data) but as an ID. It’s the same problem as with the another automated CSV backup solution through (which offer the exact same thing and even more solutions for a flat rate per month, regardless of the amount of records): The goal being to fetch like 1-100 tables at once, sanitize the dataset, and then perform consolidation (resolving relationships) based on one own’s business needs. ![]() Off topic, but I’m also currently working on a “fetch-airtable-dataset” project that I might open source eventually. More use-cases are possible compared to the API. There still isn’t everything I’d like (like, the actual formula being used), but it’s better than before. It’s much better than the API, there are more insight about the base structure (type of fields, options, etc.). ![]() Then, I use a diff tool to compare the generated output, and it allows me to see what structural differences there are between two bases. So, I changed my mind and eventually build a “print-base-structure” airtable app. Not true anymore, I played around with the Airtable Apps, and built, I wanted to deep-compare bases using an app, but faced a limitation that those data are only accessible for the current base. This article covers a number of these backup and restoration issues. Business logic embedded in formulas - for example - cannot be backup up at all. ![]() And to make matters worse, the vast critical elements of an Airtable solution cannot be accessed by the API or the integrated CSV export. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |