Ask the Community

Tena Koutou! I got momentarily excited by the received webhook trigger in automations (old news I know, just got round to it seeming like a time saver!) only to learn that there is limited access to nested data within the json payload… I’m sending a payload via webhook from Typeform => Airtable. Works great. I just can’t access the nested data I need. super frustrating. Seems like a fairly standard issue feature to be able to access nested data within a JSON object. Has there been any update to this? Anyone have any work arounds that dont involve third parties? I’m happy proxying the webhook through vercel serveless function but just seemed like a quick win to manage it in airtable. Any advice hugely appreciated! Luke

Hello everyone! Good day! I have a quick question.Is there a way to upload a CSV or XLSX file in Airtable?We want to be able to streamline sales data in Airtable. We would download the file from Bol, and upload it in Airtable, so it updates automatically the right values. Any help is appreciated!Thank you! -Aisha

I've seen a few posts about using Stripe but we're hoping to use Square.The form is for a paid event and needs to collect a little bit of information before taking a payment to accept the booking.Again, I'm aware some folks have achieved this with Stripe and Zapier, Make or Fillout. I'm wondering if anyone's used Square?I want to really reduce friction here and make it as simple as possible, and I want to embed it into my website. So I'm essentially creating a checkout process. Can anyone help? Even just as a recommendation as to which of the automation tools would be the best bet here would be useful.

Hi, I have 3 Fields “Name” “Results” “Position” I will like to compare the values in “Results” Field and position it from ‘1st - last row’ (Field “Position”) If “Field Results” Row 1 or Record 1 is > Row 2, then Row 1 = “1st” else If “Results” Record 2 > Record 3, then Row 2 = “2nd” else if “Results” Record 2 = Record 1, then Row 2 = “1st” What I want the “Position” Field to do is, compare if Results Field Row 1 is Greater than Row 2 then Position Field Row 1 is equal to “1st” And if Results Field Row 2 is equal to Row 1 then Position Row 2 will be “1st” Or if Row 2 > row 3 then Position row 3 = “3rd” Finally if “Results” Row 1 = Row 2 then both "Position Row 1 and Row 2 will be “1st” But “Position” Row 3 will be “3rd” What formula do I use to achiev

Hi all – I’m brand new to Airtable and super excited about what it can do for our business. Has anyone tried migrating from the Streak CRM (which embeds within Gmail) to Airtable? Although I love Streak, it can get clunky for ongoing and complex relationships – and I think Airtable will be better suited to that. If any experienced Airtable users have already done this, I would love to learn from you!

Hello,I have a table called "applications" containing all the information of students who have applied for a grant. As part of the grant requirements, I'm requesting students to submit a final report. To facilitate this process, I'm using Fillout to populate a new table called "reports." One of the advantages of Fillout is its ability to edit form submissions, among other features not available in Airtable.Now, my question is regarding the setup of the "reports" table. I plan to use the students' emails as the primary field in the "reports" table. Since the same emails will already exist in the "applications" table, I want to link these primary fields to the corresponding emails in the "applications" table. This way, I can easily access and view all the information related to each student in one place.Is it possible to achieve this using an automation? Any suggestions or guidance on how to accomplish this would be greatly appreciated.Thank you.

Hello,I have a table called "applications" containing all the information of students who have applied for a grant. As part of the grant requirements, I'm requesting students to submit a final report. To facilitate this process, I'm using Fillout to populate a new table called "reports." One of the advantages of Fillout is its ability to edit form submissions, among other features not available in Airtable.Now, my question is regarding the setup of the "reports" table. I plan to use the students' emails as the primary field in the "reports" table. Since the same emails will already exist in the "applications" table, I want to link these primary fields to the corresponding emails in the "applications" table. This way, I can easily access and view all the information related to each student in one place.Is it possible to achieve this using an automation? Any suggestions or guidance on how to accomplish this would be greatly appreciated.Thank you.

