Ask the Community

I have built an Airtable structure that utilizes the Created date/time field type to track when a record is added. This Airtable solution will replace an Excel version of the same data. The Excel version contains 2 years worth of data with it’s own creation date column. When I come to import this data into Airtable, the Created date/time field is going to return a value of the import date/time and rightfully, not the real creation date from Excel, This means when I develop charts such as Records added by month, the imported data will always be linked to the import month. I will not be able to use the Created date/time field to analyse the historical data. What is the best way to only have to use one creation field date (without the user manually choosing the creation date on a form) to track the actual creation date of both historical and current/future data?

Please helpppI have multiple linked records inside a single record that I would like spread out into seperate rows with all the other information copied over. Something in my automations or my linking isn't right, but after two days of arguing with it, I need some help. Thanks!

Hello,We are currently at 38,500 records. I'm curious how others are handling their data once they hit 50,000.Do you duplicate the base, delete all records and continue on (thus leaving all your fields, automations intact)?Looking for suggestions.Thanks!

I want to know if Airtable can give the option to people filling out a form to choose whether to share the information for each individual question.

Hello,My former "Pro" plan has been automatically downgraded to Free plan today.I believe it is a side-effect of the recent Airtable plan changes.Any similar experience? I just reported itThanks,Juan Gonzalez

Hello i accidentally deleted a base in my pro workspace. Is it possible to restore it? It was very important. With about 7000 Records of manual data in there. I am waiting for you answer. Best Regards Max

Ok so here's the main formula I'm trying to use for my "Monday Pay Hours" fieldIF({Monday Start} = BLANK(), 0,DATETIME_DIFF({Monday End}, {Monday Start}, 'minutes'))/60-0.5This gives me the exact hours worked, minus a half hour lunch break It's almost perfect, but what I need is to tell it that - IF the formula all the way up to here: IF({Monday Start} = BLANK(), 0,DATETIME_DIFF({Monday End}, {Monday Start}, 'minutes'))/60equals less than 5, then don't add the last step of subtracting the 0.5. 

Hi Community!I'm setting up an automation to remind users to update their records. So the idea is to send email reminders in 3, 6, 9 and 12 months since the last update.I'm using an automation triggering by a formula field that simply calculates the number of months since the last update was made.All good there!However, some emails are invalid (user likely entered wrongly), so I'd like to avoid trigerring the 6-, 9- and 12-months reminders if the email is invalid.My logic right now works like this:Triggers if months passed = 3 AND email is not checked as invalidChecks email as invalidSends emailUncheck email as invalidThe idea is that if the email fails to send (step 3) then the process stops, step 4 never occurs, and the email invalid is left checked. This works nicely.What doesn't work is if the email is sent! Because step 4 updates the "Invalid email" field, which is also in the trigger,

Hello,Given that airtable cannot filter linked records, is there any way to access the limit record selection to a view from an interface such that the user can switch between views as needed? I have also put in a feature request to filter linked records but in the mean time maybe someone knows how to switch views from an interface? Thanks in advance! 

Hi there - We are setting up automation to find records that meet certain criteria -- either via a view or several 'Find Record' set-ups but the 'Find Records' is stopping at 100 records.  What is the best work around for this?  Thanks! 

Not sure if any of you have received the notification that if you're on the pro plan - your automations will be halved from the aldy restrictive 50,000 per month to 25,000 per month (also No more multisource syncs, API limits of 100,000, halving of attachment storage space to 10gb)? Also the support team seems to be not active since the pricing plan was announced - all my emails get diverted to a cliched auto reply when in the past a warm body will be manning the email and helping to resolve the issue. Isn't it industry practice to pmaintain current users on their own legacy plan? The new pricing and lack of support is making us consider other platforms instead 

Hello everyone, I am looking for a script to find values of over 100 and sum the total. I have looked on other posts but can't seem to find one to support this. Thanks all,

Hello,We are a marketing & design team. We have a status field on each job that indicates if the job is currently sitting "with marketing", "with design", "complete", etc. Each time we hand the job back and forth between departments, we change that status field accordingly.  The change of status is subsequently tracked in the Activity/Comments panel of the job.  Is there a formula that can be written to look back through the last year's worth of job tickets, in each Activity panel, and count the number of times the STATUS field changed?(side note: 2 months ago I created an automation to begin tracking & counting that status change, so we have the data moving forward. However, I'm seeking to gather that data from months prior)Fingers crossed.....Thanks!

Has anyone found a way to display dashboard data on a mobile device or send charts and graphs in an email?

