Ask the Community

Hi everyone, Is it possible to switch cards customization between tabs in a same interface ? Thanks for your help !  François

Hi, I am having trouble figuring out an automation.I have a field for a project end-date, and I use an automation to enter a fiscal quarter based on a date table (and another automation to update that quarter if the date changes). When the project is cancelled or put on hold, I need to remove that date. When I do that, the fiscal quarter field remains as the last entered. Is there a way to have that revert to blank?Thanks!

Hi all,We save some record fields that contain attachments in our airtable database. I've been asked if it's possible to send these files to an external company via POST api call from an airtable automation script. The call must be form-data and the endpoint is expecting a file in the key-value format. I've attempted sending the downloadable url but this is being rejected as expected. Is it possible to have the automation save the file from the downloadable url, and send that? I know there's some issues with sending files themselves with airtable. Any advice is appreciated, worst case we can download to our external database and send from there.

Hello Everyone,I have a base with various scenarios, each of which has a template field and a field for attachments.I'd like to be able to create an automation that will open the current users email client and insert the relevant template and attachment.So far I've been able use the "mailto:" protocol to do as much with the written template but this doesn't support attachments. The email account can change depending on who is logged in to the database.TL;DR: I need to automate opening the users current email client and inserting the relevant attachment from the database record.

Hi,I am trying to add cells together in order to find the line by line tracking.For example, in the image below, I am looking to add up the different profits in order to obtain the amount present in the bank account.Can you help me ?Thanks !

HiI want to search a number with a date, like this : Can you help me ?Thanks !

Hello all,In the past, I was able to hover over my workspaces names on the left side navigation bar and rearrange the order of them, but now it is no longer possible which is a nightmare as some that are not that important stay at the top as they were created as last. This option is no longer available for some reason. Any idea why is that removed? When I hover over now the dots do not show.Any help appreciated.  Thanks Jen

Hi, I'm trying (and struggling) to create a formula that allows us to filter by 'people who are currently contracted by us'. We have a start date and end date column within the table, so ideally I'd like to add a formula that allows us to filter based on whether today is in between their start and end date. Does anyone know if this is possible please? Or if there's an easier method of filtering that doesn't involve us manually ticking a box for people that are currently contracted. Thanks! 

I am building a "record review" interface, and I am struggling with the calendar element.  Each record has a series of dates as milestones but unlike every other field, I don't see a way to filter or format the calendar to show ONLY the dates of the record I am reviewing, it only shows the milestones for ALL records.Is there really no way to filter a calendar, either as a view or as an interface element, by a specific record?  This seems like such basic functionality I am struggling to accept this is the case.I found this thread which seems to clarify this, but I am re-asking in case I am missing something:https://community.airtable.com/t5/interface-designer/is-it-possibel-to-show-dates-in-a-calendar-element-within-a/td-p/183219

I'm a total novice with scripting and automation, so I had ChatGPT write a script. It looks right to me (I've double-checked the strings) and does not throw out any errors, but it is not having the desired effect on my base. Would love some pointers... Thanks in advance! My goal is to run this each night to ensure that I'm only seeing the current month's transactions in my view, but never less than the seven days before or after today. When I run the script, it finishes without error, but does not change my base and there is no output when testing the automation.  // Define the table and view let table = base.getTable("Transactions"); let view = table.getView("All Transactions"); // Fetch records from the view let query = await view.selectRecordsAsync(); // Get the current date let currentDate = new Date(); let currentYear = currentDate.getFullYear(); let currentMonth = c

I have two tables in the same base. Each has a field that contains a member number. However in table 1 the member number is a formula. How can I write a formula that will return a different field (member name) from the second table into a new field in the first table if the member number matches? In Excel I would use vLookup

Hello all!I have a formula field in one of my tables that generates a custom URL to an Airtable form where I want to pre-fill one of the fields, and send the URL to the main point of contact through email.The formula is this:  CONCATENATE("https://airtable.com/XXXXXXX/ZZZZZZZZZ/form?prefill_ClientID=",RECORD_ID(),"&hide_ClientID=true") And it shows in Airtable correctly (this is a direct paste from the table field): https://airtable.com/XXXXXXXX/ZZZZZZZ/form?prefill_ClientID=recTuHzXP2YsNencA&hide_ClientID=true

The relatively recent addition of "default to current date" is really useful on date fields, where 95% of the time the user is going to select "today."However, it seems that the field doesn't use our local timezone, unless I enable "display time." I don't want to have to enable "display time" as our bases are designed to be used on mobile, so it's always a challenge to keep views succinct. Is there a setting I'm missing, or is this a bug in Airtable?Here's a couple of screenshots:Showing the variance in the baked in "created date" field and the "date" field, which defaults to current date.  Here is the edit history of the "beetroot" record, showing that the

Hello, I built an interface which allow users to add records in a list table, when they click Add record. I would like to have the new records opened directly in their expanded layout, instead of creating a new line and then clicking the line. Is this possible ? (Via the Add record of the current page, and even via buttons in other pages)I can try scripts but I've never done that before so any help is welcome !  Many thanks for your help