This is a basic hack to sort a simple list of pre-determined roll-up values (e.g. 12 months) without a script or 3rd party automation.In the example below, month values from the Sub-items table are rolled up in Items table / Unsorted column.  Columns 'M1', 'M2', 'M3' use a REGEX_MATCH formula to check 'Unsorted' for the corresponding values.  The column 'Sorted' uses a series of IF statements to to join these together in the right order.  

We have a fleet of vehicles, with a entry_date and exit_date, we also categorise their type (passenger/commercial). I was hoping Airtable could graph (suspecting only line graph will work here) each month of the year (Jan 2023/Feb 2023/Mar 2023/etc) and the total count for passenger vehicles and commercial vehicles where the month of the year fell between the entry_date and exit_date. Has anyone done this before? Thanks for any help in advance!!

Hi, I am trying to design a scheduling tool for my business, and the timeline view is proving itself to be very handy. One think I can't quite work out is what 'precise' or 'expanded' does - in certain views. For example, if I have a morning and afternoon booking on the same day, when viewing the whole week, these display as 'full day bookings', and therefore take up two lines. I expected that 'precise' view would show these as two bookings on the same line (representing exactly the amount of time they take up), and 'expanded' to show as I've described, but that doesn't appear to be the case. I can't see why it wouldn't do that - as obviously the software can render records smaller - the month view demonstrates that. It would be great to see these bookings in a single line. Can anyone shed any light on whether this is designed behaviour, or something unusual in my setup?Thanks for the help,Richard 

Hello,I'm reaching out to inquire about a specific functionality within the Airtable API.I'm currently working on a project that involves duplicating a database template, including all of its tables, via the Airtable API. While I've explored the documentation and experimented with various endpoints, I haven't been able to find a straightforward solution for achieving this.Could anyone in the community kindly provide guidance or share if there's an API script available that facilitates the duplication of a database template along with all its tables? My goal is to automate this process as part of a larger project.Your insights, suggestions, or examples of how to achieve this would be immensely appreciated.Here's an example of the JSON script I've attempted to use:{"base_id": "YOUR_BASE_ID","new_name": "New_Base_Name","copy_tables": true,"workspace_id": "YOUR_WORKSPACE_ID"}Thank you all for your time a

Hey Airtable! I'm looking for some complex scheduling help. I'm using Airtable to schedule a multi stage music festival, and we're hoping to have a formula that will look for scheduling conflicts for individual performers at specific times. I have an example of how we have the scheduling started attached. The main record name is the act, and then we've created different set times for different stages across the three days. There are also individual performers listed for each set, since some performers will be playing in multiple bands. So basically, I want the formula to be looking for scheduling conflicts for individual performers during specific windows of time. Is this possible? Do I need to be building the worlds longest IF/THEN formula? Appreciate any advice!

Hello,I'm reaching out for assistance with an issue I've encountered while trying to interact with the Airtable API. Despite following the documentation provided by Airtable and ensuring that I've granted the necessary permissions, I'm consistently receiving an error message.Here's the API request I'm making:curl -X POST "https://api.airtable.com/v0/meta/bases" \-H "Authorization: Bearer YOUR_TOKEN" \-H "Content-Type: application/json" \--data '{"name": "Apartment Hunting","tables": [{"description": "A to-do list of places to visit","fields": [{"description": "Name of the apartment","name": "Name","type": "singleLineText"},{"name": "Address","type": "singleLineText"},{"name": "Visited","options": {"color": "greenBright","icon": "check"},"type": "ch

I connect all tokens and link and Rested post in account collectoin.but when I sent my test value I got this :"Select data to bind to the UI and/or use in another API request" Below is error message and this is is Jason body and then a test data. I am spending hours here. please help me      

Hey guys, I have a button in my Airtable that triggers a Zap in Zapier. I'm using this code: { "https://hooks.zapier.com/hooks/catch/14888220/30r6035/?recordID=" & RECORD_ID() }, but it's triggering the Zap twice. I'm also using multiple buttons, and it's not working as expected. Can you help me troubleshoot this?

