Ask the Community

Hey guys! I am having issues with resyncing projects from a base sync. It's a back and forth sync meaning I sync the projects from base (Project Tracker) to a finishing base (Internal Finishing) that then syncs back to Project tracker with new information. I currently have an automation to relink the projects to a new linked field in the Finishing Information sync to the project that matches the project name in the project single line field (originally linked in in Internal Finishing base), but for some reason it will sometimes link all the projects to it even when there is clearly a matching project name.When I try to convert the Finishing Information Project link from a single text line to a linked field it doesn't recognize the project names and the field is blank (doing this works with Personnel names, but never with projects). Does anyone know how to prevent have only the correct project link to the finishing info table? Or know of a better way to sync this info tog

i have been using airtable for 5 years. My team uses it quite extensively- particularly for automations. however, for the life of me, i cannot seem to create a useful interface. i have tried time and again. i see the promo videos, where interfaces look amazing. so i go in and try again. and almost immediately, i get bogged down. does anyone have a youtube guide they can recommend?For airtable base topics, Gareth from GAP Consulting has been my go-to guru for years. everytime airtable drops a new feature, i wait for Gareth to cover it in one of his videos, and it all becomes clear. however, even Gareth has failed me when it comes to building interfaces.my team is going to be onboarding a new set of users soon. and i have a feeling that an interface could be a real asset to the new users- so they don't have to deal with ALL of the data and can just focus on the parts that apply to them.any suggestions for guides on building interfaces? thanks!

We used to have all of our employees invited to each base as a user rather than the workspace because we had some bases with sensitive info. We've now moved the sensitive bases to a new workspace and invited all of our employees to the workspace so they have access to everything. However, when we go under Account > Base Collaborators it still shows all of the individual bases that they were originally added to. For managing access it's much nicer to just see who has access to the whole workspace and who has access to only some individual bases as we still have some people that only need base access.It seems the only way to clean this up would be to remove the workspace access, then painfully remove access for each individual on each of the probably over 100 bases we have, then re-grant access to the workspace. Is there any other way to fix this? To Airtable, suggestion that if someone goes from base access to the workspace access to clean up the view for us.

This might not be possible (especially since our nonprofit is on a free plan) but we have a number of projects that require review by our general counsel before they can finish. We have a tab with the start and end dates of each project. Our General Counsel just sent us several ranges of dates when she'll be especially busy and need more time than usual to provide her review.The base started with just the "Projects" tab, with each project's start and end date. I've created a new tab for "Compliance Challenge Dates" with a name, a start date, and an end date. I would like to create a new field in the Projects tab that:Gets the End date of the project.Subtracts three days.Uses the range of dates between three days before the end of the project and the end of the project (let's call it the "last three days of the project")Checks all "Compliance Challenge Dates" tab entries and sees if there's any overlap between the date range of any of the entries and the last three days of the project.I

I need next result - Text & Date. Date should be in format MM/DD/YYYY. But now as a result I have time also. It is not expected result. Formatting tab is not available for this case. Below I attached the formula I use. I would be grateful if somebody helps me to remove time from my formula.   

I have a table linked to itselfA Lookup field type still works fineBut a Count field type always returns the value 1 when in some cases it should be more than 1

I have a field where people can enter a birthdate. I want that to show up on a calendar view in Airtable. Unless the year is the current year, it's not showing up on the calendar. I tried using a formula field but then I can't get the formula field to show up on the calendar. How do I get it so people can enter the actual birthday say 2-6-68 but have it show up on a Feb 2024 calendar view in airtable? Also, do I need to do anything different so that in 2025 it would show up in Feb calendar view?

Hi all. I was wondering if there is a possibility to use a formula to have the quarterly date shown automatically. I want to link it with automations, to send reminders each quarter in the year.Specifically I need this function, to be reminded to collect invoices each quarter. In my case the quarters are as followed:Q1 Jan - MarQ2 Apr - JunQ3 Jul - SepQ4 Oct - DecSo the formula field should automatically show ex. March 31, 2024. With the automation that I would then add it gets triggered once this date is reached. As a result then, once March 31 was reached, the field should update to the next quarter June 30, 2024 and so on. Which should make it easier to track and remind myself/the team to collect the quarterly invoices. Hope this makes sense.

I am trying to figure out how to create a formula that would remove the text before a URL in a field.Example:Website: http://2pillarschurch.comHow do I remove the Website: portion so it just shows the URL?

If I change the default value for a field will the new default value only apply to newly added records?  Or will this cause existing records to be updated with the new default value also?

Good Day, I need assistance with a formula, I would like to count the status of registered learners for a specific project. I tried the Counta formula but the numbers does not add up correctly. It shows for example 2 learners registered against the project code, but none of the learners are registered yet, therefor should show 0? COUNTA({Learner registration status},"Registered") 

Hello,I have 2 columns; 'First Name' & 'Middle Name'I have a 3rd column with this formula which extracts the first letter of the above 2 columns.SUBSTITUTE(REGEX_REPLACE(({First Name}&{Middle Name}), "[a-z]", ""), " ", "")Example: Jon Reginald Mayo = JRMHowever, I want to add a space in between each character, any ideas on how to do this?

