Solved

Hi allany ideas how to solve this problem?can this be doen with the automation or do i need someone to write me script?night shifts should be split per day, if the time span is over the midnight insert a new row with the working times (Hours) on the next day ... or something like that?  Thx!  

I have a field where people can select multiple options. The question is “what are some emotions you experienced” and they can select from 9 options. I want to know how many people choose Joy and Anticipation, whether they’re the only options selected or if they’re part of a bunch of responses. I’ve found several ways to set up a formula field that tells me if someone ONLY chose Joy or Anticipation, but it doesn’t pick up if someone chooses Anticipation and Sadness or Joy and Anticipation together. There are too many possible combinations to realistically set up a nested IF formula. Is there a way to write a formula that will tell me if someone chooses either option, regardless of whether they chose other options too? I have tried OR, FIND, SEARCH, and REGEX, though it’s likely I’m just setting it up incorrectly! If it helps, the data is coming in through an external site via Zapier, so if needed I can change the field type from multi-select to text.

hello every one.Now i am having few risks.My risk iswhen the record is updated or created in wordpress table, that data have to sent to airtable sync.help me please.thank you for any help

Hithis should be simple but i am stuckAAABBWhats the formula for a rollup in a linked table to have "3A, 2B" as a result? thx!:M:    

Is there a list anywhere of the hotkeys for the scripting extension?  Specifically, I'm looking for a hotkey to minimize all functions.

Hi all,I find myself working on things a lot as I understand Airtable.I am trying to do a budget spending, and I have multiple school locations showing the month-to-date spending.I then wanted a table which shows all the schools.The issue is I can only link one table.I want to be able to link to multiple. So I can have all the budgets in one view.Thanks,Judd    

Hi, this notification is showing on my form embedded on my website - "Starting January 31, 2024, Facebook and Web Search will no longer be available as options to upload attachments." (see attached image)Does it mean that users will not be able to upload files when filling out the form? Is there any way I can modify it so users can continue to upload files when needed? Thank you! 

Hi, I’m really enjoying Airtable. First some context, I’m an individual user using Airtable to keep track of various aspects of my life and I am only on the free plan. Onto my question. I have a base that I use to record recipes and use as a meal planner. I would like to be able to generate a shopping list from the recipes marked as going to be used in the next week. In my main table Recipe, are obviously the recipes. I’m using 2 linked fields to two different tables: one for ingredients and one for when the recipe will be used (as that’s the way I found to show multiple dates for one recipe). In the usage table I have a view that shows me the recipes for the next week. I cannot however wrap my head on how I should go to create a view (in any of the tables) that says “show Ingredients matching Recipes where Used date is within the next 7 days”.

I've been reading through several posts about similar topics, but I'm just missing something here. I imagine some of this is due to some problematic base design, as I've been building it as we go but here's where I'm at - I have a table of club members. We are in the yearly renewal time, so, since I didn't have a way to allow submissions from our membership form to update existing records, I have redirected submissions to a new table. As it is possible folks have different emails, phones, etc, and they aren't aware of the formulated member ID I've assigned them in our main table, this seemed the easiest way to collect new and updated form submissions. So, my plan was to do a comparison between are All Members table and the 2024 Membership table - 1. In All Members table, If email exists in 2024 Membership table, update a field to indicate member has renewed2. In All Members table, if a record in 2024 Membership has the same email, compare other fields for any updates3. I

Hey there,I've been trying to achieve the following for a few hours now, but without any luck.STEP 1: I track the time I spend on a certain activity (# session in minutes column in screenshot)STEP2:  I also sum up the time I spent across all sessions (# sum minutes column in screenshot)Question: Right now I have to do step 2 manually. As you can see in the screenshot, I manually add the last session's number of minutes to the existing sum of minutes. I oftentimes forget, and / or make errors.How can I do STEP2 automatically? I just want a column in which the last sessions' number of minutes gets automatically added to the existing total sum of minutes. Do you have ANY idea on how to do this? Seems kind of simple and I'd know how to to this in excel but I can't seem to get this to work in Airtable.Thanks! 

Hello,I have a formula in Airtable which should output "SMS" if certain conditions are met.This formula has worked for a long time and has not been changed. Now I have noticed that something has been changed in the formula function and Airtable indicates that the formula is incorrect. I can save, but I can't find the error that Airtable is referring to. What am I doing wrong in the formula?  IF( AND( OR( {Terminart} = "Hauptuntersuchung (HU)", {Terminart} = "Sicherheitsprüfung (SP)" ), OR( AND( MONTH(TODAY()) = MONTH({Datum nächste Prüfung fällig}), YEAR(TODAY()) = YEAR({Datum nächste Prüfung fällig}) ), {Datum nächste Prüfung fällig} < TODAY() ), WEEKDAY(TODAY()) = 1 ), "SMS" )   Please correct the following errors in the formula: Missing opening parenthesis "(". at line 3 column 9 Missing opening parenthesis

