Ask the Community

Hi everyone,I have a column with a series of numbers, and I can easily get the median from this summary above it, but for the life of me I can't figure out a formula to get the same results in a separate table column.Ideally I want this data in a table so I can use it for other calculations. I've been searching for hours but can't find anything. The closest I can get to this is using the rollup field to roll up all the numbers and then use the AVERAGE formula, but I need to get the median average. Would anybody know a formula I can use to get the median? I've tried other formulas from other places on the forums, but they don't seem to work for me.  

Hey everyone,I'm working on migrating data from an old database to a new Airtable base, and I've set up linked tables. I've also created a script extension that successfully migrates a record when I manually select it within the extension.My goal is to embed this script in a button field on my interface. This button should allow users to run the script directly on the current record they are viewing, without having to open the script extension and select the record manually.Here are my main questions: How can I pass the current record (the parent of the button) as an input context to my script when the button is clicked? I need the script to know which record it should operate on. I've noticed that when I link the button to my script, the button appears disabled. Is this because the script is expecting manual input (like selecting a record from within the extension itself), and if so, how can I configure it to be runnable directly from the button? Any insights or examples on how to a

Hi all! I’m relatively new to anything beyond simple in Airtable, but I’m learning through trial and error. I’ve ran into a problem I can’t solve though (yet) and would greatly appreciate any and all help. When using the following formula i end up getting error messages. IF( {Kontroll intervall}="Varje vecka", DATEADD({Senast kontrollerad}, '7', 'days'), IF({Kontroll intervall}="Varannan vecka", DATEADD({Senast kontrollerad}, '14', 'Days'), IF({Kontroll intervall}="En gång i månaden", DATEADD({Senast kontrollerad}, '30', 'Days'), IF({Kontroll intervall}="Varannan månad", DATEADD({Senast kontrollerad}, '60', 'Days'), IF({Kontroll intervall}="En gång per kvartal", DATEADD({Senast kontrollerad}, '120', 'Days'), IF({Kontroll intervall}="Ombyggnad, ej aktuell i nuläget", DATEADD({Senast kontrollerad}, '60', 'Days'), IF({Kontroll intervall}="Ej evenemangshemsida", DATEADD({Senast kontrollerad}, '365', 'Days'), IF({Kontroll intervall}="Behövs i

I’m not sure exactly what group to put this in but I am trying to build out a form that allows you to “pick a speaker” from a list to effectively vote for them. I was wondering if there was any way to show more information when trying to pick a record in a form, ideally the cover photo would be best but anything would make it easier. Here is the “speaker” in question (it’s me!):

Hi, I am trying to set up an automation to send emails from multiple email accounts. I am able to add multiple accounts by clicking “manage connected account” and logging into Gmail. But I am wondering if there’s a way to invite colleagues to connect their Gmail accounts? That way, I could select different emails to come from different colleagues’ accounts. Is this possible? Thank you in advance for any insights and help!

Hi! My team has used Asana to create templates for different categories of events that auto-populate tasks with due dates (e.g. 45 days before event date). What is the best method to creating similar templates in Airtable? Below is a screenshot from the Asana template.  I’m looking to get each Due Date cell to auto to x days before the event date, excluding weekends. I tried using DATEADD, but this does not work on individual cells. Thanks!

I am comfortable creating a prefilled form using two tables. I am having issues getting a prefilled form to work across three tables. The top field in the form is a Link field between the primary and secondary tables using the recordID. Simple enough so far. But I have a third table with records that link back to the primary table. I want users to be able to select records (from this third table) in a second Link field at the bottom of the form. My attempt at doing this is creating Link fields from this third table to both the primary and secondary tables, hoping the record ID would pull through to populate the selection in the prefilled form. My thinking is that the record ID for the Third--->Primary and Third--->Secondary links are the same record ID. This has not been successful. Below is an example of the formula I am trying. CONCATENATE("https://airtable.com/abc/xyz/form?prefill_PrimaryField=",RECORD_ID(),"&prefill_SecondaryTableLinkToThirdTable=",ENCODE_URL_COMPONENT(RE

Hello, i created a project and all was running correctly.. i had to delete it to re-create it inside "my first workspace" and now i get error "airtable team plan cannot run script on your current billing plan" ..so,first: how can i get script running again?second: why i've been billed $24 if i'm on trial team plan?third: i see 10 days left for my free trial; In case I regret the purchase, how can I get my money back?Thanks

Hi,I was hoping I might have some help with an Automation please.I’ve been working on an Automation that will allow people to submit job requests via a form, and then have these jobs appear on my calendar for my accountant to reference. The automation works off a number of fields and a script per below:When a form is submitted > Run a ScriptThe script looks at what day it is, and starting at 10:00am in 1h blocks will add jobs to the calendar that day as long as they are before 9:00pm.Jobs falling after 9:00 pm will be pushed to the next business day, and anything on the weekend is pushed to Monday.The script also look for a specific job type (floor plans) so that only they count towards the slot number (10:00-11:00am, 11:00-12:00pm etc).As best I can tell, anything relating to the timezone of the automation and formulas it ties into is set to “Use same time zone for all collaborators” with the zone set to “Australia/Perth”.However, for some reason the first slot always seems to defa

Hi, I am trying to set up renting hours for a local association and I am looking for the best way to do that.We have some outdoor material that can be rented by the hour. Would you have a smart suggestion for not having to write manualy 8 lines (8hours per day of renting) x 123 days (4 months of the summer) = 984 lines ?After we will see yo integrate that with a google calendar.Thanks

Hi Airtable Community, my question is quite long so I have included a Loom video to help describe my problem: Automating Monthly Data Integration in AirtableAny and all help will greatly be appreciated! Thank you! Walker Milhoan

Hi everyone – i saw some folks ask this questions but have not seen an answer as of Q2 2022. Is there a way to embed interfaces into another web app/ website? If not, is there a workaround like an elegante way to embed the whole airtable app into another website? Thank you!

right now I have two calendars for my inbound and my outbound dates. I want them both to be on the same calendar

I currently have a system created to track gear that comes to my warehouse and then leaves.I have different ways in where this gear arrives such as picked up by us, dropped off to warehouse by client, picked up by client from warehouse or returned by us. I have a field for each of those ways. most of the time when it is picked up by us it is also returned by us. I want each entry to automate being returned up by us when i choose picked up by us. Same for the other ones that are paired. What steps do I have to take to make it to where each time I make a new entry that this can be automated? I also do not want it to effect previous entries already made.    

I changed the primary field in a source table. I also want that to be the primary field in an existing synced table, but the primary field doesn’t change.If I go to “Update sync configuration” and then “Edit synced fields”, then select “Specific fields in the source...” it does not give an option to change the primary field, like you can when first creating the sync.I’m syncing a view from the source table, so I could create an identical, duplicate view there and then change my sync to point to the new view, but I worry about how that will impact all the lookups I have configured. Will I need to redo them all, even though the fields will actually be the same? So I’m hoping there’s a way for the synced table to use the new primary field from the source.

Hi there, If this is my data (which I think needs to be set up differently), on my interface I am using a blank canvas so I can use images and other information.  But how can I get this data to show as a line graph where the month is the X axis and the Y axis is the amount of days and each line would be the location?  

 Originally when we created our system, we used text fields to record the Call Time and Gig Time Span. Since we have the time zones already saved for each record, I am wondering if there is an easy way to do the following: Switch the Call Time Field from a Text Field to a Time field (without having to type the time zone every time) Switch the Gig time Span Field into 2 different Time fields for both previous records and current records, a Start Time and End Time. Similarly, I do not want to type the time zone every time. Moving forward, I would like to only have to type the start start and end time for an event in separate fields (not in the text box).If this is possible, these would save a ton of time and allow us to do better, more efficient work. Thank you for your help!

Is it possible to export a revision history? And if so, can a specific date range be specified?

Hello. Thanks for any help regarding this.I have an integration running in Google Sheets where Amex charges are downloaded into a Google sheet, almost realtime.  My goal is to create a connection so that when a record is created in Google Sheets it is copied into an Airtable base. I think it should be just one way from Google Sheets to Airtable.The challenge is that the integration between Amex and Google sheets deletes all existing records and does a full re-creation of ALL the records in the Google Sheet whenever a single row is added.I didn’t realize this when I created a Zapier Zap to create a new record in AirTable every time a record was added to the Google Sheet. Before long I had thousands of Zaps on hold.  For example, in the Google sheet if one new Amex charge is added, for some reason it deletes the 500 existing rows and adds back 501 new rows.  I asked support for that product why they do it, but I’m certain they’ll have their reason. Just haven’t heard back yet.So to make

Hiya! New user here, so forgive me if I’m being silly! I’d like to limit character input into forms to a certain length (let’s just say 32 characters for argument’s sake). The proposed form is for clients who want to submit product descriptions to an app (hence the need for character limits). Now I could go through and check each one individually, but it’d be great if I could just set a limit warning instead. I read this previous post: https://community.airtable.com/t/limit-characters-in-long-text-field/7353 but it still doesn’t solve the client-facing form issue. One thought I had was another app integration? I haven’t checked if this is possible yet, although I suspect I’ll fall into the same character limit problems. Has anyone got a suggestion or a neat way to make this happen? I’d be much obliged! If you don’t think it’s possible, please leave a comment saying so - it’d be great to know either way!

Hello, I have a base that has the date and time in one field, I have created another field and I would like to have that field enter the YYYY from the date time field using a formula. Would anyone know what the formula would be? Thanks in Advance!

I'm creating a form and need to create some conditions to separate our large inventory into categories.  When I create the form view from the data table screen, and run a test the dropdown looks like the first snip below and appears to enter the data sheet with all of the correct information.  When I add a new field and link to record, choose the same table, set up the conditional formatting and run the test, the dropdown looks different (second snip) and all of the information goes into the data table except for the name.  As far as I can tell they are set up exactly the same way, the only difference is the Product ID field is automatically entered when I create the form view.   Any ideas on what I'm doing wrong or how I can properly duplicate the product ID field?  

So I have a table called Investors. Say there are 300 records here. And I have a table called Companies. Say there are 100 records here. And I have a tabled called Individual Investments. It’s the intersection of Investors and Companies. An investor can invest in any deal they choose and invest any amount. So I might have, say, 2,000 records here (but obviously I wouldn’t have more than 30,000 — which would be if every one of the 300 Investors invested in every one of the 100 companies). In the Individual Investments table I list the Investor, the Company in question, and the amount they invested. We’d like to send a report to each investor that lists all their investments and how much they invested. I once figured out how to put this together in the Page Design block and I’m sure I can muddle my way there again (or come here for help) but I also want to email out this report as a PDF. And not just one big report showing all 10 investors what all 10 invested in, but a customi

Good day.I have a “whole” staff table, with various “statuses” SOWs, Guests, and FTE.  However, a newer table was linked to the base, with “special” contractor statuses.  I need to have these “added” to the above Full Table, along with their statuses, etc.  The whole needs to be the final source as it’s used across bases.  How might I go about this?  

Hello community, I created a DB to collect startup informations through a form.To impose a synthesis, I need to set a certain limit of characters for “long text” question.I can not find a way to do it with Airtable form, so I am integrating a different tool.Nevertheless, it’ll be more practicle for us to stay inside Airtable.Any suggestion ? Best regards,Marco