Ask the Community

We have a single Airtable group calendar for 15 staff members.  When a staff member receives a calendar invite from a third party, when they accept, it adds it to a Googe Calendar. I know I could do a full integration but for several reasons, we do not want ALL entries to go to our Airtable calendar.We are looking for the easiest way to go to that Google calendar entry and "do something" to get it to populate into our Airtable Calendar.  Thoughts?

I am simply trying to connect to the information from one table to another table automatically using automation. Every time I try it it comes up with errors. I have tried using the record id formula to connect them (they dont match between tables). I have used the primary id (email) and it wont work. I have tried the Link to Another Record field. Even in the error I am seeing both emails, so it seems like it should work. What am I doing wrong? 

I am trying to take the word count of a book (ex: 100,000 words)divide that by 9,300 (which is how many words an average narrator can read per hour)to come out with the actual time in HH:MM format. This is the formula I have currently and how it turns out. .   What formula would I use to divide the word count by 9300 to come out with a HH:MM?

I am trying to integrate Airtable with Jira, pulling data from Jira to Airtable. My issue is that I only see a few Jiar fields (Issue Key, Status, Assignee, Summary, Created Date, Due Date, Description, URL, Priority and Labels) when adding an Jiar cloud app in Airtable. But there are about 15 fields of Jiar task, I am wondering how can I pull all the fields from Jiar to Airtable?

Hello! I am creating a field for event attendees. I have each attendee's name, the events they attended, and the dates of the events they attended separated into 3 columns. I would like to make a fourth column that retrieves the most recent date each attendee came to an event. In this scenario, I want to make a fourth column that will automatically register that 1/8/24 is the most recent date and it will return that. Please let me know if you can help. 

i am attempting to use the attached code within an airtable automations run script tied to a "When Record Enters View" trigger. I have almost zero background in JS, and I just can't get this thing to work. Do any of you have any suggestions as to how I can fix these issues?

Hi,Looking at creating a dashboard for an CRM/ERP application. One key metric to show would be conversion, i.e. percentage of leads that became customers. Since the dashboard "Number" element can only summarise a given column, not perform calculations between columns, I created a new table "BI" to hold various metrics that I will need.In that table it is easy to link e.g. all contacts and perform rollups and formula calculations to get the needed metric. But then I realised I seemingly cannot place an individual record, say "Overall conversion" (formula: customers / all leads) in the dashboard.I found that number or graph elements could be used to summarise e.g. yes/no columns which in a way would show the same information, but I'd prefer a simple "Conversion: 42%" instead of a whole graph with all the other, unnecessary information.How would you go about this?Rgds,Björn

Hi! Currently I have a field which is returning a "Modified At" date. This field is a standard field (no formula) and it is returning the modified date of another field (our "Feedback" field).This is what it is returning in a problematic record:However, when I look at the revision history of the record, it says that the most recent update to this field was one month ago.Can someone help me understand why there is a lack of parity between this modified at date and the revision history?

Hello, We use Airtable at our company for our Purchase Order store and use formulas for expected payment date to calculate when we expect to get paid. We are now looking at advancing certain aspects of our database, such as, we want an automated email sent the same time each month, so the trigger we have chose is 'At scheduled time'Now i would like it then to find the records in one of my views, it does this but only lists 10 records, when we are looking at much more than this. We would then like the the records found be attached to an email that is sent to a memeber of our team. I hope this make senses, any tips would be of great help. 

I’d like to configure the fields shown on the record when I open that record from the Search extension. For example, I want to make sure a button and a few key fields appears at the top of the record and everything else is hidden. The goal is to speed up the process of searching, finding, and acting on information I haven’t found a way to explicitly say “open the record as if it were in this view” from Search, but the extension does seem to refer to one view in particular. Has anyone figured this out?

I've found a formula which is partly working for us, originally it was showing the years and months as negative numbers but I've managed to sort out the years aspect but I can't figure out what needs to change to make the months show correctly.currently shows the response like this 0 Years, -7 MonthsFormula being used is DATETIME_DIFF(NOW(),{D of B},'Years') & " Years, " &DATETIME_DIFF(DATEADD({D of B}, DATETIME_DIFF(NOW(), {D of B}, 'Years'), 'Years'),NOW(),'Months') & " Months" can anyone read this formula or add to it to make it respond with years, & months 

I am looking for a way to automatically backup key tables in our Airtable base to sheets or CSV files in Google Drive. I had a play with Zapier and with Airtable automations, but couldn't find a way to do it.I tried ProBackup, but it didn't successfully backup any of the tables.On2Air might be possible. But you need to pay $29.99 per month to get a weekly backup. Which is pricey for a charity.Has anyone else had success with this? 

Whilst a fan of online apps and data, the paranoid in me wonders what I would do if your website goes down or gets compromised. Is there an easy way to backup my bases for local storage?

I know we can export data in .csv format but is there really no option in Airtable to basically download/export the whole DB?

