Ask the Community

Hi folks,I've got employees that submit their timecard for every Friday of the year, so roughly 52 records for each employee all with the same date interval between them (1/3/25, 1/10/25, etc.). Many employees forget to submit a timecard for several weeks out of the year, so I would like to create a view/interface where each employee can see the weeks for which they forgot. I imagine it would be something where AT would compare the weeks/dates they should have inputted versus what they actually did input, but only displaying the difference between them, i.e. the missing dates. Is this doable in AT?Many thanks in advance.

It would be nice to use a windows tablet to input records but the scroll bars appear to be locked in position, has anyone had this problem and is there a fix or a setting to alter, tablet is a Lenovo yoga 2 running Windows 10, Regards Andrew

Is it possible to make an automation to send out an email every third Monday of the month? I was only able to find ways to send out the email every certain day or time of the month, but not a specific third weekday. Thank you!

Hi everyone,I’m trying to update the list of select options in the column Categories_test in an Airtable table using the API. My request seems to be correctly formatted, but I keep getting an error response from the server. I would appreciate any guidance on what might be wrong.Here are the details:PATCH Request:Endpoint:  PATCH https://api.airtable.com/v0/meta/bases/{baseId}/tables/{tableId}/fields/{fieldId}  Request Body:  { "type": "multipleSelects", "options": { "choices": [ { "name": "test" }, { "name": "blabla" } ] } }  Headers:  { "Authorization": "Bearer [ANONYMIZED_API_TOKEN]", "

Hey everyone!I’m running into a challenge while using Airtable in conjunction with Fillout forms. When using the duration field in Fillout, it only provides the exact times (start and end) rather than a length of time in between. To simplify things, I’ve limited entries to a start time and end time, assuming the event will occur on the same day.Here’s what I’m trying to do:•I’d like to create a formula in Airtable that takes the start date (provided in a date field) and combines it with the end time (from the duration field, which doesn’t have an attached date).•The goal is to format the end time as part of the same day as the start date.For example:• Start Date: 2025-01-14 08:00 AM•End Time: 10:30 AM

Happy Day to all, can't wait to see the group support for something I'm missing.Info: I have created an automation to post to Facebook. I have trigger set to run once a day, with conditions = 1 based on formula in field.I need help on the Actual Message to post.I hit the blue + and added Copy field and it only posted the actual field ID on the text post.Not the "Contents" of Copy field.I also am getting an error on the attachments field when adding the ContentImage field to send over the "picture".I have scoured through the forums and on youtube, but I seem to be missing one important step of HOW TO ADD to the message content in Actions Section.TLDR: Need help with the Message Section of Post to FB action.

Hi,I was wondering if it is possible to create an automation that uses Airtable's own notification system. We use the interfaces for working all the time and it would be nice if we could get a notification if a certain cell reaches the date of today.

I'm looking at using airtable to use as a database for my startup as airtable provides simple implementation and data management features that make setting up data management simple.However there is one blaring issue that makes this difficult and that is the fact that you cannot set an exact number to offset your search by.I can work around the fact that you can't directly search by linked records by id or other parameters and have to use lookups and formulas to make this happen but not being able to offset makes me consider using another service.If you could setup something like this you could be very popular with startups as we need something quick simple and powerful to get our MVPs up and running quickly so we can test the market.

I have a database for our retail stores. The main table's first column is a formula that combines the store's name and the store's number with a " – " in between. For example, "1234 – Joe's Discount Hardware".I need to import data from a report that only has store numbers. I know could use the CSV Import extension by setting it to merge with existing records and set the merge field to the store's number.However, where I really need it imported is into another table in this base. This is where my roadblock is: Since the linked store identifiers are "1234 – Joe's Discount Hardware" but the report's identifiers are "1234", is there a way for me to link them?I did try bringing in a lookup field that show's the linked store's store number. But it can't use the lookup field as an identifier. Then I thought I'd found an answer by making the table's first column be =storeNumber. However, when I tell the extension to merge

This is a question that has been asked a few years ago but not sure if this has been revisited recently.I am using Airtable interfaces. I am on top level plan and prepared to pay to remove the Airtable branding. There is a simple reason why.Our portal goes out to our key stakeholders and partners. As soon as they see the Airtable logo they start to try and work out how we build the platform, then instead of seeing the great outcomes that we are delivering, they start to try and build their own or they deconstruct the environment. It is very disheartening when you have spent a month making a great interface, and the first and last thing the partner mentions is "Oh thats Airtable, can you show me how you did that I need to do that for that thing that I was going to get you to do for me . . . . . so I will now go try to make it myself, I mean, it's just Airtable"The solution shouldnt be to go use Softr/Noloco etc and  money for

Issue with Embedded Public Sharing Interface on MobileI created an interface and set it to public sharing. After embedding the code into my website, I noticed the following behavior:On desktop: Everything works perfectly. When I enter the password in the pop-up window, the main page refreshes and displays the correct content.On mobile: After entering the password, the content loads inside the pop-up window instead of refreshing the main page to display it.Has anyone else experienced this issue? Could this be an Airtable system error, or might it be related to my website settings?

I am wondering what Record comments can be used for. It looks like Record comments aren't accessible by formulas, automations interfaces, etc. That is, I can't create a formula that tells me if there are comments, that returns, the comments, etc. I can't rollup all comments of a record. I can't write an automation that emails me when a comment is made in a record.Is that all true — are comments really this isolated? If so, I wonder why the heck they exist — nothing in airtable seems this isolated. 

Hi all - I've got a couple different interfaces (one kanban, one list) where I want the info to be visible only to the assignee and their manager. I know how to make it only visible to the assignee (filter by Assignee is Current User) but where I'm getting stuck is allowing the manager to see all tasks regardless of who they're assigned to.For example - Jordyn is the boss of Michael & Isaac. I want Michael and Isaac to each only see tasks assigned to themselves, but I want Jordyn to see all tasks assigned to either Michael or Isaac.This feels like it should be simple but I can't figure it out. Again, I'm having this issue on multiple different interface elements across different bases.Thanks!Kelsey

I have a single select drop down field, and use an automation to copy that dropdown field into a linked record field anytime it is updated (see below). I have the system to clients can use the dropdown in forms, but I use the linked record in the backend for my own uses.There are actually two of these, one for Federal and one for State electorates. Each have their own single dropdown field, that automates over to their own linked record field. Both linked records link to the same table, but obviously different columns.However, in the table where the linked records resides that are multiple cases of records with the same name. For instance, there is a Federal electorate called Adelaide AND a state electorate called Adelaide. Each record has a number of other fields (such as state, level of government, etc) and I use the Group function, so that it's clear and easy t

Hi,I am running network managing research participants for my organization. They have two options for signing up, which are in separate tables. One is the 'Full Sign Up', which is in my main participant table, where I am linking other information not related to the form. The other is a 'Sign Up Later' form, used when recruiting partipants who don't have time for the full form (fx in person at a conference). They sign up with their name and email and I have created an automation to send out a link with full form. I'd like to create an automation that sends out a reminder email those who have completed the 'Sign Up Later' form, but not completed the 'Full Sign Up' form, to do so. This means I need an automation that removes those who have completed the 'Full Sign Up' form, from the 'Sign Up Later' table, but I am unsure how to do that, since the tables are not linked.  Any help is appreciated 🙂

Hi there, New to AirTable and was wondering if there is a quick way to convert rich tex to html in AirTable. Is there a script that will do that? Or any other solutions? Thanks.

Hello AirTable Community!Hoping someone can help me with a solution here.  I have a conditional form that depending on the department you choose, you get different prompts - most of this works great.  Here's the problem:I have a Lookup field that provides instructions by the department that I would like to appear once someone selects the specific department.  i.e.: Person selects Finance request time - they get a block of text that talks about what finance needs and SLAs.I have tried doing this via a Lookup Field (apparently, you cannot use those in forms), and then I tried a really long formula, but I cannot use formulas in forms either.Looking for a native solution, not a 3rd party plug in because we would not be able to clear that with our IT team.

I was trying to make a form that was sort of an order form and my formula field with the total cost of the items wasn’t on my form. I had no way to add it. I tried on a form for another table that was similar and it didn’t work there either. Is this not currently supported?

Is there a way to use HTML tags in a Form? Also can a form be configured so it is viewable in full screen. I’m planning on creating a form that contains LOTS of verbiage and several input boxes. The data from the input boxes is emailed/saved when the form is submitted but the verbiage does not get saved.

Hi All,somehow one of my forms, accessed through a QR is asking for an email address to access it.all the other ones aren't, but this is. It has been working ok for at least a year.has someone changed the settings, if so how do I fix? thanks 

I have a basic CRM with 2 tables: 1) "Contacts" (persons) and 2) "Firms". Each Firm can be associated with one or multiple Contacts (linked records).In the Firms table, I have a "Firm Type" column that is multi-select from a predefined list of values. This predefined list can never be exhaustive enough to capture all types of firms. In the table view, luckily I am able to type new values and Airtable saves it as a predefined value for later use.I am creating a "Record view" interface for Firms. I want to allow users to create new firms on the interface.  When I allow users to do so, airtable's standard form loads up. Unlike the interface, the form is not allowing users to "add new options" to the "Firm Type". However, if users wanted to edit an existing record in the interface, I see an option to "allow users to add new options". How I can access this option in the form? 

I am trying to add a new option to a certain column. I use my airtable as a form to collect applications from users, but I need to update the “Session” of what they are applying for. I can’t see to add a new session that would indicate that they are applying for the next era. The only possible data that can go in this column are “Session 1” and Session 2," while I want there to be “Session 3.” The “Customizing the field type” (can’t post links here) guide might help me, but it shows menu functionality that I don’t see to have. Any ideas?

Hello Everyone,I was wondering if you can help me with something I have been working on. I currently have 3 tables in one base. One table has different names of clients (Table 1). The other table has the names of projects they are attached to with a record ID through a formula (Table 2). In Table 1, I have a linked record column to link each client to a project and there is a lookup column as well that shows the record ID of the project. Finally the 3rd table is used to store data from a form. In the form, I want to be able to have a linked record (select a client from Table 1), but I want to filter the options in the form under the linked record, so when filling out the form for one project, only clients linked to the project will show up as an option, so this could be a filter by the recordID of the project if that makes sense. Views will not work for my use because Airtable does not have a way to dynamically filter the view by different record ID's without creating a new f

I have a base with a field "Company" that is a linked record.Ultimately, I want to pre-fill my form with all values inc Company.First, how can one pre-fill a Linked record field? Seems like it isn't possible.Second, even if it is possible, how can I allow the creation of a new such Linked record from the form?

Hi, I have a field that references the customer table. When I work in grid mode, it gives me the opportunity to add a new record in this field, however if I create a form and enter this field does not give me the option to add records.How can I enable this option to add records in a link to another record field in a form?Many thanks for your help