Ask the Community

Hi all, newbie here - is there a way to create multiple columns in one go from a list of column title headers I have as a list? I have 60 + columns and have written the Column names down as a list (which can be also as rows in one column) and want to create all the columns in one go rather than one by one as it is time-consuming (all the columns are of the same type - text) . Thanks

On the Pro Plan.I am using a simple automation to send emails to static addresses.  The process is functioning well and emails are successfully sent to any address correctly entered into the To: field of the automation.  However, there is one exception.  The process will not send to one specific email address (sales@xxxxx.com).  No email is ever received.  It does not go to the Junk box: Airtable automation history says the message was sent.  This is particularly odd because this is the email address used as the login for the whole account!  It is happening in several different automations.  In the attached screenshot the email to diane@xxxx.com was received.  There is no sign of the one going to sales@xxxx.com.  The

I have an updates table with two forms.  One form is for instructors to upload their lesson plan to the main program table.  The other form is for program managers to make changes to records in that same main table.I have two different forms, with separate pre-fill form urls.  Screenshots are below.Whenever an instructor uses their upload form to submit the lesson plan, the link for program managers breaks.  Why is this happening?Thanks in advance.  

I have a table that collects the likes of my products. Here the corresponding product is created with a linked record. Unfortunately, in the table of products the reciprocal links does not work and I can not retrieve the entry from the other table. Why does it not work? (i have done this many times and it has always worked)

Hi!I am new to airtable so I am looking for some help. I am trying to create a database/input form for data that will be loaded into powerBI.The goal is to analyze revenue streams in PowerBI. Each revenue stream has a set of fields, among them are StreamID (Unique), report date, department, revenue type and $ sum. For each revenue stream I want to be able to allocate a percentage of the sum to the brokers in the company. The number of brokers per project varies.  What I am wondering is how I can create multiple key value pairs for each revenue record in my database? I currently have two ideas for how it could be solved:1. Putting an allocations field in the revenuestreams table that contains multiple key-value pairs, i.e.:StreamID(many fields)Alloc

Hi Community,May I ask is it possible to make airtable connect to Navision via API?Also is it possible for Airtable thru API to tabulate forms in Navision simulataneously?thank you! 

Hi Airtable community, Looking for some help with setting up a basic CRM. Context: This company runs multiple programs. 1 person can sign up to multiple programs Want to create 2 tables: Table 1: Sign-up forms: All sign-up form data sits here, there will be multiple rows per person in this table. Table 2: CRM: This table has one row per person. Each row/record/person links to that person’s forms in the sign-up form table. I have created a quick Loom video to explain

Hi everyone,I'm working in a table in which each item has two potential "availability" dates. Each item might have an availability date "A" and an availability date "B", but they will all have an availability date "B". I'm trying to set due dates for each item based on a few variables. What I need is a formula that compares availability dates A and B, and then gives me a due date that is either 60 days out or 5 days out. If availability date A is before date B or 55 days or less after date B, I need the due date to be based on date A and to be 60 days before date A. If date A is more than 55 days after date B or is empty, I need a formula that gives me a due date based on date B and one that is 5 days before date B. In the midst of all of that, I need a formula that won't give me weekends as a due date. Does anyone know if this is possible?

Hi guys,I currently have the below in a grid view.I would like to have a formula in the "Timeframe Status" column which will do the following:1. Check whether text has been added to the "RFI Resolution" field.2. If the "RFI Resolution" field is not empty, then check the hours between the "Date Created" field and the "Due by" field. If this is less than 48 hours, then return the text "Within time". If it is equal to or greater than 48 hours, then return the text "Past due". I would like the hours to be shown decimal 0.003. If the "RFI Resolution" field is empty, then return the text "Ongoing". Again, I would like the hours to be shown decimal 0.00Thanks

Current Formula: DATETIME_DIFF({End Time},{Start Time},'hours') But if I have a "Day-Off", no date + time are listed, so on these line items they return NAN. If start + end date are blank, return 0 (Zero). Searching the community post, I have not been able to locate this formula. I would appreciate your help. 

Is there no way to turn off the permissions to create forms for users?I do not see a way to turn this permission off for users, it appears anyone able to create any other view is able to create a form. It would be nice to be able to turn of the specific ability to create form views. Without having the ability to set required cells inside the table itself, we have ended up relying on using forms for our method of inputting information into the tables as we can control required fields in forms. We use both the normal view forms, and forms in interfaces. The issue currently is that anyone with the ability to create a view is able to create a form which allows them to bypass the requirements of the intended forms and interfaces we have made to ensure that our data remains in a somewhat stable state. It seems like a weird loophole that users are able to bypass required fields unless I am missing something. Has anyone else run into this type of p