I'm a bit stuck. &#x1f605 The end goal is that I can determine how much everyone should be paying in a house depending on the conditions of the room, the minimum price of payment, and the number of people within a room. --Information: I have 1 airtable with different tables. Table one is called: Room (https://airtable.com/appLy4v2lQcr2yxf8/shrBKTdZxtE96rQOr)Within this table, I have 7 rows with different rooms. I have another table that has different conditions where I can rank the importance/benefits of a specific room. This eventually ends up with a total number of conditions which I then have a script that makes a ranking out of that in depending on the specific rooms.Within the Table Room I also have a column that shows he number of people that stay in that room. Then I have another table called: %(https://airtable.com/appLy4v2lQcr2yxf8/shr2ZXmJPEn7Te53l)Where I have a table that only shows the percentage a specific ranking should be paying for. So if a roo

Hi,I am a Airtable newbie and am having a bit of a challenge figuring out how to properly link 2 tables.  Table 1 (Vehicles) stores Vehicle data - Plate, Make, Model, etc. Table 2 (Fuel Log) stores  - Plate, Litres and Fillup DateI would like to include a field in Table 1 that shows the total litres for each vehicle.  I have tried linking by Plate (not sure if that is correct) and can't figure out how to show the total litres in table 1. I would also want to be automatically update the total in the Vehicles tables when a new row is added in the Fuel Log table.Would appreciate any assistance.ThanksSteve

Hello all,I'll be inputting a cost figure in one column, how do I automate a calculation in another column (ideally the same table) to work out the cost price inc VAT (20%)? 

 Hello Community,I hope you're all doing well. I am currently working on a project where I need to create an accounting table in Airtable to manage financial transactions. The table should include columns for "Date", "Amount", and "Event Type", and it needs to track various financial events such as existing non-financial debts, personal financial debts, business debts, and loan transactions.Here's a brief overview of the data I need to incorporate:For the date 2024-03-01:Existing Non-Financial Debt: -15,000,000Existing Personal Financial Debt: -31,000,000Existing Business Debt: -8,000,000For the date 2024-06-01:Startup Loan Transaction: -100,000,000Additionally, for 2024-12-01, there is an event of "Sacrifice" which involves an 80% forgiveness of the combined total of the Existing Personal Financial Debt and Existing Business Debt.And for 2025-02-01, there is a "Loan (Business Closure)" event adding +100,000,000.I am looking to not only input this data but also calculate the total

In our workflow, users can be assigned to the same record multiple times. I need a way to track how many times a user was assigned to a record and, ideally, list the record name to which the user was assigned. Is there a way to do it with automation, or is it better to do it with the formula? 

We run a weekly vege bag program, and I need some help scaling up and improving our record keeping. Members can get their vege bag delivered for a fee, or pick it up.We ask members to commit to being a delivery or pick up, but there are always a few who need a one-off delivery each week.This creates 2 checkbox fields:"regular delivery"and"one-off delivery"On vege-bag day I create a view that filters only "one-off delivery" and "regular delivery" to create my delivery list.However, for tracking payments, we need to be able to see a history for each weeks' "one-off-delivery" (to make sure the delivery fee is being paid), so simply unchecking the "one-off delivery" doesn't work that well. However, creating a new field each week with "Delivery 30 march" and then a new view which filters "regular delivery" and "Delivery 30 march" is cumbersome and prone to human error.This might seem fairly menial, however there are several other pieces of information I need to be able to track si

Hi! I’m creating an automations on Balances table. I need to track all the changes in the table. I have a possibility to create an automation when the record is created or updated. But how can I run an automation (to run a script) when the record is deleted? Thank you!

Dear Community!When creating a timeline view with a "Day" timescale the horizontal axis ranges from 1st Dec 2023 to 20th Aug 2024. Is there a way to adjust these start and end dates of the timeline?I'm trying to make use of the timeline view for planning shifts during an event that only goes for a few days and the massive range on the horizontal axis makes the view basically unusable.Best regardsHenry

Hello, I am brand newt Airtable. So far it has been very good and a pleasant experience. I am a long time user and developer in MS Access. So there is some adjustment. In Access, when you link two tables, you can tell Access that you want to link via one field, but display another. So, I have a table with a linked field to another table. Airtable is showing me the primary key. Is there a way to show a more informative field? I am so used to using primary auto numbers that I cannot break the habit. So now all I see is a record number. I would like to see say the customer last name that is part of that record. Thanks in advance for the help. Best, Scott

Hi everyone,I did see this post but since my table is a synced to google drive I can't change the primary field.Does anyone have another solution to display field data in the linked record field?@ScottWorld ?

Hello, On my Database  I have a table called "inventory".On my work spase i have two users, me as an admin and the second as an Editor user only.In the Inventory table i want that the second user will be able to create his own records and edit them, but cannot edit my records- right now he cannot delete the whole record but he can delete the values in his fields.Is this possible?

Does anyone know the formula to subtract 3 hours from date and time field but... show just the time please? This formula provides the correct answer showing date and time but... DATEADD({Departure Date & Time},-3,'hours') ...when I add this to the formula to they and show just time -- the time is completely wrong. DATETIME_FORMAT(DATEADD({Departure Date & Time},-3,'hours'),'h:mmA') My attempts have resulted in a series of #Errors. Any ideas please? Thank you.

Hello everyone, I have two tables: Pre-production and Production. I was able to make an automation so if I "approve" a project submitted through form to Pre-production table, a new record is created in Production with the same name and info. Now I want to make an automation so if the info in Pre-production table is updated, it will also update the same info in the Production table. But I keep getting an error. What am I doing wrong?