Ask the Community

Hi, I was trying to add a record and a pop-up error appered, do you u why?

Is there any automation in which I can transfer the whole record as it is to another table when it meets certain condition?Basically I have table 1 where once I click approved, the record should go to table 2. I am aware about the create a new record method were we can map all the data from table 1 columns to data in table 2 columns but I have nearly 100 columns and need to be done in 4 tables the same thing. It is very time consuming.

HiI'm a new Airtable user and I'm trying to determine the best approach to creating a dashboard view for each client at our firm with read only access.I'm aware you can create 1 base and filter views but that would make it possible for clients to see each others dashboards.Would it be better to create a single base specific to work for a single client and use that data set to create a dashboard or is there a way to prevent a client from looking at another client's dashboard if I chose to use a single base and filter views?

I have two tables Experiments and Readings.Each experiment is linked to two or more reading records. Each reading has a DateTime field, and some readings such as pH and temperature. The pH and temperature readings are number fields.I want to use the first and last sets of readings in the Experiments table in some numeric formulas.In Experiments table I use a rollup field with MIN(values) to find the earliest DateTime in the linked readings. In the Readings table I use a lookup field and copy the {First DateTime} reading back into the readings table. So that all the Readings for a specific Experiment contain a field which is set to {First DateTime}.Then still in Readings, I have a field {First Temperature} with the formula:IF(DateTime={First DateTime},Temperature, '') Then back in Experiments I have a corresponding field {First Temperature Reading} that looks up the result in the {First Temperature}

EDIT: I was able to solve my issue. My field configuration for linked records wasn't set up correctly. I think I just needed fresh eyes on it the next day.I am trying to create the following automation:Trigger: If a check box is selected on Table 1, thenAction: Send emailAction: Create a record on Table 2 using selected fields from Table 1Action: Uncheck the box from the initial trigger on Table 1When I run the automation on a record in testing, everything works perfectly, both when testing the individual parts as well as the automation as a whole, but after making it live and trying to trigger it, only the emails get sent and the next two actions are not completed. Any thoughts on what I could be doing wrong?

I have a Typeform question with multi select options. Right now, when the Typeform is filled out, the answers are sent through Zapier and then through to Airtable. Airtable will group the multi select answers into one field. For example for "do you identify as any of the following?" it will group "WomanBlack" together instead of as separate fields in the same Airtable cell ("woman" "black") - Can someone advise? Also how do I have the "Other" and typed answer populate into a different cell?

Hi,I need to add images into a filed in a form, it it possible?

Hi, I am doing a form for a remiders request, and I need that the filed "fecha de envio" the person is requesting the reminder have not the option to select a day before Today (current day).

Hola necesito generar in ID de solicitud para mi form que sea facil de buscar o indentificar

There are 131 fields in my table. After retrieving 2000 records and making them synchronize their fields, i only receive success for 300 records when using scripting to import them to my Airtable table. Why is this? 

Im using the Maps extension and have that working properly. All my records plot nicely. The map marker pin/icon is somewhat adjustable in color, size, etc.Can I have the maker display a record number, instead of just a generic colored pin?I know that I can hover/click on the pin for data. But Id like to print the entire map on a plotter, and be able to identify each pin, from that static print. So, instead of just a colored pin, id like the field number to show as the pin on the map. 

hello guysI  have outdoor laser tag business , I’m running airtable about 5 months after every client booking birthday . I need login to other service enter the details: name kids , ages , address , city , and created birthday invitation. it’s looks like this : http://fiestaa.co.il/inv37.php?id=15111I’m thinking why I do it in this way . if I have the all details on airtable already . Why no use them to create dynamic link from my website . I need same design for the birthday invitation. It’s video background . Each client need birthday invitation so in click from airtable it’s create unique link . And update airtable with .  The next step is to use make and send to client massage with the url to share his family & frie

Hi Airtable Community!I've been tasked with creating a CRM for Events invites and attendance tracking and would love any input on best ways to proceed. So far I have a "Contacts" table and an "Events" table, which are linked based on who got an invite to what event. The problem is, for certain events, we also want to track who RSVP'd and who attended the event on a contact by contact basis so we can reach out, follow-up after, etc. We ideally want to keep the base as clean as possible. I see two potential avenues (and am leaning towards the first) but would love other ideas that might be more straightforward/simple for those who aren't familiar with Airtable to navigate.create a new table solely to track RSVPs and attendance. This table would pull in the contact and the specific event they are attending so that every record is "Contact - Event" and tag accordingly with their RSVP status. Views for each event can then be created to summarize attendance.

