Solved

I need to calculate the number of days a ticket was open, but excluding weekends.However, Airtable wont let me change my work days to be Sunday-Thursday.What formula can I use as a workaround, to count all days of the week minus every Friday and Saturday of the year?

Hoping someone can help, I saw in Airtable's 'What's New' update in July that if a formula returns "a boolean (true/false), a new formatting option lets you output the result as a checkbox instead of a number". This would be really useful for me, but I have tried multiple ways to do this and have not sound it possible. I know Airtable's checkboxes mostly use 1 for checked and 0 for unchecked, so have tried outputting formula as a 1 or 0 for true / false, but no luck (tried "1" / "0", "true" / "false" etc too). Here's the screenshots from the 'What's New' page, if anyone has had any luck with this, help would be really appreciated. Thanks Matti 

Is there a way we can share a link to an interface but either:1) Is password controlled but does not require registration to Airtableor2) You can register but it has to be to a custom designed pageI saw this: https://airtable.com/invite/l?inviteId=invYu3ePl9Fdnqzlm&inviteToken=4ebae32984cd6868bed1d98b72df6d7b948b05e06eed6c7fc0fa24055192010f&utm_medium=email&utm_source=product_team&utm_content=transactional-alertsIt was marked as completed but wasn't really!

Hi Airtable Community.Now, I use "When a record is updated" trigger in my automation and I want to use only the data of updated field for sending notification to my team member.Concretely, my table has 3 fields which are "Assignee_1", "Assignee_2" and "Assignee_3", and when someone update one of these 3 fields, I want to send the notification to only the member written in the updated field.However, I don't know how do I get only updated field data.If you have any good solution, please let me know. 

hola necesito saber si puedo cambiar estos datos por otros

I was hoping to put a youtube video in attachment but the URL says it can not be found. Tried a few different videos with different style URLs with the same not found error. Is there a easy way to add video or will I just have to add URL to the video? Which is fine, I just wanted to know if I could embed it without link or downloading, so I thought I would ask.

Hello!I'm new to automation and trying to figure out how to copy data from one field to another when one field is not empty and the other is empty.I have a Tasks Due table and a Reminder field that is a Dateadd formula which calculates a date from data from another linked table. I want to copy that Reminder field and paste it into my Date Due field if the Reminder field is not empty and the Date Due field is empty. Can anyone help? Screenshots of how I currently have it set up. I've tried changing up the conditions, Record ID and field but can't get it to work.Thanks so much for any help you can give!

How can I automatically generate a new record ID in Airtable that continues sequentially from the last number in the existing data?

Hello!There are a LOT of posts regarding the popular error of "Received Invalid Input" but in my search I didn't find anything that was specific to the conditional logic of the automation being the area that returned the error.I've created a video to show how the conditional logic works when the list properties length = 1, but if it = 0, then the conditional logic check returns the "Received Invalid Input" error. Any help is appreciated.

I feel like what I want to do is very simple, but honestly, I'm wasting a lot of time without succeeding. My level of incompetence is quickly reached.So, I have in my Table 1 a Date field and a field that I'll call field N. In my Table 2, there is also a Date field and a Number field.I want AirTable to find the corresponding Date in Table 2 for each record in Table 1, then return the Number field and enter it in the N field of Table 1.I've been searching for the function, but I can't find it. Does anyone know how to do this?"

Hello, I’ve been trying to work this out for hours but I’m afraid my knowledge of airtable formulas is quite nascent. I’ve got this current formula: IF( {Due}="", “”, IF( AND( DATETIME_DIFF({Due},TODAY(),‘hours’) >= 12, DATETIME_DIFF({Due},TODAY(),‘hours’) <= 48 ), “Due Soon”, IF( IS_BEFORE({Due},TODAY()), “Past Due”, IF( IS_SAME({Due},TODAY()), “Due Today”, “Upcoming” ) ) ) ) Which gives me different values depending on how much time is left in the “Due” column. I’m trying to add another variable that says that if checkbox column “Done” is ticked, disregard all the above formula and return value “Complete”. How can I go about doing this please?

Hello,I have a table containing information about clients: surname, first name, end date, etc., as well as the number of hours sold. In another table, I have the tasks for each customer with the number of hours used.I've created an interface that summarises the job information by customer. At the moment, I need to filter by customer to display all the tasks, but I also want to see the number of hours sold directly in this interface.However, to obtain this information, I need to apply two filters:Filter 1 on the Tasks table to select the customer. Filter 2 on the Customers table to retrieve the hours sold. Is there a solution to avoid having to filter twice?

I have been trying to develop a formula to output the amount of work hours between two date/time fields. This is for a base that has Time Off requests for employees.I have a field with a start date like this (9/16/2024 10:00am) and a field with an end date like this (9/28/2024 3:00pm). What is a formula that would calculate the amount of work hours between those two fields, assuming:Work hours are 8am to 5pmExclude 12pm-1pm if the span crosses that time period, since there should only be 8 hours between 8am and 5pmExclude weekendsIdeally, and I realize this is a tall order, it would exclude New Year’s Day, Independence Day, Memorial Day, Labor Day, Thanksgiving Day, and Christmas Day for say, the past 5 years and next 5 years.This has been driving me crazy for a long time, and I cannot come up with a reliable solution, even with ChatGPT. Can anyone help?

