Solved

Why is this this Balance Column not equal to Zero 0.00? My Formula is {Net Bill Amount}-{Total Paid} How can I build the Formula that is should say 0.00 , I need it as a 0.00 !!!

Is there a way to initialize fields of type Created Time and Modified Time from existing records of an imported sheet? That way, those fields will be correct for imported records and will be automatically updated as we add and edit subsequent records.

Hi all just trying to decide if AirTable will work for our businesses. So far so good except for this snag. We are in childcare and NEED to calculate our babies ages in Months not years based on TODAY(). This is the section of the child table so far, I want the Age field to return ages under 3yrs (<=35months) in months and the rest in years… Formulas so far M_age DATETIME_DIFF(TODAY(),{C1_DOB},‘M’) &“M” (works fine) Y_age DATETIME_DIFF(TODAY(),{C1_DOB},‘Y’) &“Y” (works fine) Age I’ve tried… to get under 3 years in Months and over in years: IF(M_age <= 35,(DATETIME_DIFF(TODAY(),{C1_DOB},‘M’)&“M”),Y_age) IF(M_age <= 35,M_age,Y_age) No matter what I do the age field returns age in years.

I don’t understand why this was flagged. Hi Airtable! I have a scenario that places data into GS, using a public API and basic trigger with a collection of arrays for tv shows data. I also wanted to use Airtable in the scenario, too. When I run the scenario I get these errors in the GS modules: 400: INVALID_ARGUMENT - Requested writing within range [‘Law & Order: Special Victims Unit’!A2], but tried writing to column [B] RuntimeError 400: INVALID_ARGUMENT - Unable to parse range: ‘Big Hero 6: The Series’!A1 This is the scenario set-up: What does this mean? How do I fix it? Thank you, Mary Kay

