Ask the Community

Hello everyoneI'm NawafI have a long nested if statement that i used to use in excel but I can't figure out how to use it in airtable the idea is i have 3 columns first ( permit status ) second is ( remark ) when the conditions meet, I want the third column ( action ) to show as "action" or "no action" or "no action closed"(permit states) has only two terms closed or valid(remark) is different i want to find the word "renewed" or "to be" or "re-issue" or "on hold" "redesign"this is what i used to use in excel =IF(AND([@[Permit Status]]="Valid",[@Remark]="No need for renewal"),"no action",IF(AND([@[Permit Status]]="closed",[@Remark]="No need for renewal"),"no action closed",IF(AND([@[Permit Status]]="closed",[@Remark]=""),"need action",IF(AND([@[Permit Status]]="Valid",[@Remark]=""),"no action",IF(AND([@[Permit Status]]="Valid",[@Remark]="Renwd"),"no action",IF(AND([@[Permit Status]]="Valid",[@Remark]="Re-issued"),"no action",IF(AND(ISNUMBER(SEARCH("to be",[@Remark])),[@[Permi

Hi all, I'm trying to remove a deactivated User from my base with an automation. Has anyone managed to achieve this? 

Hi, Does someone else have problems getting webhook trigger from Hubspot ? Here is the response message that Airtable give to Hubspot:{"success": {"statusCode": 400},"fail": null} Wich apparently mean that things are not working properly.

Hello.Am trying to automate creation of document from airtable. The questions are in a lookup fieldBelow is the information i want to push to be created in a document and attached is my workflow.My problem is the out put is not correct.I will wish is the question to be created in the document and numbered correctly.How can i achieve this?Thank youThe outputthe flowget record from airtable 

Are swimlanes possible in the Kanban view? This would be a nice feature to have. I'm not seeing it. 

Hello ,I am trying to link a row to another row via an automation script , how can I get the url link to a cell because when I do a for(let  record of tableQuery.records) i can only get the record.id or record.name isn't their a way to get the record.urlLink ? Thanks for the help 

I am using the Airtable js package for nodejs and it is my first time. I have dynamic data that I would like to store in a table. Is there a way to send the request once by passing an array into the create method? I don't want to iterate the array and call the create method on each iteration. I'm sure there is a way to do it once, I must be missing something.const base = new Airtable({ apiKey: `${process.env.AIRTABLE_ACCESS_TOKEN}`}).base(`${process.env.AIRTABLE_BASEID}`); const tempOrderParticipantData = [...params?.participantData as participantDataAttributes[]]; const tempRecord: unknown[] = []; tempOrderParticipantData?.forEach((item, index)=>{ tempRecord?.push({ "Full Name": `${item?.participantNameInfo?.participantFirstName} ${item?.participantNameInfo?.participantLastName}`, "First Name": `${item?.participantNameInfo?.participantFirstName}`, "Last Name":`${item?.participantNameInfo?.participantLastName}`, "Phone": `${

Hello Community,I'm encountering an issue with the resource allocation timeline in Airtable, specifically when switch between the daily and weekly views for team utilization when people taking leaves.In the daily view, everything displays correctly; for example, team member Chanpory’s leaves on February 28 and March 11 are shown accurately.However, when switching to the weekly view, these leaves are not represented, what even worse, it incorrectly shows overutilization for Chanpory, despite his absence on these days.This issue is impacting our ability to manage and report on resource allocation effectively. Does anyone else experience this problem? Any suggestions on how to ensure that leaves are accounted for correctly in the weekly view to prevent it from showing overutilization?I appreciate any insights or advice you can offer!Cheers

Hi,I am trying to create an automation that will create a quarterly report for me every 3 months.How can I make a report be created every 3 months for each client?I'm using docsautomator so I tried this: https://imghostr.com/938e92_l5x but it didnt work  

Hey guys,I am looking for a way to link sets of dates together across different tables. I have a schedule table and a tasks table (tasks are nested under schedules), both have their own dates, I would like the tasks to move with the schedule they are linked to. I am using the predecessor field within those tables already for that functionality, but also want a way to link the tasks to the schedule. Let me know if anyone has any ideas on this one.Thanks!

Hi! I'm building an app with Bubble.io. The problem I'm facing now is that I need to create new records in my Airtable Base, from my Bubble app's UI. I do not have any problem to create new records, except when I need to populate a linked field. The new entry is created as expected, but the Linked field remains empty. Do you know how to process? Thanks a lot!

I found this formula in the community. However I want to include a timestamp aswell. Since {date 1}, {date 2}, {date 3} may occur on the same day. I tried adding a format specifier but it wont work... The formula sets the time to a default 12:00am instead of the actual time that is showing on the datefields.IF( OR({Date 1}, {Date 2}, {Date 3}), DATETIME_PARSE( MAX( IF({Date 1}, VALUE(DATETIME_FORMAT({Date 1}, 'YYYYMMDD'))), IF({Date 2}, VALUE(DATETIME_FORMAT({Date 2}, 'YYYYMMDD'))), IF({Date 3}, VALUE(DATETIME_FORMAT({Date 3}, 'YYYYMMDD'))) ), 'YYYYMMDD' ) ) 

Hi everyone,I need to upload Adobe Acrobat Documents to my base.  They vary in size between 155-175 KB. '"This file is smaller than the allowed size of 1 B"Why am I getting this message?  Does anyone have a workaround?Thank you for your time and wisdom.  Much appreciated!S 

Hi, i'm landing with airtable and so far loving it, but I'm not sure if scripts works like other environments...I have a table record with a lot of blank values at ID column because is an exportation from another ddbb and it exports fields with multiple values as a record for each value. Usually in other apps I make a script for this that get the variable when exists the ID value and replicate it at the next empty records ID until it finds a non-empty value and updates the variable, and so on.I made the script and don't seems to have any fail but when executing is not doing anything (also no error text):// Define the table and select all records let table = base.getTable("Dashboard"); let query = await table.selectRecordsAsync(); let records = query.records; // Initialize the lastref variable let lastref = null; for (let record of records) { let currentDefaultCode = record.getCellValue("default_code"); let currentDefaultCodeNexus1 = record.getCellValue("default_code_nexus1"); if (!c

Hi everyone, I have a situation and I am not sure what I should be focusing on first. There are a few levels where the problem may be coming from.I use Airtable in Chrome. As I move from cell to cell and view to view, I am often pressing a button on my Stream Deck that pastes small amounts of text for me. However, recently if I have expanded a long-text Airtable cell (so the whole cell pops up for easier reading), if I hit the button on my stream deck it closes the cell and does not paste it. This is not an issue, however, if I double-click within the cell and work on it without expanding it to the larger view. This is also not an issue with general copying/pasting with a keyboard. This issue comes and goes. I am trying to figure out where I should *start* with all this. Where do you think?- Chrome- Airtable- Stream Deck hardware- The app within Stream deck that "pastes"Hopefully the question makes sense. If you have any ideas on what could be happening I'd totally appreciate them

How do I automate that a record gets created/populated when certain conditions are met. For example, When the value of Food is 'apple', and the Color is 'green', Attitude is 'happy'. Thanks for your help. 

Probably no way of doing this without an Automation right?I'd just like to have an image for my records based on a single select field. Essentially a Single Select field for images! I want to be able to assign a Logo for each record. Then on an interface, we can see Red Team or Blue Team logos distictively.My formula solution for this would be to host the image URLs somewhere and use a SWITCH() formula to find the URL. I don't know how to get it from the URL to the Attachment field.I can do this through automations but that seems over-engineered. Since I already have the teams in a single select field, all the data is there and I don't need to overcomplicate my base. The want for a logo is purely cosmetic haha.

Hi!     I successfully synced JIRA to AirTable, with all fields appearing in AirTable correctly.     But, there is an exception:     I have a "Cascading Field" in JIRA called "Story Type", each option in the first field opens a new list in the second field.     The first field appears correctly in AirTable, but the second one no. The print below shows it better.      Is there a way to make the second field appears in AirTable?Thank you all in advance.Best regards.Nelson.

I receive a due date and have to calculate backward to identify different milestones in our projects. What formula(s) do I need to use to make this work? I've attached a picture of what I'm trying to do.  Thanks in advance for the help!

I'm watching the "introduction to interface designer" webinar on-demand but in the recording there is no "related content" section for me to find the template/base used in the webinar. Tried searching for it as well, but couldn't find it anywhere. Anyone got a link to that base? It's called Demo: Design Project Tracker.

I have a base with information about students in a music program, including their birthdates (MM/DD/YYYY). I have a formula that calculates their age as of today:DATETIME_DIFF(TODAY(), {Birthdate}, 'years') and a formula that calculates the number of days to their next birthday:IF({Days from today} < 0, {Days from today} + 365, {Days from today}) I want to create a field that will tell me how old they will be on their next birthday. Is it as simple as adding 1 to the formula that calculates their age as of today? Thanks-Jen  

How can Sort list of Records by the order they were created in both. Would like to know how I can do them both ascending and descendingI also don't have any created time field I can't create that since I'm using the API And as far as I know it does not support creating formulas with the API So is there any other way to do this without using fields

I want to use AirTable so that users can login and access their test results and marks. You could call it a dashboard or customer portal site. So, one user’s results can’t be seen by another, this is why I need login or user accounts. I will be using AirTable forms (maybe Typeform) and AirTable sheets to enter the user’s test results. I have looked at various third party sites that build websites using AirTable data. However, I am not sure if they will be able to do what I need to do. I found one that looks like it could softr.io - but it is very expensive in my opinion. I know I could use a dedicated Dashboard or portal software like SuiteDash, but I am trying to automate as much as possible. I already have a SuiteDash account. I am happy to spend some money on a paid SaaS product. Does anyone have any suggestions or possible solutions? Thank you.

I’m really excited about the new interface designer features. Airtable has given us the tools to build functional apps without getting people too deep into the database side. Unfortunately I can’t quite fully embrace it yet – it seems like the interfaces don’t work at all on iPhones. Moreover the degradation is pretty un-graceful, users just get a message to login or use the app with little or no explanation of what went wrong and how they could fix it. Our folks – especially some key stakeholders – are on iPhones more than any other platform, making this an important thing to solve for here. Does anyone have any ideas about how to deal with this? Does anyone know what Airtable’s roadmap is? Would love to leverage the features if I can figure out how to manage this challenge.

Hi everyone. I am currently trying to create a checklist for a theatre production so we always remember to load everything in the van. However, although this works perfectly when I am on the computer version, I can tick the items as they are loaded, when I transfer to the mobile app it seems to become a laborious task because when I tick on the items, rather than check the item it takes me to the individual record. Does any one know if it is possible to just check and uncheck items in the mobile version? Thanks