Ask the Community

Hello.I need to calculate the average of the entire column (called total score) but using the average formula I am getting the average of each cell. Is there any solution please?Thanks

I have several helper tables for linking and allowing users to choose from sets of pre-defined values. They do not need to be directly accessed and can confuse end users. I would like to find a way for them to be hidden. I found an old thread about this that is marked as solved, but as far as I can tell, it hasn’t been solved. Some options that could work: Allow these tables to move to a separate Base that can be accessed from the Base the consultants interact with, meaning allow Bases to access data across other Bases in the workspace. This way I could group the tables into functional and boilerplate Bases. Access to a show/hide UX in the Base with the tables listed and a toggle switch for visibility. Off state would hide the tab. System or even a hack that allows for custom CSS. Unfortunately the tabs do not have ids, but I may still be able to hack something with nth child. Are any of these available? Is there another solution? If not, can one be rolled out? Thank you,

Hi! I’m trying to create a kanban view and it won’t let me choose any of the fields from the table i’m creating a view from - it only allows for me to add in a new field which i don’t want to do. Kind of defeats the point of this view. what button have i not pressed? any help would be appreciated!

Hi everyone! I followed this support article almost exactly in an attempt to repeat yearly deadlines (grant applications), but for some reason, everything automatically copies over except for the new date. I used the formula DATEADD(Date, 365, ‘day’) to create a column that adds a year to each date (which does work), then tried to input that as the date when my automation creates a new record (triggered by it entering a “past events” view, containing any event with a date before today, so that when a day passes it gets added to next year’s calendar). But alas, the date just won’t copy over. Does anyone have any suggestions? Thank you! <3 The support article I followed: Airtable Support Creating recurring records using automations Join a live training! Power up your workflow   The value of using automations in your workflow becomes immediately obvious when reducing manual errors by automating repetitive tasks.  One commo...

Hi, I'm unable to upload multiple images to record templates - keeps giving me an error. Is anyone else experiencing this? 

Hello,I have been googling this for a few days now and really need some help!I am trying to set up an existing customer email reminder automation that uses date the next time we are going to visit a venue. The trigger will start a month or so before the visit date. A new customer fills out a form and a record is created. This gets linked to our Class bookings table with the venue that they have visited. The bookings table is linked to a classes table which shows each venue and the 4 dates we visit that venue. So far i have managed toLookup the dates from Classes in the class bookings table - this gives me an entry with all 4 dates in the same cell. The format of this row is a date. (perfect)In the customers table i am able to use a rollup to get this date across and then use an ARRAYSLICE to get the individual dates i need. They come in a really long format with the time 2024-02-01T00:00:00.000Z. I can clean this up using some variation of DATETI

I am in the middle of creating a form and have had no issues, but all of a sudden the fields I am creating are displaying in grid view but not in the form. 

Good morning all! First of all, I’m just getting into Airtable and it’s brilliant. I love it! Goodbye spreadsheets! I did some research on the accessibility (as in, WCAG web standards that allow the disability community to participate) and I haven’t found much. So I’m turning to y’all! My question is: does Airtable have any level of accessibility compliance for those who are blind/have low vision? For example, the option to have appropriate color contrast or adjust text size is pretty basic compliance. (If so, how do I enable this?) The ability to navigate entirely with the shift key and a screen reader (what blind people use to hear text read out loud) is on the “A+ you get a gold star!” level of compliance. Anything I can brag to my team about when I introduce them to Airtable? If not, is this something the lovely Airtable team is thinking about or working on? (Either/both on the Airtable end and the form end.) Thank you so much for any input!

Hi. My nonprofit is using an Airtable base to support and manage data from youth teams that are conducting service-learning projects. I have a table called "Teams" that holds all the data about each team. Then I created a form through Fillout.com where they can create new records in a table called "Project Plans." The first thing they do when filling out the form is to select their Team name, i.e. a field in the Project Plan table that links back to the Teams table.The problem is that before I understood how linked records work (creates a field in the table where it's created, but also a corresponding one back on the table that it links to),  I would notice the new field in table it was linking to and thought- what the heck is this extra field here? And then deleted it.I now need to create lookup and rollup fields in the Teams table, but have broken the link by deleting the corresponding field there. The "Teams" field in the "Project Plan" table still shows the team name.Is t

I have a grid with many single select fields (over 200).  I am creating a form with the same fields, but two of my single select fields from the Grid View are not available in the Form View.  Does anyone have any solutions?

Hi All,In terms of security and protection of clients data, which is better Airtable or Jira? how they are different from each other when it comes to security ? Many thanks 

What can I use in a formula field to copy the date from one field to another without changing it into a text string?For context, I have install dates and site visit dates in the same table, and the dates are in the same column for 'start' and 'end'. I am setting up 4 more fields (Site visit start, site visit end, install start, install end) that will remain blank if the date type does not match. However, I can't find any way to keep the date as a number/ date format and not a text string? I basically just want to copy a date (unchanged, not adding or subtracting days or I could use DATEADD), but the only one I can find is DATETIME_FORMAT but this changes it into a string. Can anyone help? I understand I could use automations to copy the date, but I'm trying to limit my use of those because I am nearing the limit of automations per base! So a formula would be much better if possible. Code I'm currently using is below:IF( {Date Type} = "Install", IF( {End} != 0

I have a table where static information about my volunteers lives.In it, I have a field (Static Notes) with an IF statement that looks to see if they have a check mark in "Qualified" (to walk dogs) and if they do, it returns "DDW" (designated dog walker), which then shows up on the schedule.Can I write a nested IF statement that looks at a different field altogether (Training Status) and if they "Need More Training" returns "Trainee" in the Static Notes field (the same field where DDW would appear)?Or do IF statements only distinguish between options in one field? And if that's true, how would I get various information (other qualifications, for example) to show up in my Static Notes field?Thank you! (I'm learning all of this by feeling my way in the dark - appreciate everyone who is willing to take my elbow and keep me from crashing into furniture along the way!)

