Ask the Community

Hi, Zapier pulls in employee leave when its added to a google calendar. Employees can take time off in half-day increments. If the start date is 21st Feb 2020 2pm and the end date is 24th Feb 6pm that should come out as 1.5 days holiday. (date diff ingnoring the weekend). I think I can see how to add in UK holidays but is there a good way to take the time of day into account so a morning or afternoon is counted as a half day? Thanks!

Hi, I have a table with a single select field called “Status” that has 3 values (Pending, Refused, Granted) I want that every new record to be receiving default “Pending” value and i also want to be able to change it afterwards to either Refused or Granted. Thank you

Hi - desperately need help in figuring out what in the world is not working. I am creating a production timeline where the campaign launch is the starting point. From there, I want to count and report certain milestone dates bases on a typical timeline. These milestones are working days (M-F) so not a normal "count backwards". I have to do this for multiple types of campaigns, so instead of making stagnant formulas I'm referencing dates on another table. yes, I looked in to automations and record templates, but they don't allow for relative dates so this is the workaround. Example) Campaign 1Milestone 1: Day -13Milestone 2: Day -10Milestone 3: Day -7Milestone 4: Day -2Milestone 5: Day -1Campaign Launch: Day 0Example) Campaign 2Milestone 1: Day -17Milestone 2: Day -15Milestone 3: Day -12Milestone 4: Day -5Milestone 5: Day -3Campaign Launch: Day 0I've been trying to use the formula workdays to accomplish this while referencing the milestone dates, but every time I use it the fo

I have several tables in my base.For each table, I import, on a monthly basis, an Excel spreadsheet.Every time, every single time, I have to re-map all the necessary fields (15-20 for each sheet), even though the format/layout of the spreadsheet hasn't changed.I want to know how to avoid having to re-map every time I import an Excel spreadsheet. I want Airtable to remember the mapping it used for that table the last time I imported an Excel spreadsheet.I am NOT looking to import CSV data. If I wanted to do that, I would use the CSV Import app. I don't. I want to import Excel sheets.Can this be done or not?

This is to avoid accidentally modifying cell contents or modifying rows. Often time I was in a table view and the mouse was placed at a cell, and I wasn't careful enough so keystrokes sometimes override the contents of cells. This can happen if you are using hotkeys, e.g. CTRL+C but it's not simultaneously pressed, so a C may replace the cell content you want to copy. If I didn't notice this before I lost the chance to undo, it would be very painful or sometimes even impossible to recover the content. Note this is not the View lock, nor the lock to specific cells. It's also not permission-based locking. Just a fool proof for data integrity.I'm imagining that I can set a table to default lock state, so that any modification in the table view was either not effected or with some warning before taking effect. A user can still modify the content in the row editor. Are there existing features that are similar to this, or can this be a feature request? Thanks!

I have a customer table and a products table. Under interfaces, I have an Explore / Find Customer grid view. I would like to add a button that opens another page showing all of the products that Customer is linked to. I can already see the related products in the fly-in view, but how do I parse this information to a new page view when I can display it as a grid?

Hi there,Help!Our Zapier connection stopped working despite the automatic Oauth integration managed by Zapier. Anyone know how we can fix this?We get "Validation error" as message.

Hello community! I am looking for assistance with the design of a table that involves records with a field linked to other records within the same table. I know how to include differed records in a field but I donk know how to see in the second ones that have been connected. Let's see an example: I have a table with a list of schools. I mark in a field of one of the records (school 1) that collaborates with 2 other schools (school 2, school 3) (I use a field linked to the base that permits multiple records). The question is: how can I see inside the records school 2 and school 3, that they have been linked to the record school 1? Is it a way to get this? Thank you very much Marta

Hello everyone,I've been working on a project that involves making calls to the OpenAI GPT API from Airtable scripting. However, I've encountered a limitation that's been a significant hindrance in the progress of my project.The issue lies with the execution time limit for scripts in Airtable, which is currently set at 30 seconds. In my project, I'm using OpenAI's GPT to generate text based on prompts, and the time it takes to make a request to the API and receive a response often exceeds this 30-second limit.This becomes a significant issue especially when dealing with larger text inputs or outputs, as the processing time inherently increases. Network delays can also contribute to the problem, further extending the execution time.Given the complex nature of language models and the extensive use cases they can cover, it's often necessary to allow for more processing time. The current limitation restricts the full utilization of these powerful APIs and hinders the creation of more compl

I wanted my user records to have a field determining skills and proficiency for each skillsSay for exampleFull Name | Language ProficienciesElsa | English - Beginner, Dutch - Mid-Level, Japanese - FluentHow do I achieve that?  

Hey team, I’m looking to create a form where our team members can submit updates on the Objectives / Steps they’re working on. Ideally I’d like to have the member select the Objective and based on that, the Steps option will filter to the steps within that Objective. Is that possible?

I have an interface that pulls data from our working base.We have recently begun to approach our max limits on that working base. I have duplicated the working base and called that duplicate "Archive01".  I plan to delete all but a year's worth of data from our working base to free up space, leaving the "Archive01" base to contain past historical information.I have an interface that currently looks to the working base to import data and produce charts to assess the past 3 years worth of work. I now need to change that sync to have it pull the data from the "Archive01" base instead so I can maintain all the charts.However, when I go into the sync configurations to change it, I am only allowed to change what VIEW I want to pull data from. I am unable to change the BASE.Any idea how I can keep my interface connected to all that data so I don't have to redo all the charts??

HelloWe have 50,000 max record limit on our plan.On our settings page, it says we're up to 35,500+ records thus far.However, when I manually look at all our master tables of data, it only ads up to 28,000So I'm wondering where is that 7,500 record discrepancy is coming from?If I have ONE record in my master table that shows up in 10 other views, does that single record actually count as 11 records?? (in the master table + the 10 other views)I always assumed that views simply pull select filtered items from the master record set and didn't count toward the base record max, since they are just regurgitating data that already exists, and not adding more data rows. Is that incorrect thinking?Thanks.