Hello Airtable community,I am working on a project where I need to automate some financial reports in Airtable and I would like to ask for your help to solve a specific challenge related to conditional sums in several tables.Context:I have a base with several key tables:[REPORTS] - Commercial: Records monthly orders per year (2022, 2023, 2024) assigned to different commercials.SUMMARY: Contains a record for each month of the year and I need to add up the order totals for each commercial, divided by year.Requirement:I want the "SUMMARY" table to have three columns (2022, 2023, 2024), each showing the sum of sales for a selected salesperson in a single selection field in the same table. The challenge is to have these totals update dynamically based on the selected salesperson.Attempts:I have tried using rollup fields, but these do not allow me to filter dynamically based on another selection in the same "SUMMARY" table. I am co

How do I use sum values automatically calculated when grouping fields for other formulas?I have to calculate the sum of values of a grouped field in other formulas. Is it possible? someone told about rollup, but I did not manage to obtain any useful result. I would need to obtain something like that in the screenshot in the sum field...Thanks in advance for your help 🙂 

Hello, I think I need a help of Airtable community even though there is built in AI helper in the formula field. Here is what I am trying to do and have no success for some unknown for me reason. I'm creating an automation that with the click of the button will send an sms text message to my customer. I've recently experienced a problem with Twillio campaign approval (they are giving a hard time), but I've got an approval with TextMagic. So, Text Magic accepts sms as an email, then converts it to text and then sends it to my customer. I have a dedicated Airtable field for the phone number. Based on this, I've created another formula field that adds "@textmagic.com" after the phone number, the formula looks like this: CONCATENATE(Phone,'@textmagic.com')Everything looked good, so I started with my automation, but my automation failed at the end due the format in the formul

Hi All I would like to know if someone can assist me with create the formula used in the time off id column for this video at the timestamp 2:04 https://www.youtube.com/watch?v=Q-MEmIHCHU4&t=8s

I am working on a database with info taken from an old access database. There are five Tables.Every one of them has a number assocated with a record along with a name or description. ExampleContacts: Contact ID, First Name, Last NameCollege: College ID, College NameProducts: Product ID, DescriptionOn the Contacts table I created a new forumula field that joins the Contact ID, First and Last Names to make Field "Name | Contact ID"This method was followed for the other tables.When I want to link the contact to the college on the Contacts Table, I have the original College ID field (that came from Access) but I want to link the "College ID | School Name". So, I can see the original College ID and I have to type for what / search for the number and automatically have it populate with the correct school I want to write a script or something or an automation that looks that the data in the College ID column and goes

I want to build an automation in Airtable where the user creating the record, will have their domain auto-populated based on the separate table in which each person has their own domain defined.For example, if John is creating the record and the John domain is IT defined in a separate table, when the record is created from John, the domain field is auto-populated.  

For some reason a number field is not showing up in the Interface's filter options.This happens specifically if you choose a layout with a specific widget (I'm using timeline in this case).If you choose a blank layout though, the number field IS available in the filter!What's with the inconsistency? Why would a different layout have different functionality for the same feature?I guess the alternative would be to just use a timeline in a blank page, but I don't want to that. I prefer the feel and options when you pick the timeline layout directly.

Hello - I have a date column of when an event will occur (Showcase Date) & I am wanting a formula to populate deadlines based on number of days before or after this date. Here is the formula I created but it is not working. Any suggestions? I have tried: DATETIME_FORMAT(DATEADD({Showcase Date},{Number of days},'days),'MM/DD/YY')

Dear community, Does someone know how color a field by level of progress? For example, all tasks under 30% of completion in red, tasks between 30-60% in yellow, tasks between 60-90% in blue and tasks between 90%-100% in green? I’m sure that is something very easy to do, but I’m new with the PRO subscription and I still learning Thanks all!

Hi, I'm using Create Record API, my requirement is sending a image to a field in table. But the API requires to send an image URL instead. Would anyone know if there is a hosting service that can return the image URL while ensure the image uploaded is not being public? Or would Airtable team have plan to provide such a service? Thanks!

Finally have gotten fairly complete on a prototype base design for tracking training records for our company (construction industry) and while I have a decent interface setup for showcasing what we could potentially do, I am wondering if sticking with airtable native or moving to one of the 3rd party form and/or front-end platforms (fillout, noloco, softr, jotform, etc) is the right approach (costs being a consideration as well).The general use case is a base with a couple of tables used to track employees, what training they have taken (CPR/1st aid, scaffold, trench excavation, fall protection, etc) and which of those are active, expired, or expiring soon. It also logs and tracks incident reports on the various sites (what project was it on, what employee involved, what happened, corrective actions, etc).I have an interface set that has:A dashboard for our training metrics (% of training complete, what trainings are delinquent the most, filter by project/d

Hi,For some time now, the unlink button on a card shows as a mere white dot when hovering over the item. Only when you hover over the button itself does it show the proper dark background / white 'X'.This makes it hard for users who aren't very familiar with Airtable to work with our interfaces.