Apologies if this already exists in the Community ... If I create a Base (Base A) that has a Table with 100 contact records (for example), can I create another Base (Base B) that has a Table that links to Base A? Then, if I update a record in Base A, it gets updated in Base B and all Bases to which these records are linked/ propagated?Thanks in advance.

Hello,My organization has developed a great app in Airtable for our really unique use case (context at the bottom). The functionality of the app is really, really great. The user interface design and usability is poor and is now causing problems, and I'd like help improving the user interface.The biggest problem is that we have so many different datapoints that we need to access, that our "Grid View" tables are too wide, so we can't see all the information at one time that we need to see. How can I transform my Airtable user interface into something that's really helpful and usable? All the data is there, and it works well, but the UI is too complicated. Does anyone have recommendations, best practices, or resources to help me understand how I can do this?I also consid

Hello --I am interested in developing a formula to assign ID's to a series of payments based on type of payment, date, and information on payee's name. This is for tracking payments in a program that is pairing experienced mentors with mentees.There are various payment categories (Mentor Initial Payment, Mentor Final Payment, Mentee Stipend Payment), the year in which the mentorship in question started, the name of the mentor, and the name of the mentee(s) that I would like to integrate. I'm hoping to develop something where if this was a Mentor Initial Payment to John Smith for mentoring Joe Boggs and Jane Doe in 2024, based on values in the Payment Table (payment type and date), linked records Mentor table (First and Last Name of Mentor), and linked records in the mentee table (First and Last Name of Mentee or Mentees), a unique payment would auto calculate producing something like MIP_2024_JS_JBJD.The first part is obvious to me (IF function), I'v

 Hey there. I came soooo close to getting a working formula for what I was trying to achieve but fell at the last hurdle.I have a date field and a number field from a lookup. I am trying to create a formula that gives me a new date based on the the date field and the plus or minus number in the lookup number field. I am using this formula currently which is working and showing the new dates correctly.DATEADD(Date, VALUE(Deadline&""),'days')  I am trying to update this formula so that it only takes into account workdays but anytime I also try to add this, I get an error in my formula field:WORKDAY(DATEADD(D

{Rate (from Contract LU)}/{Frequency (from Contract LU)}Rate is a currency field and Frequency is a number field. Both reside in the Contract LU table.I have been using the above simple formula in invoicing successfully for quite a while. I recently had to create a pro rated  invoice for the first time, so I could not use the formula as is.My approach at the moment is to create a checkbox field for pro rated invoices if it is pro rated. To use it I need to be able to write a formula that allows me to enter a pro rated amount if the pro rated checkbox is checked or to allow the original formula to continue if it is not checked.First, is this the best way to do this? Second, how do I write the new beginning of the formula to allow an input.Many thanks in advance.Scott

Dear community,How wonderful would it be to have the functions of: https://track.toggl.com/timer in Airtable. I would love to be able to activate the current Airtable time tracker per project (start, pause and stop) in an interface and get reports per project, sum of all projects, per week, per month per year. And be able to manually override (because it occasionally happens that I am working on a project and forgot to set my toggle timer...).I have been puzzling for over a month now with last time modified, duration, datetimediff and with the time tracker from Airtable, but I do not get the results that I want (which is basically the exact functions of Toggle). I did learn from the topics in the community, but this still does not bring be to what I really want. Is there anyone in the community that would love to have this function in Airtable as well, and do yo

I have a table with fixed license plates, the cars should be checked regularly and a form is filled out. When the form is submitted, all data from the form should be entered in the correct place in the table.Example:Registration number: ABC-123 in tableVehicle inspection was carried out on a vehicle with a license plate (ABC-123) and now the data should be entered in the table where the license plate "ABC-123" is located. how do I do that?

Hi how can I get data from air table using code in gsheet?

Hi there, below is a snippet of an interface I've set up. I have multiple filters that influence which records are used to sum the various metrics below. The next metric I'd like to implement is a ratio using the summed numbers, for example number of emails sent per user so 109167 / 51065 =  ~2:1. Is there any way I can do this? I'm happy with doing the actual calculations in a nocode tool if there's a way to send across the list of filtered records but I can't figure out a way to do this. If anyone has any ideas or perhaps alternative tools I could use for this exercise then please let me know, thanks in advance!

Hello, I have 2 tables, clients and tasks. Each task has a linked record field to the client. I want the automation structured so that when Task ABC is Complete, the linked client's stage (stage is a field in the clients table) updates. I am struggling getting the record ID for the linked client record for the subsequent steps. 

Hi! I have a table that is defined by an auto-incrementing numerical id, and then the secondary field is "Name". I want people to be able to select records in a form based on that name, or at least validate the ID they've selected is the correct name. Is there any way to display a look-up field within a form, or even better allow a user to select a linked record based on searching or browsing a look-up field?Thanks in advance!