Ask the Community

Hello! I am trying to create a template that will do the following: Any person can "register" an event via the "Forms" link to a calendar. When the calendar moves from month to month, the previous events "drop off" the grid view, while the upcoming events remain. I wanted to know if this was possible? Thanks!

HiI think I've been overthinking this and have brain freeze.Two tables Contacts (all contacts) and Students (people who have been trained, should exist on contacts)Both tables have email address as Primary fieldContacts has a Verification field which I want to show on the Students table for each studentI just can't figure out how to link the two tables! I did the straightforward link and nothing appears to happenThanks in advanceMike

When click 'open' in an interface, why two forms are shown?Sometimes only 1 form is shown (which is what I expect), but often two same forms are shown.Anything I did wrong?Thanks!

HelloI have a typeform with 50+ questions. When I am mapping it to AirTable, I am required to map it field by field - which requires me to go into AirTable and create a header for each individual question. This seems quite cumbersome, is there a faster method that I am not figuring out? Secondly, what happens in the future if an additional question was added to typeform - I assume without it being mapped, there would be data loss. I am doing this for a client and need to ensure best practices. This process also exists in reverse where I've got the typeform extensive from the AirTable database.  Thanks in advance. 

Hi everyone! I was wondering if it's possible to recover lost data after importing bases. When I copied and imported a whole table to a new blank one, some of the data was imported, but some other was lost and I have blank fields now. Namely; the attachments (pdfs). Does anyone know if/how I can recover those at all? Thanks in advance! 

Per day, the employee works 8 hours and can be distributed in one or more projects (tasks) in this period. If he worked on only one project it would be 8 hours allocated to the project (easy), however if he worked on two projects it would be 4 hours each and so on. I need to generate a report of each person’s allocated hours by project. The challenge is that the tasks from different projects overlap for a period of days and I don’t know how to evenly subdivide those 8 hours by the amount of overlapping tasks.

Apologies in advance if this was answered elsewhere, I did try to find it.I have a lookup cell that is pulling information from another sheet.  In that other sheet, the cells all share an attribute called “Daily Flow.” I’m wondering if there’s a way for me to format this cell so that if there are duplicates, (like you see “An insect’s world” is shown multiple times), that it only lists it once?Thanks for the help!

I have been using this formula, and it works: IF({Company (from Distribution Locations) (from Invoice 2)}="Key Fresh 8890",{Cost *1 (from Products 2)}, IF({Company (from Distribution Locations) (from Invoice 2)}="Marathon 16050", {Cost *4 (from Products 3)}, IF({Company (from Distribution Locations) (from Invoice 2)}="Chevron 10255", {Cost *5 (from Products 4)},IF({Company (from Distribution Locations) (from Invoice 2)}="Chevron 3251", {Cost *2 (from Products 5)}, IF({Company (from Distribution Locations) (from Invoice 2)}="Marathon 5", {Cost *2 (from Products 5)},{Cost (from Products 2) 2}))))) Now I want to add another nested IF; however, with "and," it is not working for me. I want to include the following: if(AND({Company (from Distribution Locations) (from Invoice 2)}="Chevron 3100",{Date (from Invoice)}<"03/19/2024"), {Cost *4 (from Products 3)}, {Cost (from Products 2) 2}) When I add this last

Hi,I was wondering if it's meant to be possible to sort the cards manually within each stack in the Kanban element in an interface. You can do it in the Kanban view but I don't seem to be able to do it in an interface.Erik

Hello.I have a cell that we input text and then in another cell that text in converted to an urlIF({LINK}=BLANK(),"","https://example.com/"&{LINK})Ex:CN-349302 -------->  https://example.com/CN-349302  But what kind of formula can I create to convert the text to an url if we put more than one "string" ?Ex:CN-234398, CN-23454I'd like to convert this to https://example.com/CN-234398, https://example.com/CN-23454   T

I need to understand one thing regarding billing per user per workspace. If I am the owner and at the same time creator/editor/everything of 3 different workspaces, am I charged as “one user” or “three users”? There are three of use in the team who will need access to many different workspaces. Will we get charged per email address (even if that user uses 4 workspaces) or per number of workspaces that user uses? I hope this is clear! :slightly_smiling_face: Thank you in advance for your help!

It's possible to "Link/Unlink Records" and "Add records through a form" on Android. But when I login to my Airtable App on the iPhone it doesnt show the X grey button on the upper right corner and the "add Record" button below. I'm using the same account to test the same interface on Android and iOS. Both have the latest version, but iOS wildly has a big difference and lacking in features on the linking / unlinking records.Screenshot from Desktop Interface Editor of what I need:Screenshot from Airtable iOS app that has the "Add payment" button and "grey X" button missing: I also saw that this user had the same problem last OCTOBER 2023 but no one responded since. 

I have a formula in the primary field of my table that combines a Date/time and the name of the brand in the appointment.  Formula I am using: DATETIME_FORMAT({Appointment Time},'MM/DD, H:MM A')&" - "&Brand results are randomly adding 2, 4 and 6 minutes to the time format, ex:04/09, 9:04 AM - Gregory(appointment time is 9:00 am in the calendar column) I'm lost, what am I not specifying that would prevent this? Thanks!

