Ask the Community

When you’re using apps, you can click on a bar on a chart and it’ll pop up a window that shows all the records in that particular bar. How do I do this in interfaces? Am I missing a setting? Right now charts aren’t interactive at all.

I'm new-ish to AirTable formulas (though experienced with spreadsheet formulas) and I have a unique situation where I would like to calculate a calendar date based on a combination of units that include Frequency (eg, monthly or weekly), Day of Week (Mon, Tue, etc.), and Week# of Month.For example:  X event occurs every three months on the third Weds of that month. These schedules are variable by record (it's a client service schedule), so some clients are serviced once per week while others are serviced once every other month, etc. The goal is to show at least the next service date after today (and if possible, all future service dates throughout the year) on a calendar view. But I cannot just add a number of days or weeks to calculate the next date because the schedule needs to place service events on the particular week/day/month combo.I do not have a starting formula yet because I'm not sure what logic is needed to pull together the variables. If I can provide additi

Hello. Im a long time Airtable user.Recently i got a few credits from referrals and updated a workspace to business using it.Today I've reffered to around 8 people, they appear as "accepted invite" but no credit appeared, why?

Hey all, Long time coda.io user switching over to airtable as my business grows. A key feature I love is the ease of building UI’s over the top of the databases. I’ve done some research but haven’t been able to come up with an answer. Using softr.io, stacker or any other alternative… can you have an ‘embeded’ table where the data can be changed. Basically, I want the full functionality of the airtable ‘table’ / ‘view’ to be in a client portal, a long with other items such as invoices etc./ Thanks in advance,

Hi - I have this list view setup to allow for new records to be created in-line but for one level it seems to work and another it doesn't. I'm not sure why - screenshot is attached to explain. Very grateful for help

There is an issue where:Every time I paste something into a long-text field, it scrolls to the top of the long text field. Then I have to scroll back down to continue writing. When working with longer texts, this can be very annoying.Any ideas?  

