Solved

Hi All, On my PC I have observed the following behaviour. We I want to creat a new record I can either a. click on the ±sign, b. right mouse click and choose for Insert record. Use All well However: When I click (accidently) on any field below the last record automatically a new blank record is created with a new line number Clinking in any field below the last genuie record New blank record is created By user errors a lot of blank and meaningless records arethus created. At the end of the day I have to remove them manually Is there a way to prevent thsi from happing? Mabe this is a Windows setting, so I can controle it? Unfortunaly I can not upload any screenshot which would clearify the situation Cheers: Pum van der Lit

Hey Guys, Trying to figure out how to leave a cell BLANK. I’m tracking soccer games. Here’s my formula: IF({Home Score} > {Away Score}, {Home Team} & " " & “Wins!!”,IF({Away Score}>{Home Score},{Away Team} & " " & “Wins!”,IF({Home Score}={Away Score},“Draw”))) The first part is ok. I get the right values for HOME / AWAY & DRAW. the problem is with future games, where the “score” cells are still empty, I get “Draw”. technically it’s true, but I’d like to leave the cell empty or insert a placeholder text instead. Thanks in advance.

Hey All, I use CSV import to update case management files and import new ones from a separate system operated by a partner of ours. CSV importer is mostly working but is identifying a lot of records as new when they should be updated instead. They are matching on a unique code generated externally from airtable. This is problematic because the cases are associated with different programs and that history is spread out when a duplicate record is being created rather than updating the original. I’ve checked it by comparing October and November reports in excel. Working through excel (comparing unique codes), there are only about 60 new records out of 3500, while CSV importer is saying that there are over 350 new records. Has anyone else run into this issue? I’m encoding UTF-8. Edit: I’ve tried to slim the import down to just the records that have updates or are new, CSV importer is still saying 10 additional records are new that are not.

Quick question, I use an “interactions” table to record every interaction I have with my clients and enter notes into a long text field where it may look something like this: spoke with Mr. Smith, reviewed accounts in full client happy with progress of accounts agreed to meet again in 6 months So the above is stored in the Long Text field. Should for whatever reason I have to leave Airtable or it shuts down and I export this data, will other CRM software import the long text field with the same formatting/text if I export to a CSV? I just want to ensure I future proof this, especially since I’m now going through the painstaking task of having to re-enter all my notes from another program I had been using up until now. Thanks

USING API TO CREATE WP SITE. Hi all. So I have rows of data and a column in the row is Attachments. It is just as it sounds, an uploaded document. My code to generate the URL into content on the page is: f=String(record.get(“Application Name”)); l=record.get(“Attachments”); container+="<a href=’"+l[0][‘url’]+"’ target=’_blank’>"+f+""; The resulting URL is below: Aviation Workers Comp Instructions When this URL appears out on the page and I click on it, I get an error that says “http://dnserrorassist.att.net/search/?q=http%3A//ar.ecologik.netnull/&r=http%3A//ar.ecologik.net/applications/&bc=” NOW, if I right mouse click on any of the links and have it open in a new window the docs load just fine. I notice that there is a null being thrown in the error message. Where is that coming from? I am at a lost on this one!

For the last couple of weeks, I’ve been getting new 404 errors on API calls that used to work perfectly every time. The API calls run every 5 minutes or so, and 90% of the time it works great, but now 10% of the time I’m getting back an error that says the table cannot be found. This is crazy as the table remains and in just a few seconds/minutes when the next webhook runs it will find the table and run correctly. These 404s are causing significant problems, especially when I’m testing for a record and I get back a 404 my script thinks the record does not exist… but that’s not true. In my oponion this should be more of a 500 level server error. Here’s the calls I’m making and the errors I’m receiving: (yes these are from Zapier, and yes I had to spoof the user-agent to make it work) I’m calling https://api.airtable.com/v0/appU29NNGxB8qigRN/Main%20Table I get a 404, “We made a request to api.airtable.com and received (404) Not Found.” Specifically saying: “Could not find table Main Tab

Good morning, my manager would like to a have monitor on his wall displaying information generated by the database such as totals etc and other data created through the use of formula’s. Is there a way I could send this information to a page such as mydomain . com / statistic .html which he can view via his internet browser? Regards Adam

