Ask the Community

Is it possible to edit multiple rows at once? I can select multiple rows, but it seems I can only mass delete or mass share - I want to set a certain field value for multiple rows at once.

I am trying to replicate something that I know I did previously, but cannot find the right options to do it now.I've created an Interface with a page layout that is designed exactly as it needs to be.  (Record Review, but I don't think that matters.)  It is drawing from Table X, with a filter for only records that match Y.I want to duplicate that page exactly, and then change the underlying filter.  So, this page should be identical except that it's drawing from Table X, and filtering for only records that match Z.  (I do not want to add a filtering element that can be toggled by the user of the Interface.)I did this easily about 9 months ago, but cannot figure out how to do it now.  I can duplicate a page, but cannot find where I change anything about the underlying data or filtering.  Anyone know how?  Thanks! 

I'm slowly learning some basics, and struggling to understand how I would use Rollups to get "total" metrics. I have a "contacts" base, and a "metrics" base. I'd like to pull from contacts, roll up the total "sent," "opened," and "replied" emails and then I can calculate my % off of those in another column.

Hi,I receive information from a webhook trigger at the beginning of my automation. I want to apply conditional logic based on the values of certain variables in the webhook data (in this case, I'm using Stripe to trigger this Airtable webhook). If you examine the structure of the data contained in the webhook, you'll find that most of the useful variables are located in Body > Data > Object > ...However, when i try to set the condition in the Conditional logic block, I can't have access to the variables in Object (there is no little arrow ' > ' on the right)... Is this bug ? Is there a workaround ?Thanks for the help,LF

I'm using Airtable to manage school operations. We use Google Calendar to organize lessons for different teachers. I'm on a Pro plan.There is a limit of 3 sync sources per table. The problem is that we have 4 different calendars and we need to have all the events in one table. Is there a workaround for this? I tried a lot of different ideas but nothing worked.

Hello everyone!I have a database with multiple linked tables and I have a JSON response with which parts I need to update corresponding records in those tables. To achive that (as I'm thinking) I need to solve a simple problem of zipping two arrays into one. Say, I have [rec1, rec2, rec3] and [val1, val2, val3]. I need to get a zipped array [[rec1, val1],[rec2,val2],[rec3, val3]]. How could I make this transformation with Make? Any ideas?Andrey

I have two tables: Table 1 with companies and their data and table 2 which is synced from box that has the details on company logos as png images for each company. I have managed to use airtable sync to pull in the logo images from box to airtable - table 2. However now I want to copy those images to table 1 that has company data.  Basically the idea is to match the company names between table 1 and table 2 and then copy images from table 2 to table 1 if there is a match.Is there a way to automate this?If I had to make use of lookup fields, how should I go about it?Thanks!  

hi guys, i try to use web clipper for getting data from linked in automatically in my airtable. im new to airtable and also to HTML. so i tried to set up the webclipper by selecting the HTLM atributes with CSS search. But unfortunatly my set up is not correct yet. can you help me and answer if i picked the right html attribute or notationfor example i attached my aproach for the websitewhen i start the extension in chrome, no records are made in the airtable so far.  thank you a lot!regards jana

SYNC TABLE WHILE KEEPING RELATED TABLES.Hello Airtable community,I have a situation that I don't know how to resolve with a synchronized table.1- Situation: I have a "Matrix" table in a base that I've been using since before the option to synchronize bases, where I've built a database with linked tables and a very robust interface.2- Problem: Now I find myself in the dilemma that I have a database in another base generated for "players" in my case, and what I would like is to synchronize it with my "Matrix" table while maintaining the columns generated with the linked tables, as well as the different lookups and rollups.The current situation is blocking me from creating a more collaborative interface with information from different bases.3- Question: Do you think what I'm considering is possible?Thank you very much!

I've been scratching my head to why this is not possible, and I still have a feeling I'm doing something wrong but I can't figure out what.I have a bunch of time logs that has been logged over multiple years. Every log has an item linked to them which has a rollup that assign every time log into a category based on the item.My data looks like this: In the interface designer I want a bar chart that summarises all this data.The X-axis should be the years, then the Y-axis should be the amount of time spent.Each bar should be a total of time spend in that year. Then each bar should further be divide into the rollup categories. 

Hi, first post and new to airtable.I'm looking to place the hour-by-hour split on the timeline view with day timescale on the vertical axis, rather than it being on the same axis as the dates day-by-day.  I'm looking for something like this:While right now by view looks like this:Any help is greatly appreciated!  

Hello - Situation: Volunteers on the team have a 2-year tenure and when those 2 years are up, they can opt-in for 1 more year. My table shows their "start date" and then I have a column showing their "end date" using this formula DATEADD({Current WON Role Start Date}, 2, 'years') and have an automation that alerts me 60 days before that end date.  Need: What I'd like to happen then is after the Opt-In option is discussed and if the volunteer decides to add 1 more year to their volunteer work, a formula runs that gives a new end date.  Based on: What that said, I'd want the formula to run only if YES is selected from a drop down. Then I would assume we can take the tenure date (original end date) and add 1 year to spit out a new end date.  

I'm new to Airtable, but I'm learning fast. I have a table called "Parts" with names and current quantities of parts. I want to create a table to keep track of part orders. I see you can select multiple records from a "link to another record" column, but I need to be able to identify that I ordered multiple of a certain part in an order. However, you can only add a record once to in a "link to another record". How should I go about implementing this?

Is there a way to mirror information from a lookup field into an adjacent long text field? I'm using Diagram Automator and the "insert image" function can't read/populate a URL from lookup field only a text field.Maybe a formula or script that could be used as an automation?

I have a base used for tracking waiting lists for multiple events. A simplified version of the base for purposes of this question is here. Each record is one person’s entry on a waiting list for a specific event. Each record has a Status that starts out as “Waitlisted”, and then we change the Status to other values as we clear people from the waiting list for an event. We normally use a view that groups the records first by Event Name and then by Status, with records sorted by the Created date/time. This is the first view shown in the demo base. We take people off the waiting list for an event in the order that they signed up for the waiting list. We often have people ask us, “what number am I on the waiting list for X event?” Rather than having to manually count rows (which could be 100 or more) to answer this question, I want to have a field that shows each person’s sequential position o

Hello,This table register the time my employes arrive ("Entrata") and leave ("Uscita") using an Airtable database.I managed to have a number that defines the total of hours my employes work during the day using DATETIME_PARSE in the "Worked Hour" Column. I need to sum those hours together in "Total Month" Column (first of all) and then make sure it does consider the month.I'll explain myself better, i would like something like this, using this image.At the end of the formula, i would like to SUM Worked Hours from Line 1 and Worked Hours from line 2, and show it in "Total Month" of the latest created row.As second step, If a new row is created, it checks if the current month in "Created" (i can do it with PARSE i think) is the same month of the row below:- If it's the same month, it automatically adds the value of the total hours in "Tot

Hi Community,I am developing an airtable base with interfaces that manages requests logged by a contractor to a consultants on a construction project and also allows the consultants to respond.I need help with it to add some features on it (Kind of out of my depth).Kindly reach me on meisternbim@gmail.comIt's very urgent.Thanks.

Hi, I am a new user of Airtable. I'm creating a new Sales Base for a carpet company.  I have two tables, Sales Orders and Sales Order Lines, which are linked one to many. I want to create a Form, Enter the Sales order information, and then be able to create new sales order lines related to that sales order. However, it seems on a form, and you can only select records already in the sales order line table. Any help would be appreciated. ThanksSteve

BackgroundI am using a "Search Records"-module in Make Automation to compare data in a scenario (=item for sale) against records matching specific criteria in Airtable (=user wanting to buy an ite, like a  "search request").Desired BehaviourThe search formula SHOULD  return the records where:1. Container Brand = Container Brand OR Container Brand = empty OR Container Brand = empty AND2. Height Value = empty OR  Height = empty OR Height Value = +/-8 of Height AND3. Weight Value = empty OR Weight = empty OR Weight Value =+/-10  of WeightIn plain language: Return those records where the Container Brand matches the customer preference AND container sizing is +/- close enough to the height & weight of the customer. If value is missing, then assume a match as the business decision is to avoid "false negatives", thus better inform t

HiI have two tables: Table A that has a period_start_date and a period_end_date and Table B has a bunch of rows with a date columnIn an automation that's triggered by a particular row on table A (which means I know the period_start_date and period_end_date to use) I want to find all the records from table B where the value in the date column lies between the period start and end.The "Find records" automation seems to allow only static date values, but I need to use the period start and end dates from table A.Any suggestions on how to do this without having to fetch all the rows from table B and then loop through in code, which feels very wasteful and slow.Thanks in advance

I want to create a "Kudo board" where employees can select from a drop-down list (single select) of company employees they want to give kudos to.My thought process is I would like to create a form that includes a list of employees' names from a drop-down (single select field) and a long text field, to add the kudos. When they "submit," it will populate a table with the employee name and the kudos received.If I want to add a  single select field under forms, is there a way to copy/paste in a list of employee names? I don't want to type them out one by one.Note when you are working directly in a table, you caneasily copy/paste a list of names directly into a single select field. Here's a video that demonstrates how you can do this in a table: https:

Hello. I've been working on a database template to share with other organizations doing similar work. I've recently published that template to the Airtable Universe, but two views are not transferring correctly. These two views are filtered views, and they are filtered based on the values in a lookup field. They are working in my base, but in the published version, the filter remains, but the values are listed as "unnamed position." Those look-up fields are themselves looking up data from a linked field that meets certain criteria. I'm assuming there is something that is breaking in all the steps necessary to carry this over. Any ideas?

One of Airtable's FAQs on how to use a form to modify existing records utilizes automations. Fine, but if I'm going to use this a dozen times a day I'm going to be hitting my 100 monthly automation runs pretty fast, especially since I also want to email daily and weekly reports.So I ask, do automations acting exclusively within Airtable count towards that 100 number?

Hi all,I'm using a line graph in an Interface to show number of virtual vs in-person attendees at events each semester, but it's not catching when there are 0 in-person attendees at our virtual-only events. I have the semester in the X-axis, and count of records in the Y, grouped by the "In person / virtual" single-select field, as shown here:This works, except it doesn't 0-count semesters that were virtual-only (no records with "In person" in that field). I underlined the months where we actually had in-person attendees. 2019 Winter had 120 in person attendees, 2020 Spring was virtual-only, and 2020 Winter had 33 in-person, but because there is no 2020 Spring data the graph makes it look like there were 76 rather than dropping down to 0 and coming back up.It's so hard to tell which semesters there is actual data. There's not even dots or anything to show t

How about creating a new field type ("Formula Script" or such), where Script (or at least some subscript) can be used for a field formula?  Or optionally allow Script in Formula field?