Solved

Hello! Thanks in advance to everyone.I'm wondering how can I create a formula which allows me to know if an event has ocurred the past week, but I don't want the event of the past 7 days, I really need the past week. For example: if today is wednesday I want to know what had happened between the monday and the sunday of the past week.I have done it by this formula: IF(DATETIME_FORMAT(SET_TIMEZONE(NOW(), 'Europe/Madrid'), 'W')-1={EVENT WEEK}, 1, 0), but the problem with this formula is that it is not going to work the first week of the year, because, obviously, that is the 1st week and the last week is 54 so the formula is not going to show the "1" which filters the view that I've created with that condition. I dn't know if I've explained well. My english is not as fluent as it should be. Again, thanks in advance.

Hi all! I am back looking for support with a formula to return a date based on a "created" date and a variable.So far I've been trying to get an IF statements with a DATETIME_FORMAT included to work, but I'm making no progress...My Goal: Create a column that shows an Estimated Pickup Date which is either 11 days after the created date, or 6 days after the created date if the "rush" checkbox is ticked.This is what my columns look like:Any brilliant minds out there who can point me in the right direction?Thanks in advance!Devon

Is it possible to create conditional views of events in Calendar View?I'm trying to build a publicly-accessible calendar of events. Some events are open to the public. Others are private. For private events, I want to limit the information about the event (just showing that something is taking place on a date during a specific timeframe so it's known that time is unavailable). For public events, I'd like to show information about the event (I have Event Title and Event Description fields in my table).So there are two overall goals:Show all events so that viewers know those times are unavailable to rentFor public events, show some details about the event.

I am the owner of a workspace with pro licens and I want a user to be able to add values for selected records but nothing else. After some time I want to lock the values. Can this be done? In a base there is a table that allows only creators to create/delete records. The table contains sensitive data in a specific field. A view of the data filters out, say, data belonging to March and is named “march-data”. The view is locked A user with permission “Editor” is granted edit permissions in the specific field. The user can now add values in the specific field in the march-data view — great! But The user can go to the filter and “duplicate as personal view”. In the view “march-data copy” the user can change the filter to display, say, February. Now the user can change all data belonging to February — not so great! If the user has permission level “commenter” the user cannot add any values — not so good. I am stuck in between two permission levels. And I don’t think my wishes are overl

I have a product that expires in one year. If they purchase an upgrade, it extends the expiration another year. The records are added individually to Airtable. How do I say IF this email address has product A, check to see if it also has product B in another record?

Hello! I am trying to figure out a formula to help me calculate a score for a multiple select field. For example, I have 6 different issues to choose from. If they select “no issues” I want the score to be “20”, if they select 1 of the issues, I want the score to be “5”, and if they select 2 or more of the issues, I want the score to be “0”. Is there a way to do this with a multiple select field? Thank you in advance!

One of my workspaces is showing 1.3GB / 1GB Attachment space used, so I deleted some Photoshop files that I don't need in there (as I have them saved in DropBox) and it's still showing up as 1.3GB / 1GB Attachment space. Why won't it refresh with the new, correct attachment space number?

Hello community,what do I wrong? 🙂 I have a field with #Numbers f.e. 80 or 80,1In another field I try to format this field to a url format, that means I would like to replace the , with an -.For this I use the Substitute formula:SUBSTITUTE({Numbers}, ",", "-") No matter how I format the Numbers field, I always get #ERROR! Can someone help me with this 🤗 Many thanks in advance!

is there a way to copy records between tables in different bases or how to switch the current base a little example would be helpful thx

Hi Folks, I've been trying to come up with an elegant solution to this and am hoping the community here can help me. I have several fields of checkboxes marking different assets available in our library. I would love to create a signal field that would list which fields are still unchecked. Is this possible? I've tried a few variations but nothing is working. Thanks!