Hello, I’ve read the community forum for a while and wondered if people had any thoughts on triggering a renewal in a structured way. We have a table for DOMAINS and as we handle a renew, we want to add +2 YEARS to the domain’s expiry. I’d want to record the LAST UPDATED (only to be done on renewals, not other fields) and add the 2 years on the EXPIRY. I’m keen to automate, as I might look to raise the invoice automatically in time. Some people seemed to use CHECKBOX to then tripper a Zappier Zap. Has anyone done much with that route? Or any other thoughts or general routes I can research? Thanks in advance.

First of all, I apologize for bad english, that’s not my native language! So, i’ve created a single selection colum named “status”, what i want to know is if there’s a way to send a notification (email ou anything that is not Airtable’s notification - the bell icon) when i change the “status” to a specifc option. I’ve looked on Zapier and i saw that it can integrate with Gmail but the email will be sent when i create a record, i know there’s a way to use Slack but i didn’t dug into it yet. Any thoughs? Thank you for your patience.

Hi guys! I’m very new to Airtable and so far I’m loving it! However, I’m having an issue with formula’s. I have a feeling I’m on the right track, just not quite getting it. I have a table called Schools. This table contains all the data relating to each school such as school name, email, phone, pupil total etc. I have created a field called Beds Total Schools with a formula stating County=“Bedfordshire”. This then populates that field with 1 if the record has Bedfordshire in it’s County field. I can then use this to create a Summary count in my Dashboard called Total Bedfordshire Schools. I can do this for any other county too. The issue I’m having is as follows. I want to create a field that counts the record’s Pupil Total field IF the County field says “Bedfordshire”. I’m sure it’s something like COUNT {Pupil Total} IF {County}=“Bedfordshire”. I can then create a summary from the new field called something like {Total Beds Pupils}. Any help would be greatly appreciated!! Thanks in ad

Good afternoon everyone, all right? I really need your help because I don’t know how to relate the columns … I put a picture of what I need. When someone searches for something, they get information from those who have something just like what they are looking for. |15|Procuro|Casa|Venda|2|230000| 47 > result| |47|Tenho|Casa|Venda|2|230000|15, 50 > result| |50|Procuro|Casa|Venda|2|230000|47 > result|

Hi everyone, Can someone help me make a formula to extract text. How can you isolate the text and make it to its own field in excel from the following : (1.5" X 7" 14PT Matte/Dull Finish Postcards w/ Spot UV on back only, No UV on the front) TO: Field 1: 1.5" x 7" ; Field 2: 14PT; Field 3: Matte/Dull Finish

I have afield with inventory numbers. There numbers start with a bin letter designator and then a number. ex, A2, G22, AA15, AB21 I was using the LEFT function to grab the First character to identify the bin letter, but now that I have grown and now have bins AA, AG, etc. How to I have have Airtable grab just the letters out of the field or grab two letters is the inventory has one? Thanks,

Hi. I’m new to Airtable and trying to find a formula that will count the number of spaces in a string. For example, when this formula is applied to the string “How are you doing?”, I want the formula to return 3. I tried using the FIND function, but all that does is to find the position of the first instance of, say, a space in this example. I’m looking for a formula to count the number of spaces. Thank you.

