Ask the Community

HiFirst time here ! I have a problem with the Google form automation. I use the trigger "When response arrive" to get the answer from a Google form. The automation was working well, retrieving the answers from the google sheet and adding them to my database. But for a few weeks now, the retrieval no longer works (it doesn't trigger at all). I've checked that the trigger and action tests are ok.I also noticed that when I modified the width of a line in google sheet, the automatization was triggered and brought back all the records that hadn't been taken.  I've tried duplicating the automation and reconfiguring the trigger, but it doesn't change anything....

Hello! I have two fields as per this table:ScoreLikelihood15%220%340%460%580%Is it possible to type a score 1-5 in that field and return the associated percentage in the Likelihood field. Then also being able to do the reverse when needed: ie. typing in the percentage in the likelihhood field and return the associated score in the score field? Many thanks to anyone who might

I have a table with many fields but only a few records. Horizontally scrolling to see all the fields when there’s a lot of empty vertical space feels weird. Is there a way to flip the display of rows and columns so the screen space is used more efficiently for these kinds of tables? To be clear - I’m not talking about pivoting the data. I just want to see rows vertically to make best use of the space.

Hey everyone, I’m looking for an option to quickly add another record within a multi select field at mass without having to do it manually for each one. Eg. Taking geographies as an example. I have a bunch of fields that have Europe and I want to be able to easily add ‘France’ without having to go into the cell manually, in fear that France will just override Europe and there will only be one value. Would appreciate any help! Thanks

Hi all,I am stumped but I feel like the answer is staring me in the face!  Hoping yall can help!I have a membership tracking base set up as follows:TablesPeopleEventsAttendancePeople and events are stand-alone tables.  The Attendance table basically links them with a field for People and a field for the Event.What I need is a total number of events (within a date range) to be used in calculating a minimum attendance requirement per person.Anyone have an idea how to accomplish this?  TIA!EDIT:  I know how to calculate how many events each person has attended.  What I need is the total number of events so I can do a formula something like {# Attended} / {Total Events} = % of Events Attended.  Thanks!

Good afternoon, I am very new to Airtable. You will realize it, if you read my post ! :slightly_smiling_face: I have a table with the dates and times of arrivals and departures of guests at the airport. I want to know the number of days I will have to allocate the cars that will transport them. The cars are rented on a full day basis. I am trying to calculate the number of days for the cars, taking into consideration the dates of arrivals and departures of the guests. I am using the formula DATETIME_DIFF({Date departure},{Date arrival},‘d’)+1 The formula is returning the result taking also into account the time of the day of the arrival and departure, and I really want only the full day. I believe that the solution is very simple, but someone can help. For example, one guest arrives on 26/06 at 11:00am and departs on 02/07 at 09:00am. the result that I’m trying to obtain is 7 days, and not 6 days Many thanks in a

That's a bizarrely framed title, but I'm unsure how to surmise..Here's what I'm trying to do:I run a garden. We have 3 different nutrition programs, that use a different mix of ingredients, and share some ingredients. The amount to make depends on how many m2 are to be treated (or how many L of water are used to drench seedlings).These programs are:Foliar 1 (mixed for m2)Foliar 2 (mixed for m2)Transplant Drench (mixed to vol of water used for seedling drench).I need to keep records for our organics certification on what inputs are used, and when and where they are used.So I want the user to be able to select "Foliar 1," input how many m2 of garden they are treating (or how many L of water they are using to drench seedlings). I then want Airtable to "generate" the quantities of each input they need, without needing to do any potentially confusing math. It ca

OVERVIEWI'm using Airtable as a main inventory of the products I sell.I have a table wherein a new record is created with an SKU whenever I scan a barcode of my product. WHAT I WANT TO ACHIEVEThe Main Inventory is located in another table. I just want to automatically link the MAIN INVENTORY whenever the StocktakeID ( or SKU) has a match.Here's my automation PROBLEM: The test works but nothing happened. I also tried doing a direct automation like When a Record is created, upda

Continuing the discussion from Dedupe - Merge fields from duplicated records, Merge data A (AND) data B, instead of data A (OR) B: Dedupe - Merge fields from duplicated records, Merge data A (AND) data B, instead of data A (OR) B To me this sounds like a job for a rollup. Not knowing the specifics of your base, I’m going to just take a

Hoping for some help! I have a column with a date in, and two other columns, one with a start date and one with an end date, I want to do a conditional / IF rollup that brings me through a value if the date in question falls between the start date and end date in my other columns grateful for any help!

All, I’m trying to import a file doc file that exists in an airtable attachment field into Google Drive in integromat. So it actually creates a file, by the name that I have assigned. But when you open it, here’s what it looks like: You’ll notice first that it doesn’t open in editor. And what you are able to make out of the text is the address of the file in airtable (according to airtable). As far as the setup in Integromat, here’s what the settings look like:

I’m brand new to Airtable and getting to grips with it all so forgive me if this is a simple and stupid question. I’ve got a table logging expenses by two people. I’m using a currency field to add the amounts spent by each person. Now I want a second table that shows the overall funds both people start out with and then a field that shows the current funds available which updates according to the expenses logged in the expenses table. Can someone explain to me how to do that? I don’t even know what sort of keywords to look for in the help sections. Thank you so much for any help! Anna

Hello, I have a base that is currently public and a view that is also in "community" mode with presumably public settings, but logged-out users cannot access the records that I have linked in the Gallery. How can I fix this? Pictures of configuration attached.

Hello,I need to sum the two smallest values between three values.Example:- Value 1: 10- Value 2: 20- Value 3: 30The two smallest values are "Value 1" and "Value 2".How to do this via a formula (or other

Hello all,I currently am trying to create a formula in which I calculate days since last contact, with some of the source cells either being blank or having "N/A" as a value. I plan to make cells either all blank or "N/A" if the person hasnt been contacted. what I am trying to do is have a tonow(date of last contact) formula in which if the cell is blank or N/A it states "N/A" instead of "invalid date".Thanks!

Hi all,I would like to create an automation that triggers each time a record is created to update a formula (I guess, this is the part I'm unsure about).One table creates records through an automated link to Google Calendar, creating a field with a number value (number of hours) and a single line text (a name). In another table, I want to add up all the hours in one record, titled by the same name. This record already exists, so it needs to be updated every time Google Calendar creates another record with the name of the person in it.I already set up the automation to trigger each time a record is created and link it to the second table via "search records" and IF {Name} in table one IS {Name} in table two (paraphrasing here). Now I can't figure out what to put in the formula field in the second table to actually let it update and show the sum of the hours of all the records in table one.Any help would be appreciated, thanks!

I used the Airtable CRM template to build a CRM for my company.I have a Organization table that collects company data - a Contact table that collects individual's data - and a Events/Activity table that tracks what events/activities contacts have participated in.I currently have all of this data tracked in Google sheet.On my Contact table I have the organization table linked to the Contact table so I don't end up with two tables of data on organization.I can't figure out how to upload my contact data into the Contact table so that it uploads the organization data into the Organization table so it will be linked to my Contact table. 

Hi there!I'm wondering if there's a way I can add a distinction for fields that have the same data. For example, there's two entries that are on the same date (09-22-2023). I have been trying to find out a way to somehow, say, put 09-22-2023a and then 09-22-2023b so I know which one is entered first and so on.I'd appreciate any insights. Thanks in advance!

Hi everyone! 🙂In one table, i got Name + Surname + Email AddressIn another table, i only got Email Address, but i need to fill in the Name + Surname that i have in the other table.How could i do this?Thanks a lotMarco

Hi Everyone,I have two automations that I need to combine into one. Is there anyway to merge the two or move pieces from one to the other without having to rebuild the content? I would have set it up as one automation to start with, but I was new at this and didn't see how to do so at the time. We're bumping up against automation limits, so it's important to combine them.Since they both trigger the sending of emails with a lot of inserted fields, it's a hassle to do it manually as even if I copy and paste, I have to manually re-insert the custom fields.  I tried searching but only got results related to automations that merge records, not anything about merging the automations themselves. Thanks for any insights you can provide! Regards,Anne

Hello, I'm trying to create a view that is tasks stacked by owner in Airtable as a kanban but it keeps creating cards with deactivated users in them but there's no way to delete or hide those users. I think this will be irritating for my team because it's more people to sift through. Any ideas?Thanks,Emilia 

I'm building a Project tracker with the following tables:Projects / Tasks  / Sub TasksI'd like to add a list view on the Projects table which would show the Projects > Tasks  > Sub Tasks in that order. But it looks like I have to put the List view on the Sub Tasks table? I'm not sure my users will get that.Am I doing something wrong when setting up the List View? If I try to make a List View in the Projects table Airtable tries to put the Projects at the bottom and work up to Sub Tasks.

I manage a large media plan with multiple users. As due dates approach in the following increments, 60, 30, and 15 days, I want to trigger an email that will inform that user if they have not provided the necessary information to deploy the ads. I have set the first trigger up at 60 days however it is sending per record, not per user. Is there a way to consolidate all the records into one email?Thank you in advance!

Hello,I would like to share a base with collaborators in read only or comment only, but I would like them to be able to edite view, specially the filtering field to be able to search throu records more efficiently.So far i'm only able to share in editor mode for them to have acces to the filtering button, but then they can chage the data 😞

Hi all,I'm creating an automation to retrieve data from an endpoint then update a record in Airtable.The api call works, the data is formatted into a string, and correctly passed into the `updateRecord` function.However I'm getting the following error when testing the automation:Error: Request parameters failed validation.Here is the code:  let inputConfig = input.config(); let table = base.getTable('Orders'); let record = inputConfig.recordId; fetch(`https://api.myEndpoint/${record}`, { method: "GET", withCredentials: true, headers: { "Authorization": inputConfig.apiKey, "Content-Type": "application/json" } }).then((response) => { return response.json().then((data) => { updateRecord(data) return data }) }) const updateRecord = async (data) => { let status = data.status await tabl