Ask the Community

Hello, I'm creating a fairly simple base to track all of the violations for an HOA board. I'm trying to create a field to calculate the total number of times a house has gotten the same violation in the past year.The Base has 3 tables, "Homes" with address and owner, "CCRs" using 'CCR ID' as the name of the violation, and "Violations" that collects the date of the violation, the 'Home', and the 'Violation'So, I basically need to have another field that counts how many times the same 'Home' and 'Violation' are both in the same row over the past 365 days.I got this to work by using grouping. In the attached picture, the highlighted number is the number I need to get to populate in its own field. Thanks in advance for any help! 

 If a record created in Openings Tracker (table A) is created, then I want to add that record to the linked record field in Summary Tracker based on the fields Opening Distinction and Req Status. The linked record field is pulling the openings record from Table A based on manual addition right now. If the record is created in Openings Tracker, I want it to automatically add to the total number of openings for that Opening Type in the Summary Tracker (table B).

I am using a summary of data connected to a linked record to populate the dashboard. The Youth Care Professional 3rd shift seems to be filtering as two numbers separated by a Comma. I am not sure why this is happening there and not with the others. The fields have the same conditional formatting for all the fields to the right of linked record. Only this one seems to be noting as 2 numbers. 

Hi everyone!I'm trying to set up an automation which is triggered every time I receive an email with a particular subject line. I want it to follow a workflow where Airtable parses through an excel report in the email, extracts the data from the file, and appends it to a pre existing table.Attached below is a screenshot of what I was trying to do, but I don't see any options to extract data from an attachment.Can someone please advise on how I can do this?TIA!

I have a column that fills in the State Abbreviation from Jot Form. The form is a drop-down selection that is the same as my single select column in Airtable. Somewhere new duplicate selections are being generated with new submissions. I am trying to figure out where to even look for how this could be happening. Any help would be appreciated.

Hi there, Is there any way I am able to sync my Airtable contacts with my iCloud contacts so all of the contacts on my Airtable will also be on my iPhone? And vice versa. Without having to do it manually of course. Let me know, thank you.

Hello fine people!Here's what I have and am trying to do... any help would be greatly appreciated!!Customers order a product from us and can choose a recurring subscription - either once a month, three months, bi-annual, or annual.What I'd like to do is have an automation of some sort that would recreate this record so I can add a calendar and have those records show up in the calendar based on the next shipment, creating a new record in my "New Orders" table.Thoughts?

3 dias atrás meu formulário e passou a aparecer essa mensagem de erro cada vez que tento abrir uma landingpage do formulário.Formulário indisponívelEste formulário atualmente não pode aceitar novos envios.Erro: pgl6Y04zOhM7uVuI5 / Erro: pglP0mXbLsfF4KZJn

Hi everyone, I have some set of records that need to be duplicated. At my surprise, there’s no option to “Duplicate” when more than two records are selected. I cannot duplicate by hand because the base is quite heavy, there’s too many records to duplicate and it could cause a lot of errors. Is there a way to do that (a block, a script, an integromat scenario…) ? Thank you

I have the following tables within a base:ProjectsTimesheets, with each record linked to a single project and a single task type (single select field)Estimates, each linked to a single project and a single task type (single select field)I'd like to be able to compare, ideally in a table and chart (multi series line chart?) in an interface, the amount of hours spent on a particular task type versus the amount estimated for that task type. There may be time spent on a task type that did not have any hours estimated for that task type.What is the most efficient way to do that?I could create conditional rollup fields in the Projects table for each task type, but then I'd be on the hook for creating new conditional rollup fields if I ever create new task types. This is the kind of scaling limitation I'd like to avoid, if it is even possible to avoid it. Any ideas?Thank you!

Hi thereI'm trying to set up a base to record relationships between several data sets, specifically: Segment (eg academia, corporate)Sub-segments (eg lecturers, library, researchers) Use cases (eg data management, author screening)Use case groups (eg planning research, managing research)Products (eg Pear Software, Banana Software)I'm not sure how best to set up the base to show their interconnected relationships. For instance the sub-segment of Lecturers, which is part of the Academia segment, uses Pear Software and Banana Software when they have use case of Author Screening, which is part of the use case group Planning Research. Another sub-segment might use Pear Software and Banana Software for different use cases, or they might have the same use case but Peach Software and Grape Software are better for them. Each segment and sub-segment will only have certain use cases and products that apply to them from the overall list.Once I've set up the base, the next step is to get someone to

