Other Questions

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 there is

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 price level that are billed monthly. The number

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 : why is the Notes column ignored? how can I change my M query to get all columns even if the first row was null? thank you very much

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?

when i have tried to open a table on airtable, it always show me just like this especially when it has run on Windows OS, nearly has not a chance to open it what can i do to make it runs normally again? (PS. with my assumption that i have tried, using hotspot make it runs faster than wifi router)

I represent a sports group that puts on outdoor lawn bowling tournaments. The number of participants range from 32 to 320. I want to track vaccination cards, serology reports and negative testing prior to the day of a tournament. I also need to track temperatures and symptoms the day of a tournament. There will be multiple users of the database.

I’m having trouble when expanding a linked record in the mobile app. My understanding is that expanding a linked record should open the top-most view of the linked table. When using Airtable on my laptop, this is the behavior I experience. However, when expanding a linked record in the mobile app, the view used on the fourth view down on the linked table. I can’t figure this out. Is this a bug? Anyone else experiencing this in the mobile app? Note: I have confirmed my mobile app is up to date. Also, my tables do not have any personal views; they are all public views. Thanks in advance for any assistance!

Is there anyway to use Automations to automate a scripting block script? If so, an example would be awesome! TIA

Hello, I need help with creating an if then that statement. I want to create a formula where if a record is created then the status should change to “needs to be scheduled”, if the scheduled checkbox is selected then the status needs to change to “needs to be submitted to publication”, if both check boxes are filled then it will change the status to “complete”

I’ve added a new collaborator and she can see our base and edit records. She cannot however create new records. Where I have a +, she has a lock. I’ve tried changing her permissions via the table’s drop down edit permissions menu. I’ve tried each option for her on the workspace, editor, creator etc. I’ve also tried manually selecting her via the “specific users” option on the table. Any tips on how to enable her to add records?

Hi, I have a list of workouts with exercises in each row and another sheet with list of all exercises with details about them (equipment, pictures, and …). I used relational to link exercises in workout sheet to exercises in a list of all exercises sheet but then when I do rollup or lookup for pictures and instructions of the exercises it just displays them blank. Why is this happening? Side question: when I do relational sometimes it duplicated the data. So if I relate row 1-5 in Sheet A to row 1-5 in Sheet B, all the values in that row in sheet B are duplicated. So rows in sheet be would go 1-5 and then 1-5 would be repeated again below it. 1-2-3-4-5-1-2-3-4-5. Why is this happening and how can I stop this? I’ve been working on this for a few days now and it’s driving me nuts.

Hey Community, I’m trying to create a formula to add 7 days to a {Date} and add the Last Modified time to the the end of the result. I am currently using this formula DATEADD({Date}, 7,‘day’) & DATETIME_FORMAT({Last Modified}, ‘h:mm’) but this is what I get back example: 2021-12-07T00:00:00.000Z6:35 I have also tried adding SET_TIMEZONE({Last Modified}, ‘America/Los_Angeles’ after the DateTime_Format but I am met with the same result. Would love some help please!