Hi to all 🙂Maybe someone knows, is there a possibility to import archive Mbox files to Airtable?For every mail, new record in Airtable (sender, receiver, date, Subject, Content, Attachments, etc.)Thanks aheadRegards, Imelda

Hey amazing people 🙂 I have a rollup field puling in unique values, and I really would like it sorted (in this case by ascending date) but I can't figure out how to do that? Community Search didn't bring much up for me.Here are my settings:And here is my display result I would like to see "March 3rd, 2023" March 4th, 2023" "March 5th, 2023"It seems to pull in based on the order of my current Top view in the Table it is pulling from, but even swapping the View with the sort order I want didn't seem to change anything (And I don't want that view at the top anyway)Any ideas?

I have 2 tables with a many-to-many relationship...Companies companyName, companyCountries (linked to Countries table)Countries countryName, projectPhase, countryCompanies (linked to Companies table)The projectPhase is country level, for example...GB = "go live"JP = "phase 2"MY = "go live"US = "phase 2"1 company can have multiple countries, and so on the Companies level I've created a rollup using ARRAYUNIQUE(values) but I've run into a problem with a scenario like this...CompanyA is live in GB and JP and shows "go live, phase 2" CompanyB is live in JP and MY and shows "phase 2, go live"I've read a bunch of posts on this behaviour and how the rollup retains the sort order of the original linked source (in this case Countries), but my Countries table needs to be ordered as it is, and there's so much variation in my companies data that regardless of t

Hello everybody, at first I set one column in my table 1 so that I can link it to items of records from a different table 2 (via multi-linking to record). Then I wish to fill a different column in table 1 through rollup function with another matching item of the same records from table 2. Problem is, that the order inside the rollup column is automatically opposite to the order in the first column linking to the record. I would like to have the same order in both columns, but I cannot set anything about the order connected to the rollup function. Can anybody help, please?

Hello, I'm looking for a WordPress plugin that would allow this: For each new entry in an Airtable table, retrieve the images and text and insert them into a defined WordPress page (always the same, it would be to create an image and text library...)thank you.

Hi everyone,  I'm trying to be proactive with the the imminent change to the integration with Airtable. I've connect Zapier via the App Update (Presumably using OAuth) and connected Make with an OAuth connection.  However, I expected to see the connection appear in Airtable under the developers OAuth section but there is nothing. How would I manage and revoke these connections if I can't see themCheers all, Jason   

The new Interface feature allows you to filter a collaborator field by “current user” which is a great time saver. Anyone know if they will make this available in regular AirTable views? I really need it.

Hi,We have a scoring system that rates functionality in an interface. So as not to bias the total score, if the functionality isn't present we ask evaluators to give it a -1.In Excel, the final score is determined by a formula that:Counts the number of criteria where the score is >= 0Determines a max possible score based on the number of criteria scored (e.g., there are 10 criteria in a category but only 9 of them got scored the max possible score is 9*3=27 (9 criteria scored * highest possible score))Adds the values for each of the criteria scored to get the actual totalI'm able to use sum to get the total score but I'm not sure how to get the number of criteria scored without using countif which Airtable doesn't seem to have.Is there a way

Suppose you have a series of records that include zip codes. There may be many of one zip code and a few of a bunch of others. How do I get a list of the frequency of these zip codes? So 14757 occurs 6 times and 14722 occurs 9 times and 20021 occurs 3 times, etc. I want to get a list of the zip codes by how often they occur and if possible a count of that frequency.Any thoughts would be greatly appreciated.Scott

I expect this is beyond what Airtable / 3rd party automations can do but if achievable this would be an absolute game changer for me. I would like to create three fields. Field 1 (Single Line Text) / Field 2 (Attachment) / Field 3 (Attachment).In Field 1 - I enter the name of an employee. In Filed 2 - I attach a multipage pdf. Then in Field 3 - I get the multipage pdf with the individuals name across it as a watermark.I've tried programs Zapier, CraftMyPDF, pypdf but hitting hurdles throughout. Any ideas are enormously welcome.