Ask the Community

When the lookup value is a field with multiple records, is there a way to filter the returned linked records and extract one field from it?For simplicity's sake, suppose that I have the following 4 tables1. Products - generic information about products2. Vendors - info about vendors3. vendor_products - products that vendors carry (i.e. vendor pricing), linked fields to products and vendors4. invoice line items - columns to select product, vendor, lookup field with vendor_products from vendorOn the invoice line item, I would like to be able to also filter the vendor_product by the selected product and then extract the price for it.  Is this possible?    

I am using LIST records API to retrieve data from the table.I am needing to get all the records every time. This is acceptable, but no ideal.My client's table has no field that mark when a row is created or edited/updated. Does this of function already exist? If so, How would I grab only the records that were added or changed since the last update? BTW: using this API call:https://api.airtable.com/v0/xxxxxxxxxxxxxxxxxx/$$tablename$$Thanks,Scott

I'm going based on this: https://airtable.com/developers/web/api/create-commentThe authorization is fine, but for some reason within scripting it keeps giving the error that the body isn't parsable. My script is as follows:    //Variables let inputConfig = input.config(); let recordID = inputConfig.recordID; let commentContent = "Hello World"; let url = 'https://api.airtable.com/v0/appksePpf16d6MPdp/tbl4ZEftsWgo84Ldu/' + recordID + '/comments'; console.log(commentContent); //Create the Comment let response = await fetch(url, { method: 'POST', headers: { 'Authorization': 'Bearer [private]', 'Content-Type': 'application/json', }, body: { //For some reason, it's not accepting this body 'text': commentContent } }); console.log(await response.text()); //console.log(await response.json());  &n

Many departments in my workplace heavily rely on automations. Towards the end of month, we sometimes reach a limit of around 30,000 and it's a hassle linking records manually.Earlier I just changed a filter and triggered 17,000 automation runs before I could disable the bad automation, which sends emails when a record is created in a synced view.... It's only the beginning of the month. I'm stressing out. I had optimized and sacrificed many automations; I undid all that work in an instant.What should I do to prevent automations from entirely stopping in two weeks?

I have a simple automation set up to send an email when a record is updated. The email includes a link to a Google doc for that particular record. The automation works most of the time, but I've run into situations where the URL for the Google Doc in Airtable gets modified when it comes through in email. For some reason, the underscores in the link get removed. See arrows in attached screenshot. The top URL is the correct one in Airtable, the bottom URL is what comes through in the email. I have other records in Airtable that also have underscores in the google doc URL and those comes through fine. It just seems to be random docs that this is happening with.Any ideas how to fix? 

Hey guys, I have a need but I don’t know if it’s possible, I need save data from an airtable in Excel or CSV and send attachment via email It is possible? I appreciate any help or idea.

Hi,I am wondering if there is an audit trail for users outside of the records itself? We've had an important record deleted and we would like to find out who did it.Thanks,Ellie

For the life of me can't figure this out...Imagine a non-human resource scheduling system (ie hotel rooms - not really, but close enough). We would like to be able to use timeline view to list all 'rooms' in the building, so that 'booking agents' can distribute incoming guests among available rooms.What we've done is create a table called 'rooms' and create a table called 'bookings', with bookings table having a timeline view, with records being grouped by 'room' on the Y axis and booking duration on X axis.The problem is that airtable timeline view only shows rooms that have bookings assigned to them. If a room has 0 bookings, it does not show us on the Y axis. How can we make it so that resources show up on the Y axis of the timeline, regardless of whether they have bookings on them? lack of this feature is the only thing holding us back from migrating from a 20 year old ERP system. the reason we can't use calendar or grid view for this i

 How can I make it 2024-08-31 6:30 PM PDT like how the record is in my airtable base? I don't want that T or Z at the end and the seconds and the decimal to be shown either.

I am working with make + airtable but when i try to write the date + time in my airtable with the data from make the date applies correctly but not the hour. It always insert 00:00 time. What is wrong here? thanks in advance. 

I want to paste a string of text into a linked cell and have it recognize the linked relationship. I have about 2,000 lines of data to copy and paste into Airtable. For example, I want to copy the following addresses into cells where the cells link to another table. 123 Main Street, Anywhere, CA, 90210 578 Main Street, Anywhere, CA, 90215 I have not had any luck in pasting it or in the cells recognizing the link. I have also tried “wrapping” the text string in commas as follows: “123 Main Street, Anywhere, CA, 90210” “578 Main Street, Anywhere, CA, 90215” No luck with that method either. Any suggestions? Thanks