Hey All!I need some help! I'm relatively new to Airtable and currently diving into setting up an inventory/project management system for my team. Our approach involves utilizing Airtable as a combined solution for both project and inventory management.Here's a quick rundown: We've established a "project-specific" base to monitor products that need to be ordered, received, and delivered for each project each product has up to 750 items to keep track of. Simultaneously, we maintain an inventory base to keep track of surplus inventory and items that have been received for a project. For instance, if we need 3 units of product A for a project but have 2 in surplus, we only order 1 for that project.Now, I'm facing a challenge. We want to mark products as received in the project base and have our inventory base automatically update when we receive products. Essentially, if we order 1 unit of product A, I'd like to mark it as received in the project base and have our inventory base reflect th

I am using a form with some prefilled fields. It works great as long as the item name doesn't include certain special characters. For instance, if it includes an "&" anything after the "&" won't be prefilled. So "Mop & Broom Holder" prefills as just "Mop". Some of the product names we have are a bit long, so it can be a pain to have to type everything out. I know why this is happening, but I'm wondering if there is a way to include the "&" in a url and have it be part of the prefilled information. This is the formula I am using in the button that leads to the form.Form URL'&'?prefill_Name='&Item&'&prefill_Quantity='&{Received Qty}&'&prefill_Project+Tag='&{Project Tag}&'&prefill_Date+of+Update='&TODAY()This is the URL that I get from that formula using the "Mop & Broom Holder" and an example...prefill_Name=Mop+&+Broom+Holder=&prefill_Quantity=4&prefill_Project+Tag=ATN&prefill_Date+of+Update=2024-01-25T0

Is there a formula to have a checkbox automatically checked if the current date is later than a specific date field in that record?  We want to be able to sort by "eligible" records and have it automatically updated as each goes past its "eligible date."  Thanks!

Hi all,Airtable Table Newbie, but feel in love.I want to group rows by partial text in the field.(CDPA) Campaign 1(CDPA) Campaign 2(CDPA) Campaign 3I want to group all three above using the (CDPA).I assume it would create a formula row to do this, but I do not know how to create the formulaCan someone help?Thanks,Judd 

How to filter and set condition IF EMPTY?

Hi all!Please tell me, is it possible to change the rights in the interface on a specific entry after the automation has been triggered?I want to do the following:1) I have a Kanban board - an interface in which, when opening one of the records, you can change the status, date, etc.Is it possible to prohibit changing the status or date of this record when a certain status is reached (for example, done) without restricting others?2) I would like certain fields in posts to be edited only by the record author (the record author creates the post via a form)?Thank you in advance and wish you a good productive week!

Hi all, I'm trying to set up an automation using a trigger using a linked record field. What I want is to trigger an email whenever a record has two or more linked records in a field (but not one). Is this possible to set up?For example, let's say the records are individual baseball players, and the field "Teams played for" links to a "teams" table. In Babe Ruth's record, the field would link to "Red Sox", "Yankees", and "Braves". In Mickey Mantle's record, the field would only link to "Yankees". In Jackie Robinson's record, the field would only link to "Dodgers". How can I set the trigger to email for Babe Ruth's record and not Mickey Mantle or Jackie Robinson?

Hi, I'm new here and I'd like to access a previous post I put up with a question, does anyone know where i can find this? Thanks

Hello, I have the following problem of not beeing able to merge Orders in our internal pipeline. We are getting Orders from our Hubs for Equipment, which need to be packed and shipped in batches. The Script should be able to merge same items ordered for the same Hub multiple times or split if different items ordered. I created the following 2 cases to make the request visible. Case 1: different itemsInput Table "Input Rider Gear Orders"View "Pending"Order 1Column: "Order Number" Value: "17884"Column: "Hub Code" Value: "nl_til_west"Column: "Full Name (from Master Data combinations)" Value: "Winterset - Male - M"Column "Quantity Pick" Value: "1"Order 2Column: "Order Number" Value: "17984"Column: "Hub Code" Value: "nl_til_west"Column: "Full Name (from Master Data combinations)" Value: "Winterset - Male - L"Column "Quantity Pick" Value: "1"Output Table "Rider Gear Output Test"Column: "Hub Code" Value: "nl_til_west"Column: "Pick 1" Value: "Winterset - Male - M"Colum

When importing a CSV with a multi-select column, Airtable will always detect commas as a separator and make tags from it. But in my case the tags contain commas I don’t want to have as a separator. Do you know any workaround to either avoid thos specific commas to be detected as a separator, or change the separator character ? Thanks !

I am wondering if anyone has encountered this scenario below.We have a team of graphic designers that will submit a form to the retouching team in Airtable.Sometimes, the initial request needs to be changed and we are looking for a way for the designers to be able to re-open the request.Most designers are not in Airtable and no designers are allowed within the Retouchers base.Does anyone have any thoughts on a way of re-opening a request without having users in Airtable? 

This list sorts correctly:why is 'b' coming after 'c' in this list (same table and list view)The remaining items in the list sort correctly.Any clues?

Hi community, I'm wondering whether syncing attachments from one base to another will take up space in both or only accounts for the origin base? Is it the same of data library sets? Thanks!

Hello,I have a table. In the table there is a column named "Status" (single select field) with different selection possibilities. ("Property1", Property2",...).In the table is another date/time field.I want that when the status in "Property1" is changed, record the time of this change in the date field.How do I do this?Thanks!