Other Questions

Has anyone successfully integrated Airtable with D365, where any edits or updates to the records in Airtable successfully updates to D365? I’ve created the integration and initial tests work fine for first-time inserts, but when edits are made in Airtable, the record in D365 is not updated - rather - a new record is created with the updated info. If you know of a solve, would be great if you could share. Thanks in advance

I would like to be able to have a list that leads into a list, I cant figure this one out Single select one would be Audio Gear and Video Gear, If I select audio gear, in the next single select drop down I would only like the Handheld mic, Lav and IFB options to be visible and nothing form the video gear category. Audio Gear - Handheld Mic - Lav - IFB Video Gear Switcher SDI Converter Monitor If its possible without creating a hundred new tables that would be great

I cannot get any of the barcdoes fonts in airtable ot work with my scanner (Inateck BCST-20) and the manufacturere is assuring me, after sending them a picture of the airtable barcode, they assure me that the code wont work at all. both code 39 and 128 , the fonts for these are a hoax. someone proove me wrong. The scanner manufacturer has been very helpful to proove to me that the airtbale fonts simply dont work. so what gives? Smartphone apps dont recognise any of them either. what is it im not getting? isnt this suppsoed to be able to print out a barcode?

I am responsible for billing regular users of our Village Hall on a monthly basis. Currently, I export the data from the billing system, reduce the number of columns to the pertinent, sort by Hirer and then by date and then subtotal booking fee by Hirer and I end up with a sheet like this: I have spent 3 or 4 days now trying to replicate this in Airtable, with no joy whatsoever. I have linked tables and tried to roll up, but I cannot figure out how to roll up for each hirer. The best I have managed is to group by hirer and manually copy the summarised price total to another sheet.

I’m evaluating using Airtable as a notes repository for my consultancy. We take a TON of notes (every meeting, every standup, every one-off conversation with more than two participants…). Some of these notes are for internal staff only, and some need to be shared with the client. We’re currently managing this information via Google Docs, but it’s quickly breaking down as notes docs proliferate. Airtable seems to provide a good solution in that I can model notes docs as records in a single database, and then provide filtered views of that database to specific clients based on the values of fields set on each record. That said, I’m running into a few blockers with the ergonomics of writing and viewing notes in the Airtable UI that I’m hoping to solve via integration. Here’s my ideal solution: Take notes in a dedicated documentation app (something like Dropbox Paper) The markdown created by the documentation app is automatically inserted into a new records in an Airtable database When I

I recently installed airtable on a Samsung galaxy s4 and created a simple table with just a few records of data. Right after that the phone battery drained very quick, it lasted less then 50% of the normal time. After I uninstalled airtable, with no other change to the phone, the battery use was back to normal. Did anyone experience this? I can’t find any settings in airtable to limit background activities. But I don’t think there even should be, or?

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! Count is number of jobs completed in that category.

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 couldn’t figure out how t

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(“https://api.airtable.com”, [RelativePath="v0/"&BASE_ID&"/"&TABLE_ID&"?api_key="&API_KEY&"&offset="&Last_Key&""])), Counter = [Counter]+1 ], each [WebCall] ),1), #“Converted to Table” = Tabl

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. Can you help me please ? Thank’s a lot, Matthieu

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).