Zapier airtable across multiple fields3/21/2024 I’m sure that many other people have submitted feedback as well. This is disturbing to me that nobody is committed to that task anymore, particularly since I’ve submitted at least 25 pieces of feedback since then and I’m just one person. Airtable Support used to make updates to their support articles based on user feedback (through the form at the bottom of each support article), but they confirmed with me that they haven’t updated any articles based on user feedback in over a year now. Whether that implies “bug” or “idiosyncrasy” is a matter of debate, but yes, the bigger problem is that these issues aren’t officially documented by Airtable. In the end, knowing as much detail as possible about all of the fields involved helps a lot when trying to work out a solution for a specific use case.Īirtable Support has responded to many of my emails regarding these field types as “known issues” (their words) that currently require “workarounds” (their words). If that rollup field is receiving data that has been previously looked up or rolled up or even processed by a formula, that complicates things even further. The problem is that some users just say “I have a rollup field” without talking about the data that rollup field is receiving, and how many linked records are involved. Some are working with rolled up dates, others with rolled up strings or numbers. A bug? I don’t think I find it hard to provide a single “good solution” to the original question because each situation is likely to be slightly different. However, it’s actually being fed a string with those separating commas baked in. Because the primary field values from multiple linked records will be fed to a formula field as a comma-separated list of items-which is the same thing that lookup fields do-it’s often assumed that the formula field is being fed an array. This inconsistency alone led me to create a table to document as much as I could figure out about lookup fields and how they pass data collected from linked records: Airtable - Airtable Field ReferenceĪnother issue is with linked record fields themselves. The problem is in figuring out those rules because they’re not all documented.įor example, lookup fields most often return arrays when queried by a formula, but not always. If you understand the rules for how each field operates, things are easier to set up. There may be inconsistencies across field types, but that doesn’t make them bugs. The things you’re referring to feel more like idiosyncrasies to me. I’m hesitant to cast such a wide net and call all of these behaviors “bugs.” To me bugs are cases where a feature is documented and intended to work one way but it works a completely different way, or just flat-out breaks and doesn’t work at all. Airtable has absolutely no shortage of bugs when it comes to arrays, rollup fields, lookup fields, multi select fields, and much more.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |