Goal: Create a list of email addresses that Accepted a Google Calendar Invite, a list of people that Declined, and a list of people that NeedAction.My Data: I have 2 text fields with my data, called "All Emails" and "Attendee Status" (grabbed via Zap...
Hi everyone!I am trying to find the right approach to calculate the number of consecutive unattended days at course by a same student.I currently have a "participation" table. It is a junction table with: The date (date field) - The Student (link rec...
Your public community profile is where Airtable community members can see the information that you have chosen to share, your community rank & stats, as well as your posts & replies. Keep your profile up to date so members of the community can get t...
Hey all! Working on making Page Designer work hard to create the thing I need A couple of limitations I have run into that I haven't found a workaround for yet:1) Flowthrough to another column. Currently I have this list of information:But I want to...
How a collaborator can view only their records
Hello!Pulled up a list of three dates from a linked table. In this table, there is a separate date on each record. Looking for a way to find the latest of the three dates, that is not later than the separate date in the record. I can find the last...
Hi All, I could use a little insight into what's wrong with my formula.It's scripted in my API, using Airtable.js with Next.js.The following works with only the second two fields, which are multi-select, but ignores (or seems to ignore) the text inpu...
I work in a digital archive and I'm using Concatenate to create a unique naming formula based on certain fields in a spreadsheet. However, some items have different naming requirements. What I would like to do is be able to tell this formula to skip ...
Hi friends of Airtable,DocsAutomator has been growing quite a lot recently and we have many Airtable users automating their documents with it already The goal for DocsAutomator was to create the easiest solution to turn Airtable data into documents a...
I am trying to set up a database of past video shoots, including who worked on them and what position they worked as. I have a table of people, a table of positions (director, cinematographer, producer, audio, makeup, etc), and a table of projects. T...
Hello,I'm trying to design a database that can accomplish the following:Aggregate data across several different entities (for example, cities).Aggregate data for each entity across different time periods (for example, years).Aggregate data for each e...
Hi everyone, Can a record be updated by an external user through an interface button ? Or do you have a link to solve this problem in another way (like a form) if it's not possible. Thanks for your help, François
I'm building out the Airtable to Google Calendar Automation (see this article)It is important for us to hide the guest list so invitees cannot see other people invited or their contact information. There is not a setting inside Airtable automations t...
Hello!For our organization, I'm working on a view/interface to track changes to lists of content over time. We "merchandise" our content for users in sequential order; e.g. Row 1 of content contains Title A in Position 1, Title B in Position 2, etc.....
I've created a script that creates child records in a child table linked to parent records in a parent table through a linked field. It creates a set number of child records per parent record, if a set field in the parent record meets the conditions,...
Hi everyone,Background:I'm in the process of creating a base which is to be used by our company and an external company to share information and update the status of job packs for solar installations.ScenarioI have a single select field called "Job P...
What is the proposed idea/solution?Allow individual rows to expand to fit long text (like "wrap text" in Google Sheets) or at least to fit MORE long text.How does is solve the user problems?Sometimes I want to skim my data (in my case customer emails...
Is there any way we can create custom table, form views using airtable scripting or automations?
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...
I'm having a rollup field which is giving me the latest logged date from another linked table. The rollupfield is used in formular fields where it needs to show the date inserted into some text, but no matter what I do it gives me an error when I use...
Hello Airtable Community! Time for question of the week Be sure to share your ideas in the thread below. We will be sending swag to 3 lucky individuals. This week we want to know what are your tips ...
Announcements
Hi everyone! I'm Helen, a Product Manager here at Airtable and I'm very excited to announce that we're launching the new Record Templates feature to all Pro and Enterprise users.This feature enables y...
Announcements
Hope everyone is having a great week! It was awesome to see the engagement from last week's post about replacing unnecessary tools with Airtable. Shout outs to @Jack_Manuel, @ramonscardua & @Tobias_LG...
Announcements
Hope everyone is having a great week! It was fun reading through best practices from last week's question. Special shout out to @Tobias_LGKR for sharing an innovative idea around a "change log functio...
Announcements
