Other Questions

Hello everyone! I need to modify a formula that I have because I want to calculate a result in column A when B is greater than C AND also if B is blank. This is the formula I’m currently using and it needs modification: IF({DeStaging Date}<{Monthly Rental Fee Renewal Date},BLANK(),DATEADD({Staging Date},46,‘days’))

Hello! I am using Airtable for our workflow and project forecasting. We have a view that calculates the time in which it took to complete all jobs in the last 45 days, grouped by the separate categories each of those jobs fell under (see image below). I want to use the Avg. amount of time (calculated in weeks) as a figure in a formula to create the installation date of a job in that same category sold today. Is there a way to do this? I have attempted the separate table, rollup field solution, however, the problem is is that the data being calculated by this view is dynamic. Jobs are added (as they are completed) throughout the day and some jobs that age out of the 45 day range that this table is calculating fall off. The rollup field (in my experience) only grabs the jobs that are done at the time of creation of the rollup field. Anybody else been able to do this? Thank you in advance!

Dear all, I wish to find out what programming language is used by extension developers. Is it the same language used in Airtable scripting — Javascript ? How powerful is that programming language? Thank you in advance. Martin

Hola a todos! Tengo una tabla Productos que contiene un campo precio en dólares y tengo otra tabla tipo de cambio en la que actualizo todos los días el tipo de cambio del dolar vs. pesos mexicanos. Necesito calcular todos los días el precio de cada producto con el tipo de cambio del día. Alguna sugerencia para hacer ese cálculo de la manera rápida. No encuentro como vincular la el tipo de cambio del día a cada precio en la tabla de Productos. :thinking:

Hi folks, I’m trying to maintain a uniform look in all of my tables, and one way I see to do that is to capitalize every character in every field. Is there a way to do this? Thanks in advance, Shawn

i have two tables that are linked. People and Service. Many different People Records can be linked to one Service Record. Additionally, one People Record can be linked to more than one Service Record. Service Records include date fields- Start & End. i would like to display a list of all of the People Records who are linked to any Service Records that fall within a specific date range. i want the list to show each People Record individually, with some key information from both their People Record and the associated Service Record. (e.g. from People Record- name, cell phone, emergency contact; from Service Record- country, start date, end date). i tried creating a junction table, but when i used the fancy junction table script i realized that was a big mistake. i also tried building an automation that triggers when a Service Record enters a view (filtered for the date range i’m aiming at), it creates a record in a different table and lists the people. But i c

Hello! I’m having trouble with a formula, DATEADD({date}, 2, ‘days’) works perfectly but I need to add time as well specifically. For example, a record was created on Saturday at 8pm, the formula should logged a date on Monday at exactly 7am. We have team A who creates record during weekends and those records are sometimes being created in weekends. Team B will only be able to check those records during Monday to Friday and their scores/metrics are being affected in our report. We wanted to create an automatic field that will logged those records on weekends to Monday at 7am. I think a formula won’t work on this issue and scripting would be better but I’m not good at coding.

Hi! Is anyone interested or knows how to make visualisations (bar, line etc) from a single record or a subset of records/linked records but not the whole table. Cheers,

I have a linked record table that stores dates for publications. The dates are unique and form the primary field. When a value is inserted in a linked record field in the main table they are treated as text, which throws out the sorting. It’s there any way to resolve this?

We have a data and we want to store them in AWS relational database, and the question can we use Airtable to manipulate the data which in AWS database?

I am preparing to switch our Integromat account to Make. I have run the conversion on a smaller, non production account without any issues. As we prepare to convert the production account is there anything that this group has encountered, specific to Airtable that caused issues when converting over? Did you manually convert or did you use the upgrade tool?

Greetings Airtable community! I am hoping for some insight/guidance/problem-solving on an issue I’m having with notifications. I received an email indicating a colleague had mentioned me in a comment on a specific record in a base we share. And when I click on the notifications icon in the base, I also see that she mentioned me. However, when I go to the specific record I cannot see her comment anywhere. What might be causing this disconnect? I am attaching screen grabs for reference/context. The first shows the record itself, which should have the comment from my colleague Jeniene showing on the right, but does not. The second image shows the email I received, and the third is a screen grab of the notification pane in Airtable. Thank you very much!

Greetings, Airtable Community! All the tables and views in my base are locked, “…to prevent anyone from editing the view configuration until it is unlocked by a collaborator with creator permissions.” I have two collaborators at the Editor level. With everything locked, are they able to add options to single and multi select fields? Or do I need to edit permissions at the field level? Thank you!