Thanks in advance for any help, I am new to Airtable and to using formulas at all. Having trouble figuring this one out, but I’m sure it’s a simple solution. Context: I grow mushrooms, 3 different strains (K, B, L). Every day I prepare a new batch (8 bags, same strain). Every week I prepare 5 batches, 1 batch per day, mon–fri. I need to create a unique record for each batch. Currently, I am using a concatenate formula to combine the strain code (K, B, or L) with the week number it was created. i.e. K.40 My Problem: 2 days of the week, I will repeat the same batch (strain type) I did earlier in the week, which leaves me with two instances of the same thing (K.40). I need a formula or combination of formulas that can identify when the same batch code has appeared twice in one week, and then assign only the second instance of that occurrence with a (.2) i.e. K.40.2. See screenshots below for reference: Screen Shot 2020-10-05 at 17.25.41|700x451 Any help is appreciated, Thanks a lot

I'm trying to do this exact functionality from excel, within airtable: Dependent Drop Down Lists Essentially, the single field drop down list will update depending upon the input to another field, as seen below Fruit & Vegetable have two different list options. Is there an easy way to do this, maybe through linking back to a key in another table? Any suggestions help!   

I’m trying to create a formula field which calculates the number of days in a specific month between two dates. For example, the date range 2020-01-27 to 2020-03-12 has: 5 days in January 29 days in February 12 days in March So in a formula field calculating the “January Days” between the two dates, the value would be “5”. This has me utterly stumped, can anyone help?

I have a button automation that sends a message to Slack. In this message, I'd like a filtered list in the interface to be included, how do i do this?

Hello'I am trying to create a table 'Customer Interested Events' which maintains basic customer information (customer e-mail is PK) and additional fields  (selectable fields) 'Event Category' , 'Event Location'.Based on the customer interested events another table 'Event Manager' would be populated which is linked with above table 'Customer Interested Events'. Purpose of this table is to assign a suitable manager against each Event Category. The PK in this table is a computed field "Event Category+Location" and has additional fields like 'customer name', 'location','event category' (lookup fields from the linked table), 'event manager'.I am trying to maintain one unique record against each (event category, location) with all corresponding customer names, locations merged in the respective fields (if multiple customers booked for the same event category, location) so that one manager can be assigned.While merging customers against an (event category,location), I could see PK 

Hi! I'm pretty new and having difficulty figuring out the logic of how to write this: (single select) Status = "review 1" or "review 2" (Long text) Feedback must not be blank If the above is true then it should provide an output of - "Ready!"And then preferably the errors can drill down to the exact issue..If the status is neither of those - Error, wrong status! If the feedback box is blank - Error, missing feedback! This seems simple but I can't seem to figure out the correct formatting to return correct results. Help appreciated 😄 

Hey everyone,I am slowly moving forward in my airtable scripting journey. What a ride so far. I would need some advice on best proceeding to finalize my script.Context:I created a script triggered from a button, to match client records with potential real estate properties, based on a set of preferences such as the number of bedrooms, the type of view, or some house features. The script does the following steps:- Fetch the criteria value from the record used for the automation (the client)- for each record in my property listings, it calculates a base score for each criterion (0 to 10)- It applies a weight point system to the criteria scores and outputs a Total property score (normalized from 0 to 10)- I then slice the top 10 properties and link the IDs to the client record under a specific linked field. Can't lie, as a no-code person, it took me a few days to get there.Currently, the criteria weight points are fixed, and stored in a const. This works but some extra flex

