Ask the Community

Hello. I am having issue with my formula returning errors instead of 0. I tried using adding If to the beginning of the formula and also the ISERROR but nothing is working the way I need it to. My formula is returning 1 if Purchase Close Date was last month. Below is what the formula currently looks like. Thanks in advance for any help! DATETIME_FORMAT({Purchase Close Date}, “YYYY-MM”) = DATETIME_FORMAT(DATEADD(NOW(), “month”, -1), “YYYY-MM”)

One of my tables is “Accounts” and it has gotten really wide (40+ fields) and growing. (Name, ID, Address Complete, Address1, Address2, City, State, Zip, Phone, Fax, Comments, Attachments, COD status, Credit Terms, Tax Exempt, Tax Exempt Number…) I’ve backed up the table and started playing with linking sub-sets of account information in multiple tables (a 2nd table for Address information, a 2nd table for Credit/Billing information, a 2nd table for interests/category information… so each table can be limited to 15 or fewer fields) What are the pros and cons of wide tables? The way I see it, going wide is: Pros: Everything can be entered in one record (I don’t need to go to multiple tables and re-type the account name to continue entering information) No confusion over whether the additional records have already been made in the additional tables Can use custom views to make the data more visually manageable Cons: Googling DB vs Spreadsheet makes me think that DB’s are supposed to

Hi there,I'm trying to find out if there's a way to share a view link for an entire workspace (i.e., not just a base). Thank you.

Interface designer is nice but on mobile it’s quite pointless and I hope I’m mmissing something. Wouldn’t want to use a 3rd party for building interfaces. the list views show a random number of fields see sceenshot below. How can this be fixed? Also, to add a record - you need to ba an editor. So bad 😞 I have loads of people only doing that. Submitting records. Now I must make a workaround - because through a form it works  

Hello all,Within a Project Management table and related interface, I have a collaborator field ("Watchers") which is intended to allow users to receive alerts whenever a project they are "watching" is updated.I do not want to show everyone who is watching - I would like only to display information about whether the signed-in user is watching the project, so people don't feel shy about watching projects.I am stumped though, about how to display a "Yes"/"No" answer to the question, does the signed-in user appear in the collaborator list field. Any tips? 

I have built an automation and it works very well. When I open a new row in the "Projects" table, it automatically adds the necessary tasks in the "Tasks" table. It also fills in the default values. Great. Unfortunately, I cannot insert a default value from the "Projects" table as a lookup. I can select it, but nothing happens. Does anyone have a tip?When I do the preview, the value appears, but only the one already created. In my case "test".Or is this only possible via the "Create child linked records" script?    

Hi,I have a series of lookup fields that return multiple dates.  I'd like to combine those fields into one, listing all of the dates returned in M/D/YYYY.  I've messed with datetime_parse and format with a concatenate, but the formatting is either not M/D/YYYY or it only returns the first date listed in a series in the lookup field.Thanks for any help!

I have an Excel formula I'd like to replicate in Airtable.This formula converts different currencies into GBP.Excel:=IF(M2+(N2/1.25)+(O2/1.2)+(P2/8.75)=0,"",M2+(N2/1.25)+(O2/1.2)+(P2/8.75))Key:£ GBP$ USD€ EUR¥ CNYM2N2O2P2How would I go about it? 

As you can see in the attached file, I want to Create a link between anchor campaigns and other campaigns from the same column. Anchor campaigns are the “major” campaigns happening throughout the year and all other campaign types are “subcampaigns”.  I want to link all the subcampaigns according to their start and end date with the Major Anchor campaigns. Please let me know how I can achieve this?

Hi there,I have this automation I have built and it looks right to me and passes the test. The test data populates in the destination table. But when I manually enter data into the source table nothing happens.Here is the automation: This is the destination table. The Article Number "F25NSECVR" was populated when I ran the test.This is the source table. I manually entered "F25TEST" and nothing happened.   

This has been discussed multiple times without one fortified solution. Thus, I must request help again - a file from Google Drive is being uploaded to Airtable via Integromat, but Airtable is automatically deleting the file after it is uploaded (the preview of the file is not proper either for the few seconds it is there) There is nothing wrong with the process as it worked twice, with the files getting properly attached. Without any change, the problem reappears, and I do not have a solution.

