Ask the Community

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:  

Hello,We're an edtech startup for high school students.In addition to the in-app exams and quizzes, we also run offline exams in Telegram groups to mimic school exams (around 3 times a week).We send out a pdf to a group chat, and then each student solves the exam by hand, and then takes a picture and sends it back to us. Our teachers then give each student a grade and reply to that student. This is important because we want to see the steps in their solutions.These offline test scores need to saved so we can achieve the following:- Keep track of each student's scores over the school year- We send out report cards based on these scores- Check if a student doesn't have a score recorded, so we can check if they didn't do the assignment (assuming it wasn't an error on our side)- Keep track of when our teachers submit a score (to ensure timely responses)Right now this is all done on sheets.We were thinking of using Airtable.Do you think this is something that can be achieved? I didn't find

I'm trying to filter my extract by the bank that the user select, but i'm always getting null.What am i doing wrong?const extract = await Extract.selectRecordsAsync({    fields: ["Name", "Data", "Valor", "Bank"]}).then(query => query.records)let bank = await input.recordAsync("Escolha um banco: ", Banks)const extractByBank = extract.filter(ext => ext.getCellValue("Bank") == [bank])

Hi there,I dont understand the difference between 2 formulas : IF( AND( {Startdatum Leverancier (rol repowered)} != BLANK(), {Einddatum leverancier (rol repowered)} = BLANK() ), "OT", IF( AND( {Startdatum Leverancier (rol repowered)} = BLANK(), {Einddatum leverancier (rol repowered)} = BLANK() ), "", "BT" ) ) This formula does  NOT work as intended and ALWAYS shows OT regardless of the 2 fields content (empty or filled). I need to add that these fields are date fields.  IF( {Startdatum Leverancier (rol repowered)} = BLANK(), "", IF( {Einddatum leverancier (rol repowered)} = BLANK(), "OT", "BT" ) ) This one DOES work as intended. Although I fixed the issue my curiousity is getting the better of me what I did wrong in the first bit of code. Anybody ideas? 

Hi!I have formula field for duration of a lunch break (datetime difference between lunch strat and lunch end). It gives me duration in minutes. Now I'm wondering if there is a way to sum this time?Thanks