Hi, We have different bases in a single workspace that correspond to specific projects. One tab in each base is the project schedule. We would like to link all of these up in a separate ‘master-schedule’ base that can house a Gantt chart to keep track of our project pipeline. We would rather not have all the projects (dozens of tabs) in a single base. Is this possible with Airtable?

Hi,I have an automation in Make.com that adds a record to a table in Airtable. The connection uses an Airtable Personal Access Token. I have given the token all available permissions in Airtable, but am still receiving the below error message in Make.com:[422] Insufficient permissions to create new select option ""Microsoft PowerApps""I suspect it is because I am trying to add an option to a Multi Select field that doesn't already have this option specified in Airtable. Would appreciate any feedback on where I'm going wrong on the permissioning / access approach - it seems like this MUST be possible.I should add that I am currently on the Free plan; not sure if that has an impact.Many thanksBrett

I've created a dashboard interface and I've added a filter by date.I can do many type of filtering such as "is after...", "is before..." but I cannot filter between 2 specific dates.It seems that a "Is between (exact dates)" filter is missing.There's a "Is within" filter that seems close, BUT it does not allow to select specific dates.Is there a solution to that problem or am I missing something?   

Hi,I would like to use AirTable to store my users table for sign-up and login from Thunkable and Noloco.  How would I go about encrypting the password field?ThanksSteve

Hi everyone, I build an internal tool for a company where they organise their Projects, Invoices, Employees etc. As the Data is accumulating, we would like to get a better overview,, especially in the sense of knowing how the numbers look on a monthly basis. However this seems to be trickier than expected. For example Invoices: I want a summary for each month. Sum ingoing, sum outgoing, balance.Or I have the hours worked by each employee. I'd like a table where I have those numbers for every employeee on a monthly basis. What would be a good way to collect all sorts of data based on predefined (month, year etc) timeframes? I dont want to work with a custom view for each month. I tried displaying the dates as "March 2024, April 2024" but i cannot group by that. I thought about creating a "timeframe" table where every record is one month for example, but then I'd have to link every record (from different tables

Hi there - I’m trying to have an e-mail fire whenever anyone fills in a form. Two questions: I’ve set it up and it just doesn’t seem to be working. The test failed, and when I try creating a record using my own email address, the automated email doesn’t come through. I am on the free plan and there is a notice saying “On your billing plan, you may only email collaborators with verified emails.” - does this mean I need to upgrade for it to work? I this why it’s not working? Many thanks!

I have been using this booking form template (here is the community post where I found it) to try and create a student registration form, but I'm running into some snags. I'm hoping someone may be able to help me. The basic requirement is below (once I have that established, I'll play around and try and make it a bit better). What I need is a form where:Student enters in their student ID.Student chooses a research topic from the list.When they submit, this reserves that topic for that student, assigning their student ID against the topic. I have five topics (for simplicity sake: blue, green, red, pink, brown), and each topic has 25 space

Is it possible to only show a certain Extension Dashboard based on the selected Table view? Whenever I am in Table A, I want to see only the extension dashboard for Table A without having to select and change it every time.

This was asked by another user, but closed without a response. What are workarounds, other than downloading/uploading a CSV, to copy a table structure from one base to another?

Does anyone know why creating or linking records in elements with a linked record source is disabled (locked icon)? Right now, you see this when you mouse over those disabled buttons: This feature is not currently available in Interfaces for elements with a linked record source  Because I do need a linked, filtered, and sorted list element with a record source, I came up with the solution of adding a record picker element, just purely for the ➕ button that isn't disabled. I think the hover message means that the Airtable team is working on it, but not sure what the timing or issue is. Anyone know?

Hello. I am currently on the "Team" plan and by mistake one of our collaborators ended the available automations. Because from this workspace we manage two companies we need to resolve it urgently, although unfortunately after 24 hours of contacting the Airtable Team we still have no response.The recommended solution is to upgrade the current plan. Given that it is a specific situation that should not be repeated, what would be the best way to resolve it? It's okay if I have to pay.1 - Upgrade my current plan to the Business Plan, hoping that this will reset the automation count and then return to my current plan.2 - Since my current plan is annual, if I keep it (not upgrade) but change it to a monthly plan, will this reset the automation count?If you have any other solution I would appreciate it.It seems like a very bad idea to have to change your plan because you made a mistake. A change of plan should only be due to permanent needs of the company

I'm having trouble updating a date field with results from a formula. Please helpMy desired outcome is the following: When the user updates the "last communication date" field, then Airtable will automatically update the "next communication date" to be 7 days after the "last communication date." This allows the user to manually update the "next communication date" if desired but doesn't make that step mandatory.What I've Created:-Editable "last comm" field-Formula field "calc next comm" with this formula: DATEADD({last comm}, 7, 'days')-Automation set to update "next comm" with the data from "calc next comm"Error from Automations Test:"Field "next comm" cannot accept the provided value: Could not convert string to date." The user