Hello! I have an event workback schedule set up with a formula column to auto-generate a due date based on what date I specify in my date column (see ex. formula below). However, I would like to have the formula column auto-generate a list of due dates based on one 'master' date. I BELIEVE this would be an automation, possibly?For example, we have an event coming up on April 7th. I would like to specify 'April 7th' in Airtable and have all the due dates in my work back schedule auto-update. Rather than go through each row and change the date.  DATETIME_FORMAT((SWITCH(  {Deliverable},  "Request agenda items", DATEADD({Meeting Date}, "-10", "days")

When adding data to Airtable records using Softr, I encounter a significant delay of around 4-5 minutes for the data to appear upon refresh if the records contain foreign keys referencing another table. This delay contrasts sharply with the immediate addition and display of data when records are added to a normal table without foreign key references. The presence of foreign keys seems to introduce a lag in the synchronization or processing time, leading to a noticeable delay before the updated data is visible. This issue may be attributed to the additional steps required to validate and integrate the foreign key relationships within the database, causing a slower response time compared to simple table updates.

So I'm trying to import images in an attachment field.  I tried connected my Dropbox account but unfortunately it's not showing all the folders in my Dropbox account.  It's only showing the first folder.  Is there something I'm missing with permissions maybe? 

Hi, I've been asked the question regarding the Airtable data in the Mobile app. Is this data stored on the local device at all? Or is it effectively just viewing the online data ?  Its  a security concern regarding giving access to employees on their own phonesThanks  

Hi all, im struggling to figure this one out and feel like there is a simple solution 🤔 🤔 I am create a resource library for a group of companies, so they can share resources between themselves. Here is a copy of the base...https://airtable.com/appPv62y3frc8BYJA/shr7YAMJDLTc4czrW How I see it working is that when a company views the library and finds a resource they would like, they can click on the 'Request info' button (viewed when clicked on tile), they can then select the 'company' that has the resources then sends the request. Right now I have the button generating an email, which is fine when there is only one provider of the resources. But when there is more than one provider the button doesnt identify the different provider options.I know i'm missing a simple step! Any ideas on how this could work? Many thanks,   

Hi all, I am trying to get a script to run within an automation (I have used AI to write this as my scripting knowledge is low) however I can not seem to get it to write to the single select cell called status fix. If anyone has any idea i would be forever greatful! let table = base.getTable('RSS Feed');let query = await table.selectRecordsAsync();// Function to determine the statusfunction determineStatus(suffix, isFirstTime) {    if (suffix === 1) {        return isFirstTime ? "First Reading" : "Select Committee";    } else if (suffix === 2) {        return isFirstTime ? "Second Reading" : "Committee of the Whole House";    }

I have an automation that is sending a Google Doc link via gmail. But when the link sends, an underscore is left out somehow, so the link doesn't work. Any idea why? Or is there some kind of work around?This is how the link is showing up when it gets emailed:this is what the message looks like in the automation :  This is how the formula looks that is making  the g drive certificate link-- the link shows up fine in the airtable. "https://docs.google.com/document/d/" & {📜Certificate Google Doc ID}& "/edit?usp=drivesdk"The broken link seems to happen only when the google doc ID has an underscore in it.

I support an organization fundraising in a variety of currencies (USD, GBP, EUR, CAD, ILS). To simplify the process for the person maintaining the list, I have a single number field for the donation amount and a single linked field to select the appropriate currency (this is opposed to having 5-6 different currency fields on the intake form and needing to choose the correct currency field each time). We found that it was easier and faster to use a linked filed as opposed to a single select for currency.I would like to keep a running total of all the donations' values in both USD and EUR so I can use rollup fields to display overall amounts on a dashboard (i.e. my 100 donations in a variety of currencies are worth a total of USD 10,000 or EUR 9,500).Exchange rates are "static" in that if on the day of the donation, the ILS:USD rate is 4:1, it should stay calculated at that rate forever, even if in a year from now the rate is different. Exchange rates will be updated once a year based on

Hello,Can someone please shed some light on what the "Full" and "Access Read-only Share links" options are under Read-only Share links Configuration section? The help page here talks about everythign except this option.Thanks so much for your help!

Hello All! I was wondering if anyone could explain in more detail how the sync feature works in relation to payment plans. We recently upgraded one of our workspaces to a team plan, and were looking at ways to have more users as read-only. I wanted to see if the Workspace with the Teams plan could operate as a large data repository, across departments and functions. and then have specific views feed into other workspaces. (i.e. A central place for customer data with a wide variety of customer types, and needs) Then the Teams workspace can handle automations, and large numbers of records, while the free workspaces are synced with a subset of the data. I attempted to sync from the Teams workspace to an unpaid one, and it said that it wouldn't work. But it seems to have synced anyway but may just not be updating. Please let me know if this is a viable option, or would there be an automation to automatically push any changes made to the Synced non-Teams Workspaces.&nbsp

Hi,I have a base with a list of tasks that need to be performed. Every task has a list of different subtasks (about 6 per task) that need to be checked off by someone who performs the task. What would be the best way to approach this? Thanks,Mark 

Hi, So lets say I want to create an interface or even a table lets say, where I can take records from one table and filter it by a certain date/time frame and get those records. For example. Table 1: Has clients that signed up from different months in different products. Table 2: Takes that data and sorts it into how many clients went to each product. Now I want to be able to just pick dates of my choice to see how many clients for a certain product I got in a certain time period. Thanks

About My Project:I have a database that captures notes for multiple users with hierarchical categories. I want individual users to have the ability to view their notes (and not the notes of others) by these different hierarchies (which are category, sub-category, type, and tags).Information is ultimately consolidated into a table called “Sub Categories,” which includes all of the hierarchies.Each note is an individual record and the columns are: id, last modified time, category, subcategory, types, entries (this is the note itself), tags, user, and title. I want to create an interface that allows users to view their notes (and only their notes) broken out by day, category, sub-category, type, and tags. I created an interface with a gallery view (in hopes that it would look like the apple notes gallery view), and I want 4 dropdowns that allow a user to filter their notes by these different hierarchies.Problem: When I add a filter, I have to choose the option that I want to filter by. Th

Hi all - I’m trying to run an automation using a 3rd party Webhook. When a new Post is sent live, or updated, in my WordPress site I want to send various bits of info about that Post to AirTable. Everything works fine when I use ‘Create Record’ (so I know the webhook works) but obviously if I update the Post at any point it just adds it as a duplicate. So what I want to do is use Update Record instead (I think?). When a new Post is created, add it to AT, if that post is updated, update the record in AT. However - my understanding from this post Update record action failing (error: received invalid inputs.) - #3 by Brian_Nana-Sinkam, given what @Kamille_Parks says, is that I can’t use a Record ID from my Webhook e.g. Post_GUID. I need to use the AT Record ID. Which I don’t have available it seems. Is the only way around this to run the script that Kamille posted or am I missing something? Seems like a weird ‘feature’ if AT designed things this way, so I’m hoping I’m misunderstanding so

I'm not sure if I'm looking for a formula or if what I'm wanting is even possible, so this is just a general question about utilizing the progress functionality for percent fields.What I'm hoping to accomplish is a percent field, set to view as progress, that updates based on the progress between two date fields. So for example, if date 1 (0%) is January 1st, 2024 and date 2 (100%) is December 31st, 2024, I'm wanting the percent progress to update as the year progresses to show as it gets closer to date 2.The progress function is great but if it were able to automatically update for tasks that have start/end dates that would make it all the more powerful. Is this possible?

I am using Voiceflow to retrieve data and send it to Airtable via the API. However, I keep encountering the above error despite my request appearing to be correctly formattedThis is in my body.  { "records": [ { "fields": { "first": "test", "second": "test2", "tel": "000000000", "email": "test@test.com" } } ] }   And in Airtable my table looks like this: firstsecondtelemailAny help would be good, thanks

I want to create a field or use a field that will allow me to create "fuzzy dates".  I'm in a business where I want to create records containing a date field.  But, the date field sometimes needs to be flexible.  Sometimes, I know an exact date, like "1 January 2001" or "01/01/01".  But, sometimes all I know is that the event happened in 2001, or that it happened in January 2001, but I don't know the exact date or the exact date doesn't matter and what is important is that I enter for the record that January 2001 is the relevant event measure.  I have used other applications that let me do this quite handily.  So, for the other application, I can enter "??/??/01" to record that the event happened in 2001 and the month and date is either unknown or not relevant.  Or, "01/??/01" would indicate that I know the event happened in January 2001, but I don't know the exact date in January.  It would be quite rare, if not irrelevant, that I might want to

Hello - I need to calculate a date, in certain circumstances, that is 75 days out from another date in my table. I’m using this formula:SWITCH({S/N}, 'no', DATEADD(DOB, 75, 'days'), 'NOW',DATEADD(DOB, 75, 'days'),'NA')which calculates correctly, but includes a time stamp in the results (2024-07-24T00:00:00.000Z). What do I need to do to my formula to get the date only, in mm-dd-yyyy format? My apologies if this is covered somewhere else. I’m not finding exactly what I need in the guides or past posts to this forum.Thanks,Susan

Hi everybody,On my dashboard in Interfaces, I'd like to customize my bar chart this way (see attachments) :- all the days of the week are displayed on the X-axis and the '0' value is displayed if there are no outreach actions on that day- display a goal line- color-code the bars depending on the value range they fall into (red for 1-3, orange for 4-6, yellow for 7-9, green for 10 and above)- have a sorting option in the 'Order' drop-down menu that automatically sort the week days in a chronological order => no need to put a digit as a prefix in the Week Day nameI didn't manage to get those things. Do you know if there are workarounds for my specific needs?Thanks!