Hello Airtable Community,I'm new to writing code and am struggling to combine two different formulas into one. I have 4 columns I'm working with - Due Date, Days Until Due, Date Posted, and Priority. I want the Priority Column to output "Due Today", "Due This Week", "Due Next Week", "Upcoming", "Overdue" or "Complete" based on the number of Days Until Due and the Date Posted columns. I have a formula working that will output "Due Today", "Due This Week", "Due Next Week", "Upcoming", and "Overdue":IF({Days Until Due} < 0,'Overdue',IF({Days Until Due} = 0,'Due Today',IF({Days Until Due} <= 7,

HelloI have three tablesCONTRIBUTORS, with Name and other infoACTIVITIES, with Title and other infoCONTRIBUTIONS, with Contributor name (lookup), Activity title (lookup) and DurationThe latter looks likeAlan, Hackathon A, 12:00Melinda, Hackathon A, 10:00Alan, Presentation C, 4:00Now, I would like a field Total contributions in CONTRIBUTORS that sums up the Duration of CONTRIBUTIONS per Name. 😊This would show 16:00 for Alan, 10:00 for Melinda, etc.I got the result in a pivot table but I need it as a table field.I tried the following, which does not work. 🤔 🤔Total contributions (rollup) in CONTRIBUTORSLinked from CONTRIBUTIONS, field Duration, where Contribuor contains {Name}, aggregate SUM(values)Thank you for your help

Hello! I am creating a bar chart and am running into a confusing issue. I am trying to basically remove the x-axis values from a chart but cannot do so. I am thinking it a difference in how Airtable stores the fields being used in charts? I am not sure. Any thoughts are helpful!I am basically trying to recreate this table using a different table: But this is the result I am getting: 

I posted a legitimate question about markdown/HTML. When I returned to look for the question, I couldn't find it. I looked under my Subscriptions and it indicates it was marked as spam.I contacted the moderator (via the notification at the top of the post) and have twice since then. I already received an answer from another forum but I am curious as to why this was marked Spam and also curious as to whether moderators are seeing those messages?Here is the question I posted.

HI! Is there anyway to turn off notifications for a member so that they are only notified if they are @mentioned?

Hello Airtable Community,I am trying to run a script from a button in a table and have used the following guide:https://airtable.com/developers/scripting/examples/recordpickerhttps://airtable.com/developers/scripting/api/input (to optimize by filtering on a view)When the button is used for the first time, it takes a very long time for the script to run; subsequent presses are almost immediate until the next cache refresh, i.e. a few minutes ( then the user have to wait a long time again).Here are the measured times:Full table 8039 records: 1 min and 49 secondsView 97 records: 1 minute and 6 secondsHere is the very basic code:  let table = base.getTable("POI"); let view = table.ge

I need urgent help, yall - all of a sudden a List-based Interface page won't filter.  Here's the deal:I created the List layout in Interface, set my table to Tasks, configured all the visible fields and sorting options.  I want to add a dropdown for the Project Category field which is a lookup field in my tasks table.  The base structure looks like this:Projects > Milestones > TasksSo I lookup the project via the milestone in the task table and use that for the dropdown in the layout.This has worked for the last 10 days I've been using it.  Today it doesn't work.  Choosing an option in the dropdown doesn't affect my list at all.I have also used the built-in filter option to do the same filter and it doesn't work either.Filtering in the base itself works exactly as expected and the other Interface page filter options all work as expected.I created a brand new page with the same settings and it doesn't wor

Hi all,I'm looking to roll up a set of linked records into one total linked records field.I am building a sales CRM and have different recruiters being labeled for different phases. Below is an example of my "leads" database. All items in brackets are [linked records] to the recruiter tab, where i've build recruiter interfaces for them to interact with their current lead statuses and etc.For example:Prospect LeadRecruiter Phase 1Recruiter Phase 2Recruiter Phase 3Total RecruitersProspect 1[Sally][Jane][Sarah]

I can add a button on my interface page that navigates (go to interface page) to a form. However, I'd like to set a field value (within that form)  based upon current focus.The application is an ideas board so I'm focused on Idea A (main page) and I navigate to a voting table (form) but I want to pass idea A to that form.So I'm thinking I need to associate the button with a script but cant find example code for this application eg interface page navigation. Can anyone point me to an example?

Hi support team!I am building custom extension using airtable blocks sdk.Workflow here.1. When I click "Get companies" button in extension section, the extension will call 3rd party API.2. The API returns the result as a JSON format. Json contains record Ids of a table named "All companies".3. After this, I want to refresh airtable view of a table that is selected record ids returned from API.Is it possible?Please help me, thanks.

Hey all, Looking for a custom script/formula, happy to pay if required. i have a table full of records that are daily jobs. Each job has a value and I want to be able to show a total of all records that match 2 fields (customer and week number). The result should land in 'Total This Week' and the record 'Total in Matching Week (Expected Answer)' gives the expected answer.Hope it is clear but ping me if not. Have tried using various scenarios of roll ups into other tables but cant get it.https://airtable.com/appqWVJT26DBHjzDO/shrXA4B7gcO7XWTiCAny help would be massively appreciated, really get me out of a pickle.  R   

Hi CommunityI am using the Zendesk sync and have realised that I am only getting the first comment on a ticket and follow-up comments are not coming through.Can anyone point me to documentation that explains how Airtable connects to ZD?I am assuming it is the Ticket API but wondering if there are any details about the standard capabilities of the sync out there. We have a ton of customer fields in ZD so it is a nightmare trying to go through everything to identify what looks like a standard way of working. tl;dr - I want to see all the comments (at the very least, the public comments between the customer and Zendesk Agent) in Airtable - anyone know how I can do this?

Hey there.I'm trying to get the duration of an activity by calculating the difference between 2 timestamps.These timestamps are the results of a formula that shows the time as a box is checked at the start of the activity and another, at the end. The formula in Start Time and Finish Time fields are:IF({Start}=1,DATETIME_FORMAT(SET_TIMEZONE((LAST_MODIFIED_TIME({Start})), 'America/Sao_Paulo'),'H:mm'),0)IF(Finish=1,DATETIME_FORMAT(SET_TIMEZONE((LAST_MODIFIED_TIME(Finish

I’m working on a trouble ticket table that keeps track of support for our users. I want to be able to track when a box was checked. So I have a “Followed up” checkbox field and I’d like to track the time from when the record was created to when the box is checked. I’m pretty sure I know how to figure out the difference in time with a formula but I’m having a hard time getting the timestamp of the box being checked. I can see the time in the expanded history view but there’s no way to reference it as far as I can see. Any help or workarounds are appreciated!