I have a base where I have separated expenses into a few different tables. I did that to make it a little clearer for me as it became so cluttered. But now it’s hard to add up the prices and compare. How do I create a dashboard that truly just takes the sum of one column from each table that I have? For ex: I have a table for health insurance, car matinence & lease payments. How would I create a dashboard like summary where I can display the total sum of each of these? So it would look like: I tried linking, rollup and lookup but just can’t figure it out. I have used airspace for a long time, but only for simple data entry. I do not have pro.

I want to display a field taken from one of my records from my fillout form but I want to make it uneditable. I am using the form to update already made records but I want to display a field but make it uneditable. Is there a way to do this? 

How can I change the API key to access token and get records on my browserhttps://api.airtable.com/v0/appJiy**pcKfS****p/Users?&api_key=keycj***N8PUCH***Previously it works like this^^^∆

Hi,I add a grid in my email automation.when I insert the grid I want the grid to be Right to left.right now its left to right like here:is it possible to make it Right to left so the supplier will be on the right side?Thanks. 

I was just wondering if there was a way for an airtable form submission to be edit-able. It’s annoying how everytime a form is submitted it shows up as a new entry when someone perhaps wants to go back and revise an existing form entry. I know Google forms has this. Is there any way for Airtable to do this?

Is there a way to sort the records randomly (not alphabetically)? Say I have a table of students and I want them to be randomly ordered for a presentation or something?

hello - i created a button field that triggers an email via sendgrid integration. while this functionality is possible as a creator/internal user, it is not possible (i.e., button not clickable) when a shared view is generated and viewed as a non-internal user. is there a way to allow non-internal users who view the shared view to click the button to generate the email?

I have three tables - deals, project, and a join table that connects deals and project. The deals table is connected to the project table through a linked field, creating a 1:1 relationship. I am trying to link the join table to the project table based on the linked field in the deals table. I am using the Airtable ID for the linked record from the deals table and inputting it into the "link to project" field in the join table, but I am encountering an error."Error: Field "fldxxxxxxxxx" cannot accept the provided value: invalid item in array cell: foreign record is invalid: foreignTableId is incorrect."I'm getting the correct id for projectID field as I've double checked but still it is not getting linked to the "Link to projects" field. Please do let me know if more detail is required or if anyone has any solution to this?

Hi folks. I’m trying to create a way to allow a member of our team to edit a shared view, and I’ve reached a snag. Here’s what I’ve done so far: Created a synced table in a new database using the data from the shared view Added 3 new columns in the new table for adding information to individual records Created an automation in the new table that makes a new row in a google sheet every time a particular column meets a condition All that works. And here’s where I’m snagged: Creating an automation in the original database that updates the changed record whenever a new row is added to the google sheet - BUT: When I use the Record ID from the new synced table, it doesn’t match the Record ID of the original table, so I get a “record doesn’t exist” error When I use one of the other field values from the new google sheet row to identify the record, I get an “Received invalid inputs” error

I have an automation that emails a list of people every time a record is created and within that email is a formula field that concatenates a date with several other fields but the problem is in all the emails the date and time is always 7 hours ahead. How do I make it so it sends only in pacific standard time? 

HI GuysI was very specific in the question subject for a reason that anyone reading this will nod, say "oh, that" and cry into a coffee. Im at the final step of a looooong loop of data, and I need to now put multiple public attachments into a single attachment field in Airtable. I cant use Make for this, has to be Zapier. And i need to turn a simple array into a complex array so that the attachment field doesnt overwrite.Also, a huge thank you to @scottsworld for giving me a lot of the knowledge that got me this far without jumping off a cliffAnyone know how to do this? I have the public URL's (that was another adventure) and the data, now I just need to make it work. Picture tax - a cat, searching a map. This work we are doing is for a cat charity and you all like cats. I mean, who doesnt .

I have a CRM database with a table called Companies. These Companies have columns that are linked to different tables called Country and Sector. I would like to create a new table, a Market Matrix of sorts, that automatically rolls up the companies in Country A + Sector B, which would also include notes and different properties on the country/sector in question. What is the best way to accomplish this? Thank you in advance! I'm relatively new to this so any help most appreciated. 

I have created automation when the condition matches  and assigned to person "A" then it should email person "A"In the same automation, I would like to add another condition whereas if assigned person is "B" then it should email person "B" only. How can I add multiple action in one automation whereas based on each action the email goes to a different person.  Please see attached screenshot.  

I am looking to take a field that has a total amount of seconds and have it formulate into a duration.E.g. My "seconds" field set as 210 would populate in my formula field as 00:03:30:000.Does anyone have a formula solution for this?