Other Questions

I have some tables that has many records and I want to have another table that will be called Macro View and its going to include all the counts of each table. For example I have one table that is called “Peoples” and it has 50 records there, then I have another table that is called “Animals” and it has 25 records there, then I have another table that is called “Cars” and it has 10 records there. Now what I want to achieve is that in this MacroView to have the sum of these records like example below: People : 50 Animals : 25 Cars : 10

Hello Friends! I am using Airtable for project management. I want to make sure we have not scheduled more than 6-8hrs of tasks per day for team members/resources. Is there a way to create a calendar view that would show the number of hours of work assigned to each team member? I’m guessing I might need a Calendar Table and use linked records, but that would destroy the ability to use the Gantt chart. Any suggestion would be greatly appreciated! Thank you! Paul Warren

I’m using AirTable as an inventory manager instead of Excel, but when I output more products than what’s on my inventory, my inventory marks as negative. What I want is that in the output row, I always have a limit according to my stock, so when I try to output more units than I have, it mark an error or only corrects to my maximum possible. The issue is that the person that register the outputs not always knows the available stock, so if he outputs 100 units of “x” and there are only 50 on stock, he won’t notice that the inventory is in negative.

hi. i wanna do a simple array of objects in airtable like: [{option: “abc123”, name: “abcabcd”, text: “lorem ipsum”}] they do it here for example when you choose attachment field but i wanna do it with a simple ( item=value ) in array

When I drop pictures into the attachment field, those that were taken in portrait orientation automatically turn themselves to landscape. Do you know how to stop this auto-orientation from happening?

I’m attempting to organize a huge number of contacts according to their relationship to our college (Faculty, Staff, Student, etc), and then grouping the contact list by the relationship field. The only problem is that there are contacts who have multiple relationships to the college; a number of people are listed as both faculty and department directors. When the table is grouped by relationship, it by default delegates any records with multiple group tags into a unique “group” including all those relationship tags. What I’m looking for is to have one group for each relationship tag, with multi-group records appearing in both relevant groups. I know there must be a way to do this, but I haven’t been able to figure it out. Help!

I work as a financial planner and I’m absolutely loving the flexibility of Air Table. One thing, however, I’m struggling with is that I want the ability to link a contact record in the contacts table to more than 1 household in the households table and specify what the role of the contact is for that particular household. What’s the best way of setting this up? I’d like the ability to have a Household View so that it lists all of the contact records associated with that household and what their role is in that household. Currently, I have a linked record between HOUSEHOLDS and CONTACTS and I have a “Household Role” field in the contacts record. But I’m realizing this won’t work because it will show the same role for both households which may not be the case. For example, a contact might be “Primary Client” in one household and a “Power of Attorney” for another household. Any ideas/suggestions how best to accomplish something like this? I’ve created a “Household

Hi, I’m looking for a way to streamline entering the same data in Airtable in a few different places. I enter due dates for an entire project, but we have SMEs that enter some of the same due dates in another tab for when each individual channel will Go-live. Is there a way to link individual task due dates to another tab’s individual tasks?

I have a table with a column titled Status. It contains four statuses New, Answered, Rollover, Completed. I want to capture the result when a Status changes, for example, from New to Answered, from New to Rollover, etc. I also want to report it compactly. Further, I want to capture and count the Status changes in a Pivot Table or similar. I have looked at nested IF/SWITCH as well as Automation timestamp. But being new to Airtable I am unsure which is simplest and most efficient. The Automation solution seems like many columns and not suited to a Pivot Table. Any help appreciated.

Hello Together I have the following table design: Column “Invoice date” - Type “Date” - Example value: 2021-12-30 Column “Customer code” - Type “Name” - Example value “awc”. Now I want to compose an invoice number from these two fields using a formula. Invoice date & “_” & {abbreviation} My output will look like this: 2021-12-30T00:00:00.000Z_awc But how the output should look like: 211230_awc How can I solve this cleanly using a formula?

Hello dear community. First time asking a question and learning the basics of scripting. One part of my script asks the user for a value like this: let SessionPrice = await input.textAsync (‘Input price per coaching session’); Then I’m trying to insert that value on a currency field with: Let CreateField = await MainTable.createRecordsAsync([{Fields:{“UnitPrice”: SessionPrice}]); And I get the error: j: Can’t create records: invalid cell value for field ‘UnitPrc’. Cell value has invalid format: must be a number I guess its because its a ‘text’ string and I don’t know how to convert it or make it a ‘currency’. In advances I’ll appreciate your help. Thanks…

Hello, Kindly assist with formula for the following lease validity scenario. If today()) is before {lease start date} it is “In Active” If however it is after {Lease start Date} and before {Lease termination Date} It is "Active " Otherwise it is “Expired” Regards Arnold

