Ask the Community

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 However, when the email automation runs, the URL that shows up has the 2 underscore characters removed, as follows:  You'll see that the "_" characters after the words "prefill" and "hide" have been stripped.  I don't believe it's the email client (Google) doing this, as I can email the direct link from the table through email and it comes through fine. Any idea why this is happening? John

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 user (me) didn't accidentally select a different date.

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 considered using "Record Viewer" interface, but I need the "high level view" of all records, not just "zooming in" to one record at a time.I'd love to use List View and have a "2nd Row" of fields I coul

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've looked up how to extract year

 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(Date, VALUE(Deadline&""),'days'))doesnt seem to work. Wondering if someone can see where I am going wrong. Thanks in advance.

{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 you have a clue how to build such a tool? I think everyone who would like to track time on projects would be

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!

New Airtable user here, so this is a pretty basic question (and so hopefully a straightforward answer!), though I can’t find existing guidance in the forum. Specifically, I’m having no luck creating a “Link to another record” column that automatically populates itself with those linked records. The Project tracker template provides an example of exactly what I mean: the Task column is linked to the Tasks table and automatically fills with any new records that are added to the latter. When I attempt to create a new “Link to another record” column with this functionality, however, it’s blank and stays blank (doesn’t pull in existing or newly created records from the Tasks table). What am I missing? Do I also need to create an automation, app, or something else to do the work of pulling in the records? (I don’t see any such automation or app in the template though). Any guidance extremely appreciated - thank you!

Hi, Has anyone been able to figure out how to batch download images from Airtable into a folder with a naming protocol for each image based on information from the same row? Thank you, Diana

Hello. Right now i’m using air table to manage student information for my study abroad bussiness. It’s very good . But there’s one small problem, i want to automatic export data every day, but i cannot using the API through zapier because it’s not support automatic export. So is there any way i can do this and beside airtable, is there any other tool with similar function but support automatic export. Thanks in advance.

Hello,While testing my script to parse some pdf/excel documents - all under 500MB (considering the limit is 5GB) - any solution? Or is the 5GB limit not per document but for the whole account?Thank you in advanced.

I have a BOM for each model we produce in our factory. I want to develope a database that allows us to control de actual stock we have based on the quatity and model of our production. Is it possible to do so without using a script and by introducing only a forms with the quantity and the model procuded? Just to understand my problem, each model uses at least 30 different components, with different quantities.Thank you

Hello,I've created a database with a form and applications that allow each employee to make holiday requests.They can apply for leave over two months (example: from 10/08/24 to 16/09/24).My requirement: I need to know, for each employee, how many days of holiday they have taken each month.Additional information:I have the date of the first day of leave + the date of the last day of leave + the total number of days of leave (excluding public holidays and weekends). If they only take half a day, the number of days off is 0.5.What can I do?Thank you for your help.

Hi Can anyone help please? I am trying to find a way to count linked records in the same table I think someone may have found a work around but am going around in circles trying to find anything I can understand. Thanks, Maria

Please help I need a formula for reoccurring seasonal milestones.  We have seasonal launch dates and milestones in each season that occur at intervals;  -130 wks, -80 wks, -56 wks.  I want to calculate the due date of the milestone based on season launch date  & milestone -wks (-50wks) to generate the due date for that milestone.   Please help! 

HelloI would like to know if there is a possibility to add lookup field data from two different tables to a third table and have them appear in the same column?  Thanks in advance!

I want to preserve the setting from a search on an interface page, this needs to be dynamic, so a view does not work as I don't have access to the setting from within the interface page.Below is an idea of the search, location, age, gender etc... In this case a Filter connected to a grid inside a interface page shared amongst users. Rather than copy and email the link to them it would be great to name it and save it.If I copy the page url for this search the parameters are contained in the URL. I want to be able to save that url into a 'Saved Searches' table that we can refer back to a reload said search.