Ask the Community
Recently active
Airtable have recently released a new popout feature for the calendars in interface designer.When clicking on a record in the calendar element, a new popout appears before you can get to the record detail view. To get to the record detail you have to click the expansion arrows in the top right of the popout:How can this popout be disabled and go back to how Airtable used to work where you clicked on a record in the calendar and it would take you straight to the record detail?
Let's say we have a row with a product & prices for that product at four regional stores:Chocolate BarStore A: $1Store B: $3Store C: $2Store 😧 $5I'd like a formula that would look across the store prices, determine the highest price, and then return the name of that field. I want a function that would return "Store D" in the example above.MAX(Store A, Store B, Store C, Store D) will help me identify the highest price, but it returns the $5 value, not the field name Store D. How do I get something like MAX returning the winning field name?Thanks!
I'm building an issue tracker leading up to a one-day event. Issues are reported, and then I need to track how long the issue has been open. Most issues are closed in a few minutes, but others may linger for hours, or even days.I can calculate the number of minutes since the issue was opened, but how do I convert that to a duration-like result that includes days? Sort of like a DD:HH:mm format.This is how I calculate the elapsed minutes: DATETIME_DIFF({Resolution Time}, {Call Time}, 'minutes') * 60
Currently it seems as if though there’s no way to tag and notify a user who does not have access to your interface; additionally, when a notification is sent, that notification links back to the interface it was sent from. Can it please be adjusted that a notification gets sent regardless of the interface they have access to, and the link that’s sent to them finds the relevant record on whatever interface is currently available to them?
I've got an issue with my account, as Airtable is displaying that I reached my automation limit (50.000 / 50.000)Actually, I only have one active automation in my whole workspace, triggered by the creation of a record, and I only create approximatively a dozen record a day.I dont understand how my limit can be reached that quickly, and apparently this is the case every month, my automation limit is reached after 2 or 3 days.Have you already faced something like that ? I currently have the Pro Plan, and I don't know if this is the good place to reach someone that can fix my problem and more importantly explain to me why this is happening. Thanks you very much !
This might be a super simple one, but I wasn't able to find it in the Keyboard shortcuts and it's been driving me crazy.In excel, when you are entering a sequence of cells in horizontal order (tabbing after each one), if you hit Enter/Return, you return to the place where you clicked, so you can continue entering the same sequence of cells. In Airtable, you hit enter and it puts your cursor in the cell directly below. So you have to hit enter again, and shift-tab back, or ctrl-left back to the very start of the row. Oh how I long for fewer strokes to get back to where I started entering! Anyone know the trick? Thanks! Craig
Hi, I have 20 records in my Base that were accidentally overridden by an Integromat automation. I need to restore the records to a previous version, but “Undo” will work, and there is no Snapshot for that time period. I can see the previous edits in the Activity Log for each record, but it looks as if I can’t access this data through the API. Is there any way to restore records to a previous version based on edits in the Activity Log of a record, rather than a Snapshot? If there’s not a way to do this within Airtable itself, is there any third party software that you can recommend to extract this data? Thanks for the help!
I know it is possible to create custom Extensions and publish them to the marketplace. I was not able to find any information on developing third-party actions for Automations.For example, there is a list of integrations:Can I develop a new one for a third-party system? I'm looking for a way to develop and publish it globally for other users to consume. I'm a part of a product company and we want to give Airtable users option to integrate through Automations.
Hello, I am using Automations to keep my Base in sync with a Google Calendar. Specifically, I am importing Google Calendar events into AirTable. For one-off events, it works great! Creations, updates, and deletions get mirrored pretty well. However, when I create a recurring event in Google Calendar, only one row gets created in my base. My automation trigger is set for “when an event is created in Google Calendar” and the action is “create a new row”. If I create an event in Google Calendar that repeats every Monday for one month, I would like 4 rows to be created in AirTable Does anyone know if this is this possible with Automations? Thanks so much!
Hi everybody,I have a question regarding syncing multiple workspaces into one workspace. I then want to merge the data that is synced so that I get one database with experiments. It is constructed as follows:We now have 3 workspaces with experiments, one for email, CRO and socials. Now we want to have an overarching workspace where all experiments come together so that we have one large database. For example, we can collect all experiments from one campaign.Now I succeed in syncing a view, but it then becomes a separate tab in the overarching workspace. Is it possible to import all data into one table. Or should these be 3 tables and is it possible to merge all this data into one table so that we have one library.I'm curious if anyone knows a solution for this.Regards, Martijn
I have an airtable interface that has a dropdown. When I select a value from the dropdown, it shows me some records in the gallery view. When I click on one of the field, it opens up details of a linked record in the list view. Now I want to show these results in the list view in a filtered format. Two of the values in the filter are supposed to be fixed and the third value can be changed by the user. Is there a way to do this using condition grouping? I tried to do it but everytime I publish the interface the filter vanishes. How do I save my filter settings? I tried an alternate approach using filter dropdowns (screenshot below) but I am not too happy with the UI. I want location as dynamic which user can select and the values under More to be fixed. Is there a way to hide the fixed values but still filter the results based on the default values and allow user to only filter by country?
The title says it all! Time zone is Berlin. How can this be?
Hi all! My team has 3 tables that we use to keep track of events that have associated dates and times, including trainings, out-of-office holds, and planned travel time. I want to create a calendar view in AirTable that includes all 3 of these event types to make scheduling easier. I'm pretty sure that the only way to do this is to combine all 3 tables into a new table where I can create the views I want. What is the best way to import all of the records from those 3 separate tables into a combined table? Is there a script that I can run that will do the importing?Once the new table is created, will I need to create automations that will ensure that if a record is created or updated in the separate tables, it will be updated in the combined table? Or is there a better way to make sure that both places stay current?Thanks, I appreciate the help!
Can I get a notification anytime a collaborator adds a record? Thanks in advance for posting your question! When someone provides an answer, remember to mark their reply as the :white_check_mark: solution.
Hello,I'm reaching out for help on Interface Design ---> How can I add an editable checklist into my Interface? I keep running into problems (outlined below). If there's a simple way to add a checklist of, for example, 10 items, with an editable checkbox by each one that would be great.Attempt 1: Use the "checklist" markdown formatting in a text box. While I am editing, I can check/uncheck boxes, however, when I publish the Interface and attempt to change the checkboxes in the live interface, I can no longer edit them. (Meaning, only "editors" can check/uncheck boxes, but normal Interface users cannot). This is the feature that uses the checkbox in a text list instead of a bullet or dash.Attempt 2: Inserting a "checkbox" field into the interface as an element. I figured I could just insert the checkbox from a "checkbox" column into the Interface, but the formatting doesn't work. If I use the default label, it will only sit above the text box (making a "list" view
Is anyone else having problems with slack sending an actionable message? 😣everything was working fine until Monday. My regular slack message automation is working fine! I disconnected and reconnected the my slack account to airtable. I also ensured my Slack had the airtable app integrated. All I see is the following message but I do not see what the actual error is. The channel and slack account is correct. The trigger also works perfectly. SOS.
Hi, My organisation is on the Team Plan with budget allowing for only one collaborator. We need to email read-only users and / or external emails (max 50 recipients per email) but I'm unable to find out so far if this is possible without being charged. I'm also struggling to find the limits on these type of emails. I've attached a basic example of a select number of records which I wish to share in an email. Would appreciate if someone could advise / tell me a better approach! Thank you.
To group records for planning purposes, I use a unique code for each record, then a custom text field to assign one of those codes to records that need to be grouped. This is for planning vegetable plantings with multiple vegetables in a plot. Here's an example of how that works:Where ID + Field Date is generated, and then I manually assign one of those codes to "planning ID" where those crops need to be considered as a group for certain planning activities. For planning purposes, I have a view that groups crop/records by planning ID. I also have one that sorts by crop in alphabetical order. However, I need a visualisation that does both - e.g. I need to be able to sort by crop AND visualise the other crops that are grouped by the same planning ID. I don't necessarily need an easy link to those other relevant records, but it'd help hugely with Day-to-Day if I can find "Bush Bean Xera - 300 Transplants" alphabetically, and easily see the names of the other records it rela
We have a "Last modified time" field that updates when either of two other fields are changed. We discovered a group of records all modified on the same date and time (05/11/2023 at 12:50 PM) but when we opened each record to see the revision history, there is no trace of how the records were touched. How could that happen?There are no automations that run on a schedule.There is an automation that runs when certain triggers are met. We looked at the run histories but none of them ran at that time.Any ideas?
Airtable's API does not permit the import of all fields containing numbers or currency ending in zero to no-code platform Bravo Studio. Can someone provide me with any tips or insights on what might be happening?
On this view,I need to create groupings based on the Max Price and Listing Price.The amount should match, but when I tried to do the grouping it did not show the correct numbers.here's the current setup. Here's the outcome.The Max Price Should be $280k but why is it that the Listing Price of $285k was included on this group which supposedly was not?
Hello all! I am in need of some brainstorming. My organization uses grant funds for some of our programs and I am trying to figure out the best way to keep track of how much we have left and which programs they are linked to. In order to do that I have one table with all of our program information and one table with the information about the grant, i.e. how much we received. For most of the programs we only use funds from one grant, so right now what I have is on the program records table a field for how much grant money was used, then I link it to a specific grant and in the grant table a rollup and then formula field calculate how much of the money is left. However, on occasion we do pull funds from two grants for one program. This creates an issue as then both grants are pulling the same number from the program records table and subtracting the full amount from both totals, rather than the partial. I considered having two used funds fields in program records, but then I realized I d
Hi all - I've noticed a new issue in interfaces. When I add a text element, it does not expand to show multiple lines of text. In the screenshots below, see that I've added a text element containing a bulleted list with two lines. They both appear when I'm clicked into the text box (although the blue box only surrounds the first line), but as soon as I click out of the text box the second line disappears. I cannot find a way to resize it. Didn't the resizing used to happen automatically as more lines were added?I feel like this has just started happening recently. Has anyone else noticed this issue?Thanks,Kelsey
Hi,I'm trying to push date from an Airtable base to a document managment software, NetDocuments, using the latter's native integration software, ndLink.How do I set up an Airtable base as a ODBC DSN connection?Best,Harrison
@Phil_Rose @LarsJohnson I'm not sure who to direct this to, so I hope one of you can help.I need to get some idea of what is going on with the changes that seem to be going on. I have a interface designed for a client, and finally have reached the point were I am getting to have them upgrade their production account. To get ready I needed to make some final changes based on their feedback using my test account.I needed to add some list pages with sidesheets that are where some fields are made editable. The ones I have on the existing test interface were easy to format and allowed resizing of the fields as well as positioning several on a line. A partial section looks likeWith the changes that have been made all I can do is stack the fields with the labels to the left This is totally unacceptable. I know it looks like a minor thing, but this was only the simplest example. When you multiply the issue over the number of fields and pages i
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