I wish to use a series of icons to represent the status of a record in a base. How best to do this? If I add a small image in an attachments field it works, but the image becomes a clickable link and opens the image file - not what I want. The icon must be a static element. If I use a "Single Select" field I cannot import my icons.I would appreciate any guidance.

Can anyone recommend a license-free icon library compatible with Airtable Formulas and Interface Text fields? I see them used in templates, but would love to have access to a complete library.

Hi, I love these kind of icons used in table names and fields. How can I find icons like these, especially with this style? Is there a page for icons which Airtable supports?

Vague but important product feature idea 17786It'd be great if we could get a form of breadcrumbs for naviagtion when viewing records, and their subsequent child records.ie) If I am in my record view for Projects, and click into a Task (Linked, Child Record) then into a subtask of that task, it'd be great to be able to see this reflected in a top Nav Client ABC / Project 678 / Ross' Task / Ross' Subtask 46 I know it wouldn't work for all scenarios, but it'd be SO powerful for this type of multi level App buildingRoss

Good afternoon! I’m working on gmail automation and inserting $ amount fields into the content of my message. I’m using the following formula and noticed that the trailing zero is missing for an amount: CONCATENATE(‘$’& ROUND({Daily Rental Fee},2)) Missing zero: How can I get the zero to appear?

Hi,I use a formula field to build a URL to prepopulate a Fillout form, and I send the link via an automation -> Gmail send. The formula looks like this:"https://user.fillout.com/t/random?email="{email&"&name="&name&"&id="&RECORD_ID() When sent out in a mail this becomes a clickable URL. I would however like to have as a "friendly name" clickable link instead. This I know can be done with the [Click here!](https://domain.com) syntax, but I can't figure out how to work that into the formula. Anyone know how to do this? Rgds, Björn

Hi, I have been trying to solve this, and I'm curious if there's a solution. Please see attached screenshot. I'm trying to add a contact within a form in a new interface that I built. How can I achieve this? I can't seem to have a + sign for users to add new contacts. It only gives me the option to choose existing contact. I want to add a new one from there. Any suggestions? Thanks!!!

HiI am very much new to AirTable so this may be a beginner’s question but I would appreciate the help very much. I try to describe the situation in detail below.Context: I am setting up a more efficient lead generation & reach-out tool for sales purposes, automating some manual tasks such as data scraping & email generation. We have 3 email templates that we use, depending on the product that we want to advertise, plus we send to two types of contacts - English or German speaking (i.e. up to 6 different email templates)Goal: I want to set up the process, so that once I have a Contacts table filled, I manually define for each contact which kind of email they should receive and in which language. Then those emails, based on the templates, with personalized tokens (i.e. Hello {Name}, ….) are stored in a new table “Personalized mail”. (then I will use that data to input to Make.com and send these email drafts to my Outlook draft folder).—Here how my tables set up look ideally:Table

I want to launch the first version of my product which essentially let's the practitioner connect their Google calendar, manage their availability at the backend and their clients can book the call from the available slots. Each practitioner can only see information concerning their practice aka data privacy is essential;. How can I go about building a multiuser login without adding them as collaborators? If you're an expert and can help me build this, please reply here. Happy to onboard a consultant who can help build this.

Hey all, so I am trying to create an automation to send over a slack message everytime there is a new record, but for some reason it is not showing the tagger suer properly.I have a table with all the users D05XXXXXXI tried with just the following formats @D05XXXXXX, <D05XXXXXX>, <@D05XXXXXX>.And none of the seem to work. Any ideas what may I be doing wrong in here?

Hi,Is there a way to create a download a CSV button to the interface for users to be able to export the record or list details as CSV? if it can be done, How do I do it?Thanks

I have created a ticket system and have now created an automation that should change a status after 2 days. Unfortunately it doesn't work. I have a date field that contains the date of creation and a condition that if the date is 2 days ago, the status should be changed to "2 days old".

We have a large team and many tables. Each department has their own table "queue". Obviously someone minding the SMS queue does not want to see the paid social queue first and so on. Is there a way for users to change the tab order based on their personal preferences and not be forced to use the base default tab order of all the tables?

I have a table with information about kids on a team I coach. I have a field for their birthdates and use that to calculate their age divisions. I’d like to use a calendar view to show upcoming birthdays, but the calendar view based on their birthdates doesn’t work, of course, because their birthdates aren’t in the current year. Is there a way to do this?