Hello I am trying to create an interview tracker. I have the following fields: Interview ID - formula Candidate - lookup Client - lookup Interview Date - Date, US format with 12 Hour time, Using GMT for all collaborators. Interview Time Zone - Single Select - Options such as “Pacific”, “Central” Calculated Time Zone - Formula The Calculated Time Zone field takes the inputted time zone and outputs the supported timezone format for Set_TimeZone using the formula: IF({Interview Time Zone} = “Pacific”, “‘America/Los_Angeles’”, IF({Interview Time Zone} = “Mountain”, “'America/Denver’”, IF({Interview Time Zone} = “Central”, “'America/Chicago’”, IF({Interview Time Zone} = “Eastern”, “'America/New_York’”, IF({Interview Time Zone} = “GMT”, “'GMT’”, “Error”))))) Field displays:‘America/Denver’ or ‘America/Los_Angeles’ The Interview ID field takes all the info and creates a unique ID based on the time zone the interview is in. The formula it uses is: CONCATENATE(Candidates, " - ", Client, " -

I’m setting up a base to among other things track articles aligned with specific research topics. The end goal is a record of articles/papers/research already reviewed and deemed relevant. Two tables: Reading log: web-clipped articles with four views; “Articles – Read and relevant” relates to my question. My research topics: If working correctly, only articles that are both read and relevant should appear here. The “Related reading” field is linked to “Reading log” with view limited to “Articles – Read and relevant.” Problems I’m encountering: For Topic A: A linked record appears even though not read and no selection made for relevant yes/no field. For Topic B: An article that was read but marked not relevant (“Research suggests the blue economy could bolster global food security”) is still appearing as a linked record. Have I configured this incorrectly? Thanks for any tips! Airtable Test Base - Airtable Explore the "Test Base" base on Airtable.

Hello everyone! Trying to figure out the best way to do perform this formula. Column Name: Invoice Status Formula rules within column: If “payments” column is filled, and “balance” column = zero show “Paid” If “payments” column is empty, show “Unpaid” If “payments” column is filled, but “balance” column is greater than zero, show “Partially Paid” All help is much appreciated!!

I need to find the number of days an agent is active. Currently, I have 3 columns “Start Date”, “End Date”, and “Days Active” and my formula in my Days Active column is: DATETIME_DIFF({End Date},{Start Date},‘days’) Some agents are still active and do not have an “end date” and I get an error message in the Days Active Column. How do I enhance my formula to replace null values in the End Date column with today’s date?

I have a Base with the following tables: People, Contact History. In Contact History I am logging all conversations with the people from the first table and many times there are multiple records in Contact History for every person in the People table. I am trying to show in the People table just the notes from the most recent contact with that person. As I understand it, I can’t use a rollup field to do this because it’s a string. Any advice pointing me in the right direction would be greatly appreciated!

I have three tables: one table that lists All Contacts which contains over 100 records, the second table called “Leadership Board” has 15 records, and the third table “Conference Speakers” has 35 records. I want to link the contacts in such a way that if a record in All Contacts is updated, the corresponding record will be updated in the other table. Obviously, the other two tables don’t contain all the records that All Contacts contains, and I want to keep it that way. When I attempt to link the tables, all the records from All Contacts are added to “Leadership Board” and “Conference Speakers”. If someone could please help me with this dilemma, I’d be very grateful.

Hey there, I’ve already converted my array into a string, and each value is separated by a comma. It looks like this: 2019-12-23T00:00:00.000Z, 2019-11-23T00:00:00.000Z, 2019-12-27T00:00:00.000Z, 2019-11- 23T00:00:00.000Z, 2019-11-24T00:00:00.000Z I understand that Airtable doesn’t have index functionality, so how would I achieve this individually for each value? I’ll be splitting these up into 5 individual fields within my table. I know there are other topics on this, I couldn’t find the solution I was looking for on those. Thank you so much for your responses.

Hi, I’m a bit confused and was wondering whether someone can help me. Essentially I want to be able to link to files stored on Google Doc in the Attachments field on Airtable, rather than upload them. Now, when I add a file to the Attachment field, go and change the file in Google docs, it’s not ‘updated’ in Airtable. So, I assume this is because it’s uploading a copy of the file to Airtable, not linking to the Google Docs file. Is there any way to link to the actual file on Google Drive? I saw there is a Zapier that claims to do this…but it doesn’t seem to actually do that…instead it monitors the Google Drive and creates field entries when new files are created. I just want a simple link to a file hosted on Google Drive. Is there a simple way to do this that I’m missing? Thanks for your help.

A kind of Word-Blacklist : test1,test 2, test3, test4 and if question if its true then markt the formfield with the word Error how can i do that?

max 7 words seperated with , - is functionable count the words- functionable now how can i combine both into a formular? IF(LEN({Tags}) - LEN(SUBSTITUTE({Tags}, ‘,’, ‘’))>7, “ :x: ”, “ :white_check_mark: ” - LEN(SUBSTITUTE({Tags}, ‘,’, ‘’)) LEN({Tags}) - LEN(SUBSTITUTE({Tags}, ‘,’, ‘’))) Attachment fields: you say in the formular: attachment field then cames the full name and the link but i want ONLY THE link how can i do that?

by a normal multiple selector ist the normal seperator a , how can i seperate with ; instead , ?