Hi everyone, I’ve got a table that I’m having trouble with. In the “Act” column, I have a single-select with Act 1, Act 2, Act 3, and Act 4 as options. When one of those Acts is selected, I want the next column (“Act Dynamics”) to return a string of text. I’ve gone through similar questions from other users and have tried a few different possibilities, but each time, Airtable says my formula is invalid. Can anyone see what the issue is? Here are the 3 best guesses I have: Possibility 1: IF( FIND( 'Act 1', {Act} ), IF( FIND( 'Act 2', {Act}, ), IF( FIND( 'Act 3', {Act}, ), IF( FIND( 'Act 4', {Act}, ), 'Denial to anger;Rejecting opportunity;Ordinary world', ) 'Bargaining and losing;Wanderer' ), 'Bargaining and winning;Warrior' ) 'Martyr;' ) Possibility 2: IF(MID({Act},12,3)=“Act 1”,“Denial to anger;Rejecting opportunity;Ordinary world”, IF(MID({Act},12,3)=“Act 2”,“Bargaining and losing;Wanderer”, IF(MID({Act},12,3)=“Act 3”,“Bargaining and winning;Warrior”,"", IF(MID({Act},12,3)=“Act

I need to make a workspace where there will be a few different bases and with a bunch of different users not all having access to all bases. Some people will need access to the whole workspace, but then there is some that only will need access to 2 out of 3 bases within the workspace. What I can’t figure out is how Airtable calculates usage if the same person will be invited to 2 bases will that count as 2 x user or will it calculate as one user as it’s the same user within the one workspace?

Hi there, I am using the following formula to calculate total donations received within a period of time: IF( AND( YEAR({Received Date}) = YEAR(TODAY()) ), {Amount} ) However, I would like to modify this, so that instead of “TODAY()” - which gives the current year (2020) , I can set a time period like March 1, 2020 to February 28, 2021 (which matches our financial year). How do I do this in existing formula?

Hi, I am getting my table data from Jotforms with an integration. This is working well. I want to then customise my table further and add lots of extra fields in Airtable for workflow, but I kind of want to keep the original import data structure intact and simple. My solution to this is to create a second table which has all the data from the import table linked plus all my extra goodies. I am aware that I can achieve this by creating a new table and manually linking all the fields from the import table, but I wondered if there was a simple solution to creating a complete linked table duplicate in one click? Am I just being lazy? I could have probably done it manually in the time it took to write this but I hate doing stuff the hard way if there is something I am missing. Thanks Pete

Hi! I am new to Airtable. I am currently setting up an Airtable spreadsheet and one field (column) has a date. Is there any way possible to make the column next to it show what date it will be 2 weeks later? Regards, Sam

I’ve been trying to make new linked records from a list of data using the method described here: By having a long list or records and copying them into a linked field. I’ve done this a few months back where it worked perfectly, however now it does not work at all. If I open the linking field and click ‘Create new record’ I can make one at a time, but not too sustainable with a-lot of records. I’ve also tried to use both desktop and browser version but still the same. Is there some setting that does not allow me to create records from a linked field?

Hello everyone, my first post here, looking for some help. I am trying to Send an email every time a new record show in my View. The problem I am facing is the fields that are “Linked to” are showing up encoded, I want it to show the actual result in the email. For exemple: Name: John Webb is showing up as Name: ecLSgtZ3ZsfIejGD Print screen added. Hope you can help me find a solution for this. Thank you in advance.

Is there a way to share Views without requiring recipients to create an Airtable account?

How can I achieve the FLOOR.MATH function that exists in Excel into Airtable? FLOOR and ROUNDDOWN are not taking the precision as I expect. I would like floor with a 0.25 precision: FLOOR.MATH(11.78, 0.25) is returning 11.75 whereas in Airtable: FLOOR (11.78, 0.25) is returning 11.80 ROUNDDOWN(11.78, 0.25) is returning 11.25

I need to invoice/quote customers with layouts that include both text and images. I’m trying to increase the image size of a record but can’t seem to do so. Is there a workaround?

I’d like to embed a view of a specific record on another web site. I’d like to specify the record id / view id on the URL so I don’t have to create a custom view for each record, which is a waste of time. Ideally, I’d like to just embed in an < iframe > the expanded view of a specific record in a view. I’ve tried the following and it displays an unhappy face: < iframe src=“https://airtable.com/tblhtZEdSQOe7XDl1/recP1MM6ZUrqKfpJy” frameborder=“0” onmousewheel="" width=“50%” height=“533” style=“background: transparent; border: 1px solid #ccc;”>< /iframe> The user viewing this webpage will have login access to Airtable. Alternatively, if I could pass in the record ID into an embedded view that would work as well. I know I can filter within the view, but can I specify the filter options on the URL of the embedded url? Thanks for any help. Jerry

Here is the code I am trying to save but keep getting errors. Any ideas? IF(OR({Do you have all the Information needed}=“No”,{Do you have all the Material you need}=“No”),CONCATENATE({My Name},“Can’t perform”{Production Goal for the day/Week:})

I’m hoping someone can assist me with creating a formula. The formula should look at the field Article Title. We have thousands of articles. If any article contains a particular phrase, the field should return a specified URL. For example, we may have 10 articles with the word Movies in the title. For those ten articles, the formula should output https://www.imdb.com. More specifically, the article with the title Top 10 Movies of All Time would result in https://www.imdb.com in the field. This is what I have thus far and it’s not working, at all. IF( FIND( “Movies”, {Article Title}, ‘https://www.imdb.com’, ) ) Thanks in advance.

I’m using the Displaying quarters in fiscal year formula in one of my tables, however, for some reason, Q4 months are showing up as Q1 in my table. The formula I’m using is below. Here is a snippet of my table Here is the formula listed below: IF(OR( FIND(01,DATETIME_FORMAT({Date},‘MM’)), FIND(02,DATETIME_FORMAT({Date},‘MM’)), FIND(03,DATETIME_FORMAT({Date},‘MM’))),“Q1”, IF(OR( FIND(04,DATETIME_FORMAT({Date},‘MM’)), FIND(05,DATETIME_FORMAT({Date},‘MM’)), FIND(06,DATETIME_FORMAT({Date},‘MM’))),“Q2”, IF(OR( FIND(07,DATETIME_FORMAT({Date},‘MM’)), FIND(08,DATETIME_FORMAT({Date},‘MM’)), FIND(09,DATETIME_FORMAT({Date},‘MM’))),“Q3”, IF(OR( FIND(10,DATETIME_FORMAT({Date},‘MM’)), FIND(11,DATETIME_FORMAT({Date},‘MM’)), FIND(12,DATETIME_FORMAT({Date},‘MM’))),“Q4”))))

Hi everyone. I have a base where there are some status to define where are the content that are being created. But, I have to know the date and time when the status “Completed” was added. Do you know how to do this?

Is it possible to map header fields so that I can import an Excel spreadsheet into an existing table that has several different headers?

Can someone please share what formula I would use to update the day for holidays that change each year? For example, MLK Day, President’s Day, Good Friday, etc. all change each year. I’m using a social media calendar template and the current formula is not auto-updating the holiday dates for 2020.

From what I’ve read about the field permissions this isn’t possible, but I hope someone has found a workaround for this? Without Forms, preferably! On View 1 I’d like a field to be utilized by all. then as the workflow progresses and moves to view 2 this field is locked to prevent the user from making changes to the filed and so on.

I manage online content for multiple companies. I need a way to get feedback on content revisions from my client, but don’t want them to see any tables or data that is not specific to their company. For example: Company A has 12 items. I have a view in a table that is specific to this company’s items. I have edited two fields: 1. Title and 2. Description I need to give them visibility to these fields, in addition to about 6 others that are reference only and static, but I also want to give them the ability to give feedback in a “Client Comments” field. A shareable URL does not allow them to add “Client Comments”. I think I could do it in a form, but am not sure how to filter it such that the form is ONLY Client A and the items/fields/values that are displayed (Title and Description) are ONLY for Client A.

I share different data with outside organizations. Should I setup a Base for each organization? If so, how would I track activity globally among all of the organizations in the same workspace?

I’m trying to create a formula that looks for either of 2 fields to be checked. Can someone tell me what I’m doing wrong? I can get it to work with either/or but trying to look up both, I’m stumped. Thank you! IF((Agreement =1) OR(IF{Umbrella Agreement}=1)),“ :smiling_face_with_sunglasses: ”