When I copy and paste a column of data from a sheet in Numbers into AirTable it is pasting invisible tab characters on either side. I can’t see these in the cell but they show up further down the line when using the text in formulas to create social media posts from the data. Is there any way to automatically remove these invisible characters?

Hello, I am new to API and node.js and I was trying to use filterbyformula for checking if an passcode (from airtable) matches with a local variable (inside the javascript file). But I am not understanding why I am getting value as undefined. This is the table snip. // Airtable variables var Airtable = require('airtable'); var userRecord = new Airtable({apiKey: "xxxxxxxxxx"}).base("xxxxxxxx"); var Users = userRecord("Users"); var Local_passcode = '123346'; async function SendOtp() { const records = await Users.select({filterByFormula: `{Passcode} = "${Local_passcode}"`}).firstPage(function(err,records) { if(err) { console.log(err); return; } return records[0] }) console.log(records); } SendOtp(); Can anyone help me on this? Thanks in advance

New to air table and absolutely loving it so far. I usually use excel so this is an excel vs Air Table question. If I have a table calculating lodging costs, check in and out dates, taxes… (I have done that table) but I need a results page, can I do this in Air table? In excel I would just go outside of my table and put my results : example Hotel A total cost no tax, total tax, totall cost with tax, Hotel B… same results. Can I do this in airtable? if yes, can someone guide me towards an article that woudl explain? thank you!

Can I use integromat to change the filter settings of one particular view? I use different views to trigger certain integromat scenarios and it would be great to be able to trigger or turn off scenarios via integromat changing the filer settings of an individual view. Thank you for your wisdom, friends.

Hi We have currently hit the 50,000 Automation limit on our Airtable at a critical time for out business. We have been unable to function for 2 days due to this and have not been able to get any response from Airtable Help or Sales regarding this. Just hoping someone can contact us with options to buy more automations to get use through? Please respond ASAP if you can help Regards

Hola, tenemos una lista donde varias veces el texto se muestra diferente para dos usuarios diferentes. No sabíamos que esto podía ocurrir. Por ejemplo, la palabra “Ale” la cambia automáticamente por “Cerveza inglesa” para uno de nosotros. Y así con algunas palabras más. ¿Cómo puedo solucionar este problema?

Hello, I have several of my O365 Exchange Outlook email accounts setup within my Airtable account’s “Connected Accounts” area. These connected email accounts are utilized in various Airtable automations via the “Send Outlook Email” action. Generally, these accounts work in a stable fashion. However, from time to time (with no apparent rhyme or reason that I can grasp), I’ll get an automation failure wherein when I look at the automation run log, the reason for the failure is (paraphrasing) “Your connection has expired, please reconnect your email account”. Of course, I perform the reconnect and everything works fine again. Does anyone know why this happens? I reached out to AT support and they said to reach out to my Microsoft Exchange tenant support team. Microsoft support says reach out to Airtable. So I’m stuck. Obviously, I don’t want my automations randomly stopping because a connected outlook account has expired without my knowledge. At the very least, I’d like to think

Hi all, For our organization we want to be able to generate invoices for internal use based on databases in Airtabel. The invoicing of our services consists of two layers in which customer users are placed. The users have a hierarchical relationship with each other. There are main users under which one or more sub-users are placed. Each main user receives their own invoice. There are about 300 main users and about 3500 sub-users. The price agreements are determined at the main user and sub-user level. The price agreements differentiate at main user level and sub-user level. The price agreements relate to four different types of costs: Costs for a fixed number of services at a fixed price that are billed annually Costs for a variable number of services with a fixed price that are billed annually Costs for a variable number of services with a fixed price level that are billed monthly Costs for a variable number of services with a variable

Question: How can I capture how long a record has spent in a Single Select field option throughout its lifecycle? Field Information: Field Type: Single Select Field Name: Status Field Option: “Awaiting Information” Context: Record enters table (Status automatically changes to “In Progress” through automation). User changes Status to “Awaiting Information” when appropriate. When user is finished, they change the Status to “Complete”. Goal: I want to see how long we are waiting on other people for (on average) when fulfilling these requests. I wasn’t sure if this was a formula or automation question. Thanks!

hello, when i try to connect to this table : with this query : 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), the result is :

Hi, What note taking app are you using to simply take notes or wiki (Markdown ?) into AirTable ? I have in mind Notable or Evernote where the UI is dedicated to notes but would be stored in AirTable.

When i try to create an app, the scripting editor is not available, when i click to edit the app, it asks me to connect a local app through the CLI. This is not in line with any of the guides i have seen online. I do not want to setup a loocal editing environment, how can i edit code right in the web app?