I'm trying to determine from the API whether a table is hidden or shown, but looking at https://airtable.com/developers/web/api/model/table-model there's no obvious field with that information. Is there another API that has it?

Up until yesterday, when I changed a filtering option, the table would automatically update. Now it doesn't and I have to hit apply to see the changes.I use filtering a lot to test my data - I look at a summation field and check, for example, what is the result when field X >1? >2? Etc. With the filtering dynamically updating whenever I changed it, I'd get instant feedback. Now it's a real chore, not only do I have to hit apply, but the filter box goes away and I have to reopen it, go to my filter choice, and enter my next value to test. Am I missing something? Is this an intentional update? Thanks!

Amazon की वेबसाइट या ऐप पर ऑर्डर की स्थिति देखें। Amazon ग्राहक सेवा से संपर्क करें:0 9934 29 5505 या 0 99-05962458 "हमसे संपर्क करें" या फ़ोन के ज़रिए

Hi everyone,I'm looking to create a formula where, given a specific day of the week, and a time range, the formula will generate an output, and then write a script where it will take the output and enter it into a Linked Field box. For example, on Wednesdays between 7:20am to 8:00am, I want to generate a result that says "Period 1." 8:06am - 8:50am would be "Period 2," and so on, so forth. We have different bell schedules for different day of the weeks. And then, once it generates the result, I want to have a script run to add the "Class Period" into the empty Class Period box. Is this possible? Thanks in advance for any help that could be provided! 

I've built a powerful "knowledge database" from which I share multiple tables which hold various interlinked records (from one table to another). These tabels are shared across to multiple other bases I run for my businesses, benefiting from a single source of live-linked data.My problem is that the synced tables flatten out any linked records that exist, even if I've also synced the second table which holds the other side of the linked record.We want our users to be able to open and work with these linked records coming from synced tables.Is there any sign of this being improved upon by airtable?Is there any workaround for this?

Hey guys,I have a team that is using the comments in airtable for their communication, where they tag users and user groups. When they tag users the user gets an email notification, but when they are tagged through a user group they do not get an email notification. Is there a way to turn that on?As a side note, I feel that the comments section needs an overhaul in general.Thanks!

All of automations have suddenly stopped working, while they test successfully. It's not about one automation, but for every and each automation in the base. The question is, what could be causing this problem, as everything worked perfectly until now.   

Hi community,I'm struggling to understand why this whatsoever perfectly working tiny piece of script stops doing so when (seemingly) the 'start' date and the 'end' date are not in the same month.I am rather new to Airtable script editor so I couldn't find a step-by-step run mode, or a variable value watcher, but it seems that the 'days' variable is not computed correctly when 'start' and 'end' belong to a different month (for instance, 2024-07-15 and 2024-08-07 - however works perfectly with 2024-07-15 and 2024-07-31, and then 2024-08-01 and 2024-08-07)... leading to not entering the 'for' loop at all.Any clue anyone? Many thanks in advance!  let table = base.getTable('Man.days'); let inputConfig = input.config(); const start = new Date(inputConfig.StartDate); const end = new Date(inputConfig.EndDate); const days = end.getDate() - start.getDate(); var date = start; for (let i = 0; i <= days; i++) { let record = await table.createRecordAsync({ [

I'm trying to avoid having to add a view for each new coach in a coaching engagements base.  The filtered URL works beautifully in a browser, but when I add it to the embed code in the iframe, it gives me the airtable.com refused to connect message.<iframe class="airtable-embed" src="https://airtable.com/appNTRWwuGJYQDcYK/shrPcWPXGkhHeb30F/tbl38pqjIpX(rest of code hidden for privacy)&filterContains_Engagement=(First Name)+(Last Name)&filterIsAnyOf_Status=In+progress&filterIsAnyOf_Status=Awaiting+SOW&filterIsAnyOf_Status=Assigned&backgroundColor=blue&viewControls=off" frameborder="0" onmousewheel="" width="100%" height="1000" style="background: transparent; border: 1px solid #ccc;"></iframe>

Hi! I'm new to Airtable and I'm trying to create a dynamic data base. The goal here is to have a table with Clients info and then other tables that relate to the Clients info table. Let me explain it further: I have a table called Clients info but then I also have other tables such as Spaces (which offices they are renting and other information about these offices), Communication (social media profiles, presentations and others). I want for each record on the tables Spaces and Communication be related to the Client Info table records.How can I do that?Thanks!  

I am trying to extract the first 6 digits from a rollup so that the main column is automatically filled with the resulting ID, but when I use this formula, I get #ERROR in the fields.

Dear All,Newbie here! To simplify our current workspace, we would like to duplicate our main base (let's call it A) and delete any entries in the duplicated version (B) with a deadline after June 2023. B will be used as archive for our past work.Then we would like to run an automation in A to remove any content with the deadline set till June 2023 (so we are only using what is for use " current content")This is a one-time automation; we do not need it to run multiple times. How can I set up the script for each scenario? Thank you in advance for your support and guidance, Best regards,Catherine