For charts in Interfaces, I don’t see the right formatting of Currency as I see in the data section. Is there a way to configure the currency format? It should be $50,000.00 but it is $50000.00. No Comma.

Hi all,I would like to share interfaces with my clients without having them to register and most importantly answer the initial onboarding questionnaires from Airtable.It discourages them from accessing the platform and viewing my interfaces.Is there a way to view and potentially edit without having to set up an account and answer the onboarding questionnaire?Any advice would be welcome 🙂Thank you! 

I have an automation that triggers when a form is filled out. The form collects email addresses and locations from people, putting that info in the signups table, and matches them with captains based on their location; the captains are listed in the captains table and linked to the signups table, with lookup fields in signups for their email address and other key info.The automation sends an email to the new signup connecting them with their captain. Some captains have email addresses, some don't. So the automation looks to see first of all if there is an email address for the captain in the signups table's lookup field. The logic in the automation is: signups: email (from captains) is NOT empty.However, the step is triggered even if the email (from captains) lookup field IS empty. When testing the step, it returns a success and shows the field

Hi, I am trying to design two bases on Airtable for my team:Base 1: Instruction ManualInformation: This base should consists of all tasks our team need to do throughout the year, which instruction and attachment.Base 2: To-do tasksInformation: The tasks of this base should be synced from Base 1. In this base, each task will be assigned a collaborator, start and end date, task status, and team's comment. My current questions/roadblocks:1. In my Base 1, ideally, there should be two tables of tasks - "standard" and "intensive". But I still want both tables to be synced directly into one table in my Base 2. 2. In my Base 2, ideally, when I run a script of auto-updating the start and end date of each task, it can create dates of the following year, i.e., my team is currently monitoring the "to-do" and "in-progress" tasks (synced from Base 1) of 2023, but since all our tasks (both standard and intensive) are repetitive

how to conjugate two fields into a new field.I want to conjugate "first name field" and "last name field" into one field labelled first_last name

I've had so many frustrations with the automation feature that I literally haven't updated my Airtable in MONTHS because of this.... I migrated from GSheets and manually updating GCal to Airtable for it to automate for me and yet I keep getting this error message despite the test running perfectly fine.... If anyone has some insight on how this can be fixed, it would be greatly appreciated... Screenshots attached.. If there is also any way to contact customer support away from a public community forum and beyond the help articles, that would also be super helpful... 

How can I populate a field based on a view. When I create a new view I want to put the same info into a field.

Hello I'm new to airtable, and I recently had a website built using Airtable as a database for a car listing widget. We have a column in our airtable where we input a short and long description for each vehicle we list. Below is a screen shot of what the data looks like once we past it into the cell of the airtable. It looks like one big run-on sentence. Is there any way to format this data to display nicer? Or at least have a line break so that each sentence can be displayed on its own line so its broken up some and easier to read? Thanks!I would prefer it read like the following if possible.... SOLD!USED HEAVY RESCUE PUMPER FOR SALE!8 Man Cab (7 SCBA Seats)Air Conditioned CabDiesel EngineAutomatic TransmissionMileage: 19,074750 GPM Side Mount Pump500 Gallon Poly Water TankFoam TankFoam Pro Foam Sys

I'm trying to use a script in an automation to filter specific records from a view and then include those records in the next step of the automation (which would be inserting them into an email to send).I can get the script to successfully find and filter the records needed, and it looks like I need to use output.set to export the info back to the automation, but I'm having issues figuring out how to do so.When I run the script below, I'm getting the following error: TypeError: Invalid arguments passed to output.set(key, value): • value[0] should be a JSON-serializable type, not an object Anyone know how to fix what I have for the output.set part or any guidance at all? Thanks!const table = base.getTable("Sessions");let view = table

I am trying to create in make(integromat) a scenario where I can fetch data from a specific date to feed it to a google docs file. (Its my firts time with make)How did I generate the formula in make to accomplish this? I can't figure out how to match the date field of my table to any of the variables that make gives me.Thanks for your support

I have a form that users submit each week to log hours. I have a table that captures each submission in a new row along with how many hours they have left in total (not per week). I have fields that capture the hours logged that was submitted, the total available hours, and how many hours are left, but I am unable to get it to add up all of the hours for a single user and then provide me with the remaining hours. As an example, Jane K. (1st week)Hours logged this week = 4. Total available hours = 20. Remaining hours = 16.Jane K. (2nd week)Hours logged this week = 10. Total available hours = 20. Remaining hours = 10. How do I get the 'Remaining hours' total to be 6 (4 + 10 = 14 minus 20)? I would like to base it off of the first field in my table which is a concatenation of two values.  Thanks!