Can anyone spot any glaring mistakes in this formula? The more expressions I add on, then it 'saves' but then overrides with a simpler version of the formula... so assuming there's an error but I'm not seeing an error message and it's infuriating me (facepalm)There are some fields that need to reference themselves if they are not empty, the rest need to refer to another column if column A contains ***OTHER CHARITIES*** I've been going round in circles for a while now and losing the will 😄 IF({Charity Selection -Series and Challenge Charity Partners 2024}!='', {Charity Selection -Series and Challenge Charity Partners 2024}, IF({Charity Selection - Mixed funding 2024}='***OTHER CHARITIES***', {Other Charity Selection - Mixed funding 2024}, {Charity Selection - Mixed funding 2024}, IF({Charity&

Hi Everyone! For our base, we do a lot of emails out to external people (students, contractors, etc.) . We generally want them to reply to our emails and so we set up other automations to bump them if they do not fill out a form. One issue we have is that often times people will reply to our email but not fill out the form. We're not currently able to address that - and so have to manually record that they've replied in the base so that we don't bump them. Has anyone found a workaround to track "email replies" such that we don't keep bumping them? I know usually this is done by attaching some sort of cookie to an email or similar. I know this is possible in Hubspot sequences, but I haven't found a similar solution in Airtable. This would be a big win if we could have something like this! 

Hi everyone,I was wondering if we would be able to automatically add an URL as an "URL-Attachment". This way I would be able to fetch a QR Code image and have it in my table.I could not find anything online. Unfortunately I can't install extensions that are not directly from Airtable. Thanks for your help,Eren 

@Sho answered my first URL audit Find formula question: My followup question/challenge:I want to clean up (not just identify) the {Link URL} field and join it with {reftag} field:Addmissing https://and/or missing "s" in http://Removeinvalid characters; e.g., ' §the following querystrings:?ref= ?ref_=&ref=&ref_=Then join two fields ({Link URL} & {reftag}) based on logic:If {Link URL} Does NOT contain '?' append {Link URL} with '?ref_=' & {reftag} fieldIf {Link URL} contains '?' append {Link URL} with '&ref_=' & {reftag} fieldHere is the original solution used to callout errors in the {Link URL} field: IF( {Link URL}, IF( OR( FIND("http://", {Link URL}), NOT(FIND("https://", {Link URL})) ), 'missing https, ' ) & IF( FIND("http://", {Link URL}), 'missing https, ' ) & IF( FIND("ref=", {Link URL}), 'remove ref=, ' ) & IF( FIND("ref_=", {Link URL}), 'remove ref_=,

Hey! Thanks in advance for the helpThis is my problem, and I know how basic it sounds but I haven't been able to get this done! I'm creating an automation and Im setting it up so when a record matches a condition (WPM (numbers column) is not empty AND is less (<) than 35) updates a record (Candidate stage (simple selection) to --> Rejected)But what it does is its sending all numbers (less, equal, higher) to Rejected except when WPM is empty (at least that worked) I've troubleshoot as a maniac and nothing seems to work out - Any idea?

I am confused. I set up an UPDATE RECORD AUTOMATION that seems to work in my 2 test tables, but it still creates error messages sent to me by Airtable.I have two tables to test this: The first one is CONTACTS MAIN with the following fields: This is the second table: CONTACTS AUTO with the following linked field and lookup fields. This is an alternate version of CONTACTS MAIN with EMAIL as the primary field, which I need for certain tasks. The second CONTACTS AUTO table links to the primary NAME field of CONTACTS MAIN and pulls in all the other information as lookup fields.I need to keep the two tables in sync. So, I created automation. Whenever I add a record to the main table, it creates the same record in the second one. I also set up an automation that updates every record in the second table that I tweaked in the first one. This automation also works, but it creates Airtable error notifications.Would someone with automation knowledge be kind enough to review what I did? I

Hi there,I want to create a new field called "Original Start Date" and this will be populated from the "Start Date" field when someone enters in a new project.  Like a lot of projects the Start and End date moves a lot.  We want to reference back to when it was first originally entered in.Where do I start?  Do I create a new field in the "Projects" table called "Original Start Date" and then create an automation the populates this from the "Start Date"?I was referencing this article that mentions creating an automation.But I don't know the steps in connecting the two.Any help is greatly appreciated.Thanks!

Hello! Can you plese help me with automations and billing? I switched to the Pro plan and cannot run the script.