Hi there, I’m trying to sync Airtable base/view with an Microsoft Excel via the M query template bellow and it almost return what I want. The only problem is that it don’t include the empty cells in the second record even if the first record in the table is completely filled out. How can I modify the Query to allow for empty cells in a table? let Pagination = List.Skip(List.Generate( () => [Last_Key = “init”, Counter=0], each [Last_Key] <> null, each [ Last_Key = try if [Counter]<1 then “” else [WebCall][Value][offset] otherwise null, WebCall = try if [Counter]<1 then Json.Document(Web.Contents(“https://api.airtable.com”, [RelativePath="v0/"&BASE_ID&"/"&TABLE_ID&"?api_key="&API_KEY&""])) else Json.Document(Web.Contents(“

I like the comment functionality and it works great for tracking comments for 1 row BUT when I have data where I need to insert a comment across N rows it is quite tedious to open each row individually and add it in. How do I add the same comment to multiple rows at the same time? I am looking for a right click and comment option or similar.

As in the title, I’ve got a Timeline and Gantt view which is showing the current date as a blue line on the chart. However, this blue line is a day behind my actual date (I’m in Australia). Does anyone know how I can make the current date line accurately display my actual timezone (AEST is UTC + 10)?

Hi Community, I need your help ! I have a webshop. All my product and collection are sync from Shopify to Airtable. My need : i want a view by collection and i want to see all the product in the collection. Actually i have 2 views : First : One column with a list a product and one column with all the collection by line. Second view : I have the collection on the first column and all the product associate in one line on column 2 My need : i want to see my product by collection (group by) For exemple : Collection A : Product A Product B Product C Collection B Product A Product B Knowing that there may be the same product in several collections. C

Hello Community, I need your help. Some postal code is delivery in 24h and the other in 48h. I need to create a formula. If the postal code (on the column B) start by 94,92,91…, write 24h, if not write 48h. Can you help me please ? Thank’s, Matthieu

Any plans to incorporate Interfaces into Mobile App? That would seem to be the best use for the app - access to streamlined UI and Dashboards. Also, would love to see them accessible through Airbase Top Banner Strip… like Bookmarks in a Web Browser maybe or assignable to tabs like tables are currently present or in a separate section on the left hand views menu Basically, any way to save clicks. Today they feel somewhat remote and bolted on (I get that it’s Beta functionality at the moment).

I’m new to Airtable Thanks in Advance

I tried to copy a linked record cell down, but it returned a wong record. I have a table of events, the name of the event (1st column of the table) will be reused every 3 years (same name on a different date). I have another table of event attendance. I tried to copy an event (a linked record) to other rows which are different attendees of the same event. The record returned in other rows are not the one I copied, it is another event with the same name, but it was 3 years ago. Video Capture for reference I copied the event down, but it shows a wrong date. The date is a lookup of the event. Does copying linked record processed with the recordID or the first column? Is it a bug or I have done it wrong? Thanks for your help!

Hi Airtable community :raised_hands: My name is Leandro, I am a freelance software developer turned into entrepreneur and my main focus has been building small tools to integrate different services, for example Notion2Sheets and Packs4Coda. I am starting to dig into Airtable and the first tool I built is the Airtable Pack for Coda that you can use to sync your records with Coda, trigger webhooks with a button and also create, update and delete records with actions! Expect to have me around the community to help with questions around the API and other tools :slightly_smiling_face: Happy to answer questions!

Hello, I am trying to create reports via Power BI using the data I have on my Airtable database. I followed the tutorial on the airtable website (https://support.airtable.com/hc/en-us/articles/4403440453015-Sending-Airtable-data-to-Microsoft-Power-BI-Power-Query) to create the link between the two tools but I get an error message, as you can see below. Translated into English : Expression.Error: Sorry… We could not convert the null value to a Record type. Details: Value= Type=[Type] Do you know how I can correct this error message? Thanks a lot!

I have a linked field from one table to another. on the table itself I sort them in order of date, but when I click into the linked field they dont seem to be in any order. can these be re-ordered automatically?

Hi all, I have a team of people who need to import data into airtable. I dont want them to actually go into airtable and import themselves. An ideal example would be, the user creates a CSV or XLS doc, saves it to a specific place, then airtable sucks it up and imports as new rows into a specific table… Any suggestions or thoughts on this? Thanks!