I'm trying to get program participants' records to update automatically when they're listed in another table as having attended a workshop, but AirTable is requiring a Record ID and I don't know how to configure this such that it applies to all records in the table.

Here's the system:Base A: Used for Project Management for an event in January.Interface A: Created on top of Base A for use by other members on the team where data access needs to be considered.Base B: Use for Project Management for an event in February. It is created by Duplicating Base A after the completion of January's event, so that the base undergoes an iterative design process, benefiting from the additions/improvements made to the base during the last event.❌  What I'd Like to Do: Upon creation of Base B by duplicating Base A, create Interface B that is a duplicate of Interface A.I am aware that Airtable does not support duplicating Interfaces to other bases for fear that the underlying data structure will be different (on Airtable's end, I imagine that at the least they should be able to offer the option to duplicate the interface associated with the base at the time that the base is duplicated).Has anyone else found a way to work around this? Re-creating the inter

Hi Folks,I was wondering if you know if we can use Airtable to create groups and allow collaborations between participants and allowing chats (something similar to idea of Facebook).  Thank you 

Hi all, Has anyone attempted to sync data from PowerBI to Airtable?I find it easier to transform data in PowerBI but my end report result needs to be displayed in Airtable. 

Getting and #ERROR! when using ENCODE_URL_COMPONENT() on a lookup field of a text field. Can the formula be used on lookups?

https://github.com/sleiman/airtable-phpI have been using this tool flawlessly and working my new Personal Token where my API key existed.use \TANIOS\Airtable\Airtable; $airtable = new Airtable(array( 'api_key' => 'API_KEY', 'base' => 'BASE_ID' ));When I swap out the API_KEY with my new Personal Token it doesn't work, which I suspected. What do I need to change api_key to? Is it that simple I hope! Thanks in advance!- Jon

I have an embedded an Airtable in a website with URLs that point to https locations that have pdf downloads. When the link is clicked the “https” is stripped off the url (although it is still in the Favicon on the browser tab) and the pdf will not open due to a security issue. Even dropping all security blocks will not allow the page to open. Not a problem with Edge or with Chrome or safari on iPhone. Only with Chrome on PC and Safari on Mac. The link will open if it is in the website outside of the airtable. Update: Incognito doesn’t work; holding Ctrl (PC) or Cmd (Mac) will open the link in a new tab but stay on the main website. But it works!. For developers: “target _top” works but “target _blank” or “target _parent” are loading but not displaying. From the identically described issue stackoverflow.com this was suggested but didn’t work. It killed the table completely when we pasted in the iframe code: I found something! I know your question was 2 years ago, but if you use th

Hello, I'm brand new here. Air Table was suggested as a good option for what I need to do, but I need some guidance. (I can do basic things on google sheets or excel.)We're creating a church directory. We've gathered info from families, and someone typed them up in a doc... (Kicking myself for not having made a digital form to begin with!)What I will need to end up with is a database of families with adults and children, mailing address, phone and email (sometimes both for 2 adults), and birthdays and anniversaries. Also, a place to check if they will have a photo in the book, and a place to check that we've verified their info to be correct before including it in the directory. I will need to output 3 different things:The names of the family members to go under their photo. (Family name and individuals with adults named first)The directory contact info listing (Family Name, individuals, contact info)A calendar list of birthdays and anniversaries by monthSide note: We do have some

Hi. Sorry if this is a silly question. I need to rename a table that has some airtable automations linked to it. Can anyone tell me whether the automations will dynamically change their settings to use the renamed table as before - or do I have to manually re-configure them to use the new table name?Many thanks.

Hi all, today we’re beginning to roll out some redesigns to the linked record picker in Interfaces. These redesigns should make it easier to identify the data you need to make a selection, reduce some unnecessary clutter, and bring a more flexible experience as you can now easily resize it to fit your screen real estate needs. This redesign unlocks some future features for linked records, so stay tuned for more soon!  

Hello everyone, I have encountered some problems in recent days with basic copies between accounts. I work on a basis for clients from my Airtable account. They copy it to their account and there, yay: automations are not copied, only interfaces and tables and new: all my buttons with links to database forms with prefill are not dynamic. So when they enter a form, it puts the information... on the basis of my account I don't know if you've ever had this problem, or if it's normal? I used the prefill forms extension. I saw that the creator published last year about update issues but she wrote that Airtable had updated. I reloaded the extension, deleted and reinstalled and it still doesn't work. In my interfaces, I put buttons that send to base form URLS. And in the copy, it keeps my URLs to me. Is there no way for these urls to be dynamic between database copies on different accounts?

I need to track what resources are needed for each area of a project. They are similar - ex. XXX at Y quantity or ZZZ cut to A' by B". I need to link the resources needed with each project area.  Any ideas on how best to set this up? THANK YOU!