Ask the Community

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?

Hi! I have a grid view with two columns, Start Date and End Date, that I have been manually updating to curate a calendar. I have started tying some of these line items together through the new Predecessor features, and since then have encountered a major issue where Airtable will automatically update dates to 0000 and 4049 in my Start Date and End Date columns. Help!

Looking for someone who can support me with a quick consult for my non profit, Modern States Education Alliance.My imported data table has over 9000 institutions ("School Name") with their CLEP Score and Credit Information By Exam. I was able to create an interface to filter by School Name and then display all of the Scores and Credit by Exam in two columns. I also created a Form to understand If a schoolAccepts CLEP credit,How much they charge to transcript the credit,How many credits they accepted,How simple this process was.Our goal at Modern States is to make college more affordable and accessible to everyone. This interface will serve as a space for our learners to share their journey and provide an updated CLEP by credit search. At the moment the College Board and individual schools do not maintain current records of the college credit b

I have a date+time and a duration (days: hours: minutes). I want to add a day:hour:minute duration to the date+time and output a new date+time. Issues I've encountered:1. I can only set a duration field to be day OR hours/minutes/seconds. 2. When attempting to create a formula to add a "Day" duration field to a "Hour" duration field the output is incorrect. For example I have a Day Duration field with "1" and in the Hour duration field I have 00:05. I triedDATEADD({Next Output Days},{Next Output HH:SS},'seconds')   Results in #ERROR!SUM({Next Output Days}+{Next Output HH:SS})   Results in 301?I'd be fine with a result of the total seconds of the day + hours/minutes to use for my final for

Hey guys!! So I am doing a project, and a need an airtable with the name of a restaurant and the position of it (in coordinates), I will use an API to extract my data from my airtable, but I need it to be in GEOJSON. Do I use the map app? How can I do this? Thank you guys!!

Is there any way to display the Button field only if the URL field it references has data? So if {resource link} is null, don't display anything. We have some users who are confused when the button doesn't work (not all the records will have a resource link). These are views which are shared publicly and not Airtable users. Thanks!

Following is the error I encounter :  npm warn deprecated source-map-url@0.4.1: See https://github.com/lydell/source-map-url#deprecatednpm warn deprecated urix@0.1.0: Please see https://github.com/lydell/urix#deprecatednpm warn deprecated resolve-url@0.2.1: https://github.com/lydell/resolve-url#deprecatednpm warn deprecated source-map-resolve@0.5.3: See https://github.com/lydell/source-map-resolve#deprecatednpm warn deprecated osenv@0.1.5: This package is no longer supported.npm warn deprecated inflight@1.0.6: This module is not supported, and leaks memory. Do not use it. Check out lru-cache if you want a good and te

Hello: Can you move a table to a different base? Thanks Julie

I am currently on the team free trial plan do I need the business plan to email non-collabaorators? I am trying to email every person I have on a table with the same email is there a way to bypass this through other services?

When applying this formula "{Pago a realizar}-{Pago efectuado}"  to the selected fields, as you can see in the 4 file, the result is not 0 but 1. How could I fix this error?

I have an Interface Detail Page that has a list of records.When i open a record it shows me a sort of modal column on the right and the url changes but it doesn't show an ID. Instead it gives me the "detail" parameter with a ver long string like this one "detail=eyJwYWdlSWQiOiJwYWdCeXBjZW9saHVvNXI2aiIsInJvd0lkIjoicmVjcXZseGk5SkJtcHluVXMiLCJzaG93Q29tbWVudHMiOmZhbHNlLCJxdWVyeU9yaWdpbkhpbnQiOm51bGf8".The question is where can i retrieve this long string?I'm working with Make so i want to change this parameter dynamically.I don't know if someone already asked this question, i didn't find any discussion with this problem so i made a new one.