Ask the Community

Hi everyone,I keep having an issue with the URL to the attachment script. It works great for some links but there's a URL that keeps having the same issue: the script runs, it shows a gray icon, and then it automatically deletes the data from those cells. The URLs are public so that shouldn't be the issue. Some examples URLs that don't work: https://www.houseoffraser.co.uk/images/products/70936105_h.jpghttps://www.houseoffraser.co.uk/images/products/70582103_h.jpghttps://www.houseoffraser.co.uk/images/products/70080203_h.jpgSome URLs that do work:

I have my personal access token with all the scopes, but when I try to create a new entry the  api is returning this error:          "type": "INVALID_PERMISSIONS_OR_MODEL_NOT_FOUND",        "message": "Invalid permissions, or the requested model was not found. Check that both your user and your token have the required permissions, and that the model names and/or ids are correct."  

Hello,I need to send through an API call the record and base id. Please find below the script I have made, I need know to send the baseID in the payload.Can you help me guys ?  let url = "https://hook.eu2.make.com/xxxx"; // Remplacez ceci par l'URL de votre webhooklet inputConfig = input.config();let payload = {// Ici, construisez le corps de votre requête. Par exemple :"recordID": inputConfig.recordID,// Vous pouvez ajouter autant de clés/valeurs que nécessaire.

I have two bases: Contacts and Matters. In Contacts, there are two tables: People and Companies. In Matters, I have a table (Matters) with a field for Clients. I know i can sync People and Companies to the Matters base. However, is there a way to link the records for People and Companies to the Client field? I only see a way for one or the other. 

Hello,I have a client base that needs to be shared and synchronized with more than three different bases in a one-way sync (from the client table to all other bases without allowing any modifications to the client data from those other bases). I noticed that there's only an option to sync it to one base. Is there a way to sync it to multiple different bases?Below is the schema I wish to build: 

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). Doe

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? than

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

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 col

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 Deb

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 me

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