I have a problem with a script that worked and all of a sudden, stopped to work:"App Name" is a linked record field. "Add App On Sign Up" is another linked record field. When a value is inserted in "Add App On Sign Up", I need this value to be inserted in "App Name" (inserted, meaning adding a value, not replacing a value to "App Name".Anyone has a better script to propose?The error message is:Error: Field "fldGBiazYCpFzbsOv" cannot accept the provided value. at main on line 12Field "fldGBiazYCpFzbsOv" is the field id of App Name   const table = base.getTable("Members"); const query = await table.selectRecordsAsync(); for (const record of query.records) { const appNames = record.getCellValue("App Name"); const addAppOnSignUp = record.getCellValue("Add App On Sign Up"); if (appNames && addAppOnSignUp) { const updatedAppNames = appNames.map(appName => appName).concat(addAppOnSignUp); await table.updateRecordAsync(record, { "App Na

Hi!I have a system to record the working hours of employees. Through the form in table "timestamp", each employee reports the time of arrival and departure (and lunch break). Each entry is in a new line. Then, in table "Presence at work", I combined these rows for each employee to have all check-ins/check-outs for one day in one row. In this way, I then calculate lunch break and work time. If I group the rows by name and date, I can get a monthly attendance statement.In a completely different table ("holidays leave"), vacation requests are submitted via a form, where vacation days are added up.Now, in the table "Presence at work" (or in some extra table), I would like to have a monthly display for each employee of how many hours he worked, how many hours he used vacation and sick leave, and how many hours of holiday there were.Any ideas on how to make it as easy and automated as possible? So that I don't have to connect the tables manually. So how to add those missing information

If I have a custom script as an action in an automation, is there anyway to have a catch or else statement that would create a failed automation notification like there is for the built in actions?Meaning, how can I set up a notification system if a custom script fails?

Hello, I am a user who studies airtable. I would like to inquire about the function of using airtable.In Excel, a fomula can be calculated by referring to previous row (previous record) values.So it's easy to implement how to get the following balance, but I haven' t found a way yet in airtable.Nocontentincomespendbalance1apple10 10 2banana20 30 (=10+20-0)3cherry 1515  (=30+0-15)4hotel 510  (=15+0-5)5fox 100  (=10+0-10)I would like to add or subtract this record value to the previous record value so that the cumulative balance comes out.I asked the same question a few days ago, but I didn't receive the answer I wanted, so I'm requesting it again.Thanks. Have a nice day.

I have table A and table B.When a record in table A is created, I have an automation that creates the same record in table B. However, the primary column in table B stays blank. How can I fill the primary column in table B with the primary column value of table A? 

Good morning,I have the Team version of Airtable and I would like to know how can I save my databases and interfaces?is there an automatic backup?For greater security should I do an export?I would like all the advice you can give me because my bases and interfaces are extremely valuable.Mary

The past week or so, we have experienced intermittent issues with the Jotform + Airtable integration.1. Some Jotform submissions indicate they were successfully sent to Airtable, and never showed up in Airtable.2. Fields that contain more than one attached file (like multiple photos) are only sending over the first file.In both cases, the integration log shows success. It is not every submission, just some of them, making it hard for me to troubleshoot the problem.

Hey Everyone,  I'm a bit frustrated because of the following: Is it just me, or is tooooo hard to get a hold of someone on the email?? I've been trying to get an answer on the support email for almost 2 weeks now, all I get is an automated response, and that's about it. If anyone can suggest a way to get help faster, would be much appreciated!

Hello! I am trying to format my data in a very specific way and require underscores between the text. I know when using a Lookup and formula there are challenges because the Lookup format is not a string and the commas within the field do not actually exist. I tried converting the field to a string and using a substitute formula but that just removed the commas and spaces from the field. Current Lookup Format: pa, nv, flSubstitute Format: panvflDesired Format: pa_nv_flDoes anyone know if there is a formula to add underscores to a lookup field that contains multiple options?Thank you in advance and I appreciate any support in solving this!

Hi there Airtable Gurus,We have four bases in our Airtable workspace:Base A: This is a new base connected to our legacy software, which automatically adds order numbers into Base A. We want to link this base to our existing Bases B, C, and D using the primary field (order number) from Base A.We would like the primary field (order number) from Base A to be selectable + within Bases B, C, and D within Airtable and via forms to ensure clear linkage and consistency to orders. These separate bases (B, C, and D) need to connect and relate back to Base A.Currently, I have tried having Base A synced with tabs in Bases B, C, and D. We want the connected information from Bases B, C, and D to be integrated into Base A through linked fields. While I have this information working through my synced table tabs within Base A, these extra linked fields are not appearing in the original Bases B, C, and D.Having this integration will allow our legacy system to update accordingly.Alternatively, my other s

Hi,1. How can I create default value to an attachment field?2. I'm trying to create automation that every scheduled time 2 fields in the table will be updated to certain status.The trigger is working but i get an error of "Received invalid inputs."Can anyone help me with this?Attached image that show the automation: