Ask the Community

Hello-I have a lookup cell that is pulling data from multiple cells. The results are showing a list of topics. The topics are repeated (as they're pulling from different cells). You can see, for example, that "Space" is being pulled multiple times. Is there a way to tell it to only list topics that haven't been listed, meaning only unique topics (not duplicates)?  Thanks in advance!!

Safari v14.1.2 To the right of a table where it says ‘add or import’ the add or import is flickering and quickly. It started on one base and has spread to another. What can i do to stop it happening and annoying my eyesight. (Uploading a screenshot is pointless as it won’t capture the flickering, rather I’d have to time the screenshot to coincide which at the speed of flicker could take ages. )

I have a table that is creating a record for each client that completes a form. I have another table on the same base which is a synced google drive table with all client folders. Is there a formula/automation I can use to link the "open in google drive" button from the synced drive table to the client table? 

I’m very NEW to Airtable.I want to create a B2C project. The goal is to have the client enter a due date and an email is triggered to notify them each time the item is due. I don’t need to know their due dates because it will become their personal tracker .It’s like their personal planner/accountability tool.Is this possible?If so clear and simple instructions because I’m learning how to develop a base from scratch.thanks in advance 

I am trying to create an Automation that will send an email to all records in a View, but I consistently get an error which indicates that the Action does not recognize the email field. Specifically: Job Board TableNew Listing View – New listing (all records with today’s date)Worker Availability Table                  Active List View Trigger: New record in Job Board Table – New Listing ViewAction:  Find records in Job Board Table – New Listing ViewEmail: to all records in Job Board Table – New Listing (field type: email) Testing my action produces the following error report: Invalid email address in the "to" field: <b>Worker email (El Correo de electrónico)</b><br/>theothergarynelson@comcast.net<br/><br/><br/><span style="display:inline-block;height:1px;width:100%;background-color:#999"> </span><br/><b>Worker ema

Hey guys,I am having an issue with a formula field not showing up in a teams message. I have a formula field inserted into the body of the message, the formula is just "Required" or "Not Required" text. But when I test the action the formula field's text doesn't show on the teams message. Has anyone encountered this or know a fix for this?Thanks!

I have some useful Airtable templates and recently discovered that Airtable credits are a great way to use Airtable for free by participating in Airtable's marketing campaign for growth. My question concerns the best way to attract users by making my private Airtable templates public. I have tried:(1) Inviting a user as a commenter. This worked, and I earned the credit, but unfortunately, the commenter cannot copy the base; they can only comment.(2) When I create a public share link, it works as intended; people I share the link with can easily register and copy the base template to their instance. However, I don't earn any credits this way.So my question is, is there any way to achieve what happens in (2) while still benefiting from the credits like in (1)? How can I share the templates with my fans and still earn credits?P.S. I'm not interested in money or cash; I'm asking for Airtable credits. Helping Airtable users and attracting new users to Airtable has been my focus for years. I

I have a tasks table with a self-linking field that I use to define task predecessors. Is there a way when adding a predecessor to filter the options to show only those that relate to the relevant project/grouping?The problem I am trying to solve is that there may be many tasks with the same name so sorting through them to find the correct one takes time. For example, in my task table I may have the following:Project 1:Task 1Task 2Project 2:Task 1Task 2When selecting a predecessor for task 2 I have to wade through and find which Task 1 is the correct one for the project. May be helpful to know: my tasks table has another linked record field that links to a projects table, therefore each task is tied to a project. 

Hi there!As I am fine tuning the AT bases for our team, I seem to be missing something rather important here and thought I would ask the community about it as it seems to be rather significant.As we create tasks and assign to our team members, we would like the team members to login to AT and view those tasks. They can go into the various views but here they see all the tasks. This is fine as an overall project log. But if they then filter this list to show only those assigned to themselves, it seems to run the filter across ALL OTHER USERS viewing this page!If that's the normal behaviour, how does an editor/team member see only their assigned tasks without impacting the rest of the teams' views? Almost all other PM tools I have tested with (Monday, Asana etc.) have a dashboard page of sorts that shows their open items etc. But a personalization filter on the existing views may be enough for our needs.Please let me know as this is a rather important functionality to keep the informatio

Was there an overnight update that make the group headers gradient? Is there a way to turn it off? It is giving me a headache!

Hi there,Is it possible to fetch job titles from Google or Slack without having people being an Airtable userThanks in advance for your help

I’m trying to port over my UPC check digit calculator formula over to airtable but they don’t support “sumproduct”. Here is the formula, can someone help me find a solution in AT? Excel Formula =A1 & 10 - MOD( SUMPRODUCT(MID(A1, {1,2,3,4,5,6,7,8,9,10,11}, 1) * {3,1,3,1,3,1,3,1,3,1,3}), 10)

Hi there,I am looking to create nice email templates on Airtable and send them via the automation function. I tried with Aeropage but I need to pay for it which I rather not do.I also tried with Sendgrid but can't find how to do it once the template has been created.Thanks in advance for your help

I have an automation which sends out entries to the database through email.Error message showed that one of the emails couldn't be sent due to it exceed 25mb.Is there a way to increase the size limit of the email or is compressing the file the only way around this?

Hello everyone,I want to create a linked table that shows columns in one table as rows in another table.I looked at Pivot functionality, but it seems to be designed for Interfaces. (I didn't try it yet, so I could be wrong here)What I'm looking to do should be fairly simple: check the screenshots.Dates in Table 4  should be automatically transposed to how they look in Table 5.In the screenshot I did it manually for demonstration purposes.Thanks!Jan

Hi, newbe to Airtable which is great, except a few nigglesI've set up an Interface for Mobile and viewed it on iPhoneIn Kanban view in the iPhone App it only displays a list of #RecordNumbersWhen you click on a record number then, sure, you can see the whole record, but I want the Client Name field displayed, otherwise the user has to carry a list of #RecordNumbers vs #ClientName with them to know which is whichCan I do this?

Today I am unable to add new rows to my base table on my free account. I get a pop up screen saying i need to upgrade to have more than 5 collaborators. I only have four defined.  Does anyone else have this issue or know what i need to do to get round it?

hi there, i was trying to capture text w the mid feature for text inside a bracket in my title column imported from google calendar however for some reason it's not grabbing it. What should the formula be? The text that needs extrapolating to a different field is within the "[" and "]" [TEST] Restaurant Name: Name of Event. Any thoughts? I'd then like that text to trigger a dropdown menu in a different field.  THank you!  

I have a table of Contacts where one column is the Companies where these contacts have worked. The Companies column is a lookup column to a table of companies. Contacts might have more than one company that they've worked for. I want to be able to attach a year range in some way to the company information, so that I can see that John Smith has worked at Company X between 2021-2022 and Company Y between 2022-2024. What are some ways I can think about doing this?

Hi! I thought a simple formula shown below would calculate price per square foot for my table. {Price} / {Building SqFt} Both Price and BuildingSqFt are columns in my table, so I am not sure why the formula gives me an ERROR response. What formula do I need instead? Thank you!

I have outlined and organized my novel in Airtable. It's a beautiful, perfect system for this. But I want to do one more radical step: actually write the novel. I need a basic text editor window bigger than the one currently supplied for "long text" fields. Are there any extensions or solutions out there? Or hey airtable people, can we get a text editor extension? Please?

Hello, I feel like this is relatively easy but I am stuck. I have automations set up to send out a welcome email each time a project is sold. I have spec sheets and standard documents I want to send with each email. They are standard forms that are the same for each project. I want these to automatically attach to a record when it is created. I have the forms set up as their own table. How do I get Airtable to link these forms whenever I create a new record? thank you

I am using a DATETIME_FORMAT formula to reformat a Date input field and make it pretty. For some reason no matter what time I put in to the Date input field the formula field spits out a time exactly four hours later. Anyone know why this is happening? 

Hi everyone,I am wondering if there is a workaround/solution without using make.com or scripting.I have data in one column for example. The column is a linked field.Items | Qty_to_BuyA|5A|1B|1B|1B|6C|10 I want to create a table with the following output.A | 6B|8C|10It is basically grouping by item but I want the output to show up as separate records. If possible I would like for it to be in the same base but a sync to other table also works. I would appreciate any suggestions. Thanks.

Hi All,So I have a question about the best way to merge data. I manage a scholarship program for a festival that happens once a year. We've been using airtable the last few years to manage the staff, artists, and scholarship recipients. We saw a lot of success converting our emails into Typeforms last year and want to expand on that.We use a typeform application for people to apply and then pull those who are selected into an 'Accepted' View. We intend on sending 4-5 typeforms with questions so we will need to merge their answers into each of their 'Applicant' profile. The typeform will ask for the same email address they applied with and I would use that to direct the merge. This is going to create a lot of multiple 'accounts' and I want to make sure our data stays tidy and manageable. Rundown:1. John Snow is accepted.2. We send out  Typeform 1, 2, 3, and 4 out to John3. John fills out the typeformform as he recieves them, the data is collected and sent into airtable vi