Ask the Community

Hey guys,I am looking for a way to help restrict access to certain bases I have in my workspace. I thought using groups was the answer, but that doesn't seem to be it as the groups still have overall workspace access and I can't seem to remove someone who's in the workspace from a base.We have our workspaces separated by the different companies in our parent company and then within each workspace is a base for the different departments. I have groups for the different departments as well that I was hoping to use to have for example the GFX department have access to only the GFX base.Does anyone know how I should be using workspaces, groups, and bases to restrict access? I feel I am using these wrong.Thanks!

Colleagues top up holidays and travel expenses in Airtable. We would like to account for the empty dates 13 three random days in a given month. Is there any way to automate this?

I am attempting to use Airtable as a month end close tracking form. Is it possible, that once a task is completed, it will create a new task for the same day in the next month? As an example, this task would be completed on December 15th, then once completed it recreates the task with a deadline of January 15th.

Hello,I manage an Airtable base for a motorsport event management company. Right now, we have to use JOTFORM for the customer registrations, because the company uses Authorize.net, and the client wants the registration form to be submitted with payment in the same step. Upon looking into Zapier, they do not support Authorize.net. (So if you know a workaround for this, we would LOVE to just use Airtable instead of two different platforms for customer registration.)But! That's not the main issue at hand. The main issue is that my client has a list of Instructors for these events that we are currently registering via a form on Airtable. However, the instructors have to fill out the entire form for each event, and this is a bit tedious and redundant, and causes us to have to go in and delete duplicates if the instructor has forgotten if they've registered for the event or not, and fills out another one. I have sifted through the community, and youtube, and still haven't been able to find a

I have a dashboard using a Timeline view. Add records is enabled. I can click on the plus button to add a record, but the dates are always odd and not reflective of where I am in the timeline. But if I try to do the click and drag to add the record directly in the timeline window it doesn't do anything. is this a bug or am I doing something wrong?

When initiating an OAuth authentication, it is possible to provide additional parameters, meant for custom use of the client application.These parameters are correctly passed to your https://airtable.com/oauth2/v1/authorize page, as URL query parameters along the standard parameters (nonce, response_type, code_challenge_method, scope, code_challenge and client_id).However when the redirect_url is called after a successful authentication, the additional parameters are not included. That would be a standard behavior your authentication should support.

Hi there,We are using AT as a project management tool and I am trying to create a field that indicates Project Status. The field would live on the Projects board and default to "Submitted", when we receive a request. We have a separate board for Tasks, and we use an extension to generate the tasks for each individual project. So once the tasks have been generated and assigned the Status would change to "Assigned". Once the team member views their assigned task the Status would change to "In Progress". We are using a formula to calculate the % complete so once all tasks have been completed the Status would change to "Complete". Because there are 2 boards and already a formula field we are pulling from, this seems like a complicated (but not impossible?) equation. I just dont know Airtable well enough to be able to figure it out! Does anyone know how to create what we are looking for? 

Hi, I’ve created an interface from my base which I’ve tried to share with users who work off iPads. I’ve tested two so far and while the interface works on The iPhone app on the iPad no interface shows up

I am having trouble with my vacation day calculation when an employee is only taking one day off. I have a formula to count the days requested and they always show up as negative which is what I want to subtract from their approved days, but when they request 1 day is comes up as a +1 and throws the calculation off. Could someone help me with this? I know it has to be a simple fix. Thanks!  This is the formula I am using: WORKDAY_DIFF({End date (vacation)}, {Start date (vacation)})

When I select a lookup field in Airtable, it retrieves all the values within it, but I want to make a selection from within this lookup field, is this possible?

Hi everyone,I'm trying to create a formula field to calculate last week.I have a view that shows me the events that refer to last week, I added a formula field to calculate all the events that have the "Date" field dated to last week, but it doesn't work in any way, because it continues to insert the camps of the current week. Can someone help me?

I have a primary field which is an autonumber and I want to change it to a formula (pad the number with zeros, concatenate with another field etc.). My plan is to keep the autonumber, create a formula field, and then change the primary field to be the formula field.Is there any risk with that? can such action break any dependencies? scripts?

Hi! Is it possible to create an automation that will email someone the results from one column (not the full record) of a grid?We are doing an exercise where staff fill out an airtable form saying what they value about other people on the team (long text responses).  So each record has the feedback about every staff member from each person that fills out the form.  Is it possible to have an automated email go out to individual staff members with just the responses from their column?Hopefully this makes sense - thank you!

Hi everyone, I know I certainly need automation. But I am not sure what I am going to do.Description of the problem:I created a delivery driver pickup form (in Table 1) for volunteers to submit their pickup schedules for one or more schools. Right now, I will need 3 information (name of the pickup person, pickup date, and pickup time) submitted in this form to be automatically updated in an existing classroom table (table 2).I have tried different ways. However, it seems like I am having difficulty for the information in table 1 to be correctly matched with the information in Table 2. I think the problem is I don't know which Record ID I should pick and the system keeps saying there is an error when I was setting my automation.My goal is that I am hoping if a volunteer submits that they will pick up materials for school A, the 3 required information I need will automatically update in the same school in table 2.Thanks so much, any feedback is greatly appreciated! Table 1: Tab