Curious if this has happened to anyone else? ... and why?  In one table, filter options now require that I click apply for them to take effect. See pic below. This is new. This table/view is one of our most regularly viewed tables and never required that. Changes to the sheet would happen live vs requiring clicking a button. The weird thing is too, on other tables, it's not required. We can still edit the filter options and the changes happen live. Curious what might have changed and if I can change it back?  

I have this actionable message automation that doesn't seem to work.  I can see it failed and the recipient was not filled out. A typical non-actionable Slack automation seems to work fine and I can see a recipient.Is there something I am missing?  

Hello Guys! Pretty new in airtable. I have 2 tables, on the first table I added a [Link to another record] field that follows a condition to only allow values that matches a value from my first table. I've succesfully done this in a way that it only allows me to pull the values that I want. Now my question is, is it possible to automatically pull in those values? whenever (1) New records are added to Table 1 & (2) New records are added to Table 2 (Because currently you need to manually select them)

Let’s say I want to assign the same item to two categories in a multiple select field. And I am grouping my view by that field. For instance maybe I am creating a list of vendors and what we buy from them, so for HP I want to select “computers” and “printers” from my multiple select field. For Xerox I would only select “printers”. I would now want my grouped view to look something like this: Computers HP Printers HP Xerox But instead what Air Table understandably does is this: Computers; Printers HP Printers Xerox Is there a way to create the grouping I want where HP would be listed twice, once under each category, as in my first example? Hopefully I’ve described my question in a way that makes sense. Thanks

Hi, we are configuring a new OAuth App, and would like to configure multiple redirect URLs.Is that supported? Can we provide multiple URLs? Thanks

Hi,I'm trying to import duration data from a CSV (e.g., "2:52:32" meaning 2 hours, 52 min, 32 sec). The Airtable  Duration field is set up correctly (I think?) with the h:mm:ss time format selected. I want to keep it as a duration field so I can calculate sums, avgs, etc.When I import the data, the duration is not aligned correctly. For example, the original duration in the CSV is "23:51:52," but when it's imported, the duration is showing as "0:23."What can I do to correct this? Thank you so much.

Hi guys!On one table I'm looking at Set Up Account details, and on the other I'm looking at Account Performance. The first pulls data from Typeform, the second from our internal system. To be able to tell how well the account is doing, I need the context of what stage of 'set up' the account is in, so I need the Status to dynamically update Performance, when it's changed in Set Up. I've tried to do a Linked Field, but it doesn't seem to be accurate, and now it's not working at all. I'm not sure whether that's the best solution? So I tried to automate it. The trigger stage is successful (attached), but then the Update Records stage fails with 'Received Invalid Inputs'. I'm matching the records based on our internal ID number that we update the fields with (ave_id). Any help or ideas gratefully received! Thank you. 

Is there a way to format text such as bold, italic, list, etc.?The most I can seem to do is add a line break by pressing SHIFT+ENTER.

Hey all, not sure if this should go in the development section or not. But is there any way to remove the "Add Record" & "Add More" buttons from the bottom of the base screen?

We have a single Airtable group calendar for 15 staff members.  When a staff member receives a calendar invite from a third party, when they accept, it adds it to a Googe Calendar. I know I could do a full integration but for several reasons, we do not want ALL entries to go to our Airtable calendar.We are looking for the easiest way to go to that Google calendar entry and "do something" to get it to populate into our Airtable Calendar.  Thoughts?

I am simply trying to connect to the information from one table to another table automatically using automation. Every time I try it it comes up with errors. I have tried using the record id formula to connect them (they dont match between tables). I have used the primary id (email) and it wont work. I have tried the Link to Another Record field. Even in the error I am seeing both emails, so it seems like it should work. What am I doing wrong? 

I am trying to take the word count of a book (ex: 100,000 words)divide that by 9,300 (which is how many words an average narrator can read per hour)to come out with the actual time in HH:MM format. This is the formula I have currently and how it turns out. .   What formula would I use to divide the word count by 9300 to come out with a HH:MM?

Hi all, is there a way to integrate QuickBooks Online Plus with my Airtable workspace and bases? If there isnt already an existing integration, how do you get around it to sync with each other?

I am trying to integrate Airtable with Jira, pulling data from Jira to Airtable. My issue is that I only see a few Jiar fields (Issue Key, Status, Assignee, Summary, Created Date, Due Date, Description, URL, Priority and Labels) when adding an Jiar cloud app in Airtable. But there are about 15 fields of Jiar task, I am wondering how can I pull all the fields from Jiar to Airtable?