Hi there,we try to find solutions for this use-case:We want to create "logic" URL's for our data-sets, what we can do at the moment is creating a formula "www.airtable.com/base-id/table-id/" & recordID().What we would like to define is the part recordID(), because all of our fields have a type-number (for example AA550). So it should be a formula "www.airtable.com/base-id/table-id/" & type-number with the result:www.airtable.com/base-id/table-id/AA550The reason for that is, that in the past often dataset were be deleted by someone or we have to transfer the database. We're using this URL's in an other database and if the recordID is changing, we have to check that again (yes I know ugly).It could be a filter too, if that's possible to save in an url.

I'm using airtable to manage all my seasonal employee hiring. I have one column where from a multiple selection I choose their job title (eg. Camp Ops, Kitchen, or Waterfront). I want another column that show what certification are required based on the job title I selected. I believe this should be a IF or SWITCH formula.Currently I have a working formula that is IF(Job='Camp Ops',"First Aid & CPR" ) But I can't figure out how to get the formula to also be IF(Job='Kitchen',"First Aid & CPR) and IF(Job='Waterfront',"Lifegaurding") and so on. 

Hi guys!Does anyone know if there will be any AirTable conference in Europe this year?Or some similar conferences about no-code/low-code platforms?Thank you! Have a nice day!

I am a Developer and a paid Business tier account holder. I have sent numerous support and sales requests with no response. I would prefer to handle business privately and use appropriate channels to communicate. But, it seems like no one is home. Please advise.

Hello!I have 2 bases with a table that has two-way synchronization.In the destination base I have added many formulas to calculate prices and costs.Now I need to return the final result value to the source table.I tried using automations, but using "Update Rung" is not allowed in these syncs.I also tried with formulas, but it is not possible.Is there a way to do it within Airtable?The other option is to use third-party tools, such as Make or Zapier, but I prefer to avoid that for now.

Hiya! I spent a lot of time googling and trying to find the answer but not having any luck. I need to find a formula that displays the previous Monday date based on a date in another field. Would also love to know what each element does so I can learn a little too rather than straight copy/paste. Thank you so much!

Hello Airtable Community,I have 2 tables linked - the common column being "Deal Link" a.k.a "URL" (which is primary in Table 2).I have a script that updates Table 2 via API.The problem is, when updating via API, all the data linked in Table 1 from Table 2 disappears (even when record is unchanged). Is the link broken at this point ? How to remedy that ?Thank you.

I'm trying to have the viewer select a job field in a form (post-production, design, etc.)Based on that selection the next entry would be a limited selection of our main record field "primary role" (editor, producer,etc.). I'm able to do this easily, however, if I duplicate this limited selection and change the conditions to another job field (visual arts, culinary) then change the limited selection, the "primary role" field becomes a copy and no longer allows input into the same "primary role" field.Example:'Creative Field' selection (POST-PRODUCTION, DESIGN, etc.)if user selects DESIGN'primary role' selection is limited to those relevant to DESIGN based on conditions met with the selection within 'Creative Field'how can I change those limited 'primary roles' to reflect the other 'Creative Field' POST-PRODUCTION.It will let me duplicate the 'primary role' block in forms but any selections in this new block are not added to the main 'primary role

Hi everyone!I have a schema of 252 records to apply to some client in a standardized order. This is the script I made (deleted different lines because of number of characters:   let duplicaTable = base.getTable("Duplica_Form") let tyrecords = await duplicaTable.selectRecordsAsync({fields: ["Dashboard Clienti"]}) let cliente = tyrecords.records.filter(item => item.getCellValue("Dashboard Clienti")) //console.log(cliente) let arrayTypeform = [] cliente.forEach(item => { arrayTypeform.push( {fields: {"order": 1, "typeform":[{id:"recg1yUeuxfjKfn0t"}],"duplica_form": [{id: item.id}]}}, {fields: {"order": 2, "typeform":[{id:"rec0TnCthwKaCsBcF"}],"duplica_form": [{id: item.id}]}}, {fields: {"order": 3, "typeform":[{id:"recg9NPL21ZWduc5g"}],"duplica_form": [{id: item.id}]}}, {fields: {"order": 4, "typeform":[{id:"reck4nzT8lp9Us5Nx"}],"duplica_form": [{id: item.id}]}}, {fields: {"order": 5, "typeform":[{id:"recPSIR9XZUw6wvNX"}],"duplica_form

Hi there ! I used to have automations running with an outlook connected email being a shared mail box. These kind of mail box doesn't have an outlook account (no password).Since a year now, my automations are no longer working, I have to change every account connected with an exchange account with log in + password. So I tricked here and put a standard email address as connected account (mine) and use the option "send as" and there I put the shared mail box I work with.... still, I have an error message in all my automations saying I don't have the right to send on behalf of...but checking the exchange tenant, I do have these rights....can somebody help ??? How can we used shared mail boxes to send email automation from airtable ???

I have a column in the first table with dollar amounts like this: $20 $20 $20 etc I would like the second table (in the same view) to total these amounts. How would I go about doing that? Thanks

Hello! We were previously using this formula to calculate a recurring date in the future: DATEADD("Publish Date", 7, "days")  However, we're now getting an #Error Message in our base.  I did some searching and found this blog from Airtable.  I tried using their exact formula in that blog as: DATEADD({Publish Date},7,‘days’) but it is telling me "Sorry there was a problem saving this field. Invalid formula. Please check your formula text"  Can anyone help me with what the correct formula is now? I am so lost....