I have a list of records that's something like this. PROJECT NAMEPROJECT VERSIONCONTACTASSIGNEEApples1JoeBobApples 2JoeBobBananas1SallyJimOranges1JoeJudyI receive a .csv report with the most recent information about the first three fields every week. The fourth field (assignee) lives only in Airtable. There are additional fields as well as notes and comments on the records that need to be maintained. The weekly report often includes changes. For example, a new "active project" may be added or something might change about the project, like the CONTACT field. Example .csv report:PROJECT NAMEPROJECT VERSIONCONTACTApples1JoeApples 2JoeBananas1JillOranges1JoePears1JoeWhat I'm trying to do is find a way to import this new .csv report and have Airtable update/merge the existing records that have changed (in this case, the CONTACT on Bananas project is now Jill) and add any records that didn't already exist (Pears project). The CSV Import extension only allows you

I have a complex formula I am trying to write, and unfortunately it says there is an error in my code, but I can't seem to work out what! I am trying to write a custom field that says LIVE, FUTURE or COMPLETED depending on the number of days away an event is, and in what region. For example, I want a project to be live if its 180 days away or closer for AUS/NZ, but only want a project to be live at 120 days for EMEA. Here is the code I have written so far, which doesn't work (for now I have simplified to just be LIVE or COMPLETED, as once I have worked this out I'm sure I'll be able to add future!): IF( AND( (OR(Territory = "SEA",Territory = "AUS/NZ")), AND( DATETIME_DIFF(RHO, TODAY(), 'days') < 180, DATETIME_DIFF(OPEN, TODAY(), 'days') >= 0), ), "LIVE", IF( AND( (OR(Territory = "CAN",Territory = "NAM",Territory = "EMEA",Territory = "MENA")), AND( DATETIME_DIFF(RHO, TODAY(), 'days') < 120, DATETIME_DIFF(OPEN, TODAY(), 'days') >= 0), ), "LIVE", IF(DATETIME_D

I have a javascript code that basically displays a recording menu that allows you to record your voice, and then I added that on stop you can click to send the file to airtable. But I keep getting 422 error. I read somewhere that when sending attachment it need to be on publicly available url. Any ideas how can I solve this?$.ajax({        url: apiUrl,        type: 'PUT',        headers: {          'Authorization': `Bearer ${apiKey}`,          'Content-Type': 'multipart/form-data',        },        data: formData,        processData: false,        contentType: false,        success: (response) => {          console.log('Audio uploaded to Airtable successfully:', response);        },        error: (error) => {&

I have a script that takes a fuel price increase in a single cell and applies it in each cell in a row of fuel prices at various Fuel Stations. The code is copied below. How can i optimise the code to run in as little time as possible?let table = base.getTable("Customer Deals"); let queryResult = await table.selectRecordsAsync({fields: ["Petrol Price", "Price Increase"], sorts: [{field: "Price Increase", direction: "desc"}]}); let firstRecord = queryResult.records[0]; let increase = firstRecord.getCellValue("Price Increase"); if (!(increase === 0)) { for (let record of queryResult.records) { let newPetrolPrice = record.getCellValue("Petrol Price") + increase; await table.updateRecordAsync(record, {'Petrol Price': newPetrolPrice}); } await table.updateRecordAsync(firstRecord, {'Price Increase': 0}); } 

The Google Vision API extension offered by Airtable works well enough if one wants to retrieve labels, logos and texts from an image. However, the Google API offers other capabilities, such as tagging offensive images and, what interests me most, calculating the dominant colours of an image or suggesting cropping possibilities. The Airtable extension doesn't seem to give access to any of this.Is there something out there already that might allow me to retrieve those extra features and insert them into a field in my database ?Thanks.  

Hey All,I'm looking for a way to add files that are not hosted on a public site. The server hosting the files allows for basic auth so I should be able to pass credentials. I'm wondering if it's possible to use `fetch` in an extension to get the file and then add the file to an attachment field. Definitely open to better ideas. Cheers,Collin

I am receiving this notice when attempting to upgrade: "We were unable to upgrade you at this time. Please refresh the page and try again. If you continue experiencing problems, please contact us."I was charged and my upgrade has not been reflected. I contacted customer service but the 1-2 TAT turned in 6 days -- no response. Any suggestions?I would think a financial ticket would be considered important. 

I'm using the highly useful Prefilled Forms extension by Kuovonne and it works as intended. However, there are some fields in my source table that apparently aren't qualified to be prefilled on the form and I can't figure out the principle. (The form itself is in the Assets Updates table.)The Assets table contains the prefill form URL in a field called Update Asset. It works fine but does not include a field called Asset Type that I want prefilled on the form. This field is not included in the list of possible fields to use when filling out the wizard for Prefilled Forms.Asset Type is a linked field to a third table called Types. In this screenshot you can see that I've reduntantly added two additional fields that contain the value from Asset Type, thinking there was something about Linked records that was a problem:But I can't use any of these fields to prefill either. Why is that? At least one other linked field, Modules, works fine and is prefilled on the form.Here's a par

I built some scripts a while back using the airtable python API wrapper.  I was able to create new records in a table with linked fields using only the string value of the linked record. This was very helpful since I could upload records to 'Orders,' for example, and Airtable would accept a string, for example a Product SKU, to designate which Product to link to.Since updating to the more recent pyairtable wrapper, I'm not able to do this anymore.  I need to know the record ID of any record I want to include in a linked field.  This means extra steps.  Is there a way to use strings instead of 'array of record ids' as the value for linked fields?

If I have 5 blank rows, then values 5, 10, 15, and I sort by that column, those blank rows show at the top and I would like them to show at the bottom but the 5, 10 and 15 still sorted showing at the top. Is this possible?