Solved

Hi everyone,I have an issue with the color formatting for Formula Feilds displayed as progress bars, it seems buggy:With decimal percentages the conditions are not recognized properly, I have the following conditions on a fieldbut the results are unfortunately wrong for values that are near the "breakpoints".Any suggestions?Thanks

Hi fellow Airtablers!Could anyone suggest how can I make the ''Next charge'' date field recurring on a yearly basis every year if the toggle in ''Frequency'' is set to ''Yearly''? This dilemma is driving me nuts 😞 Right now, I just have a formula in that field:DATEADD({Latest charge}, 1, 'years')But it's not ideal because I would need to manually update ''Latest Charge'' field with the previous year every year.Ideally, I'd love to solve this with a formula because I'd have lots of entries, and it may be a bit cumbersome to create automation for each and every entry.But if automation to update the latest charge is absolutely needed, what is the best way to go about it/set it up? 

I am trying to create an automation that will update a record. I want to add a linked record from one field (Field A) to a different field (Field b). Field A will have only one linked record in it. Field B allows multiple linked records. Right now, whenever i update the record with the info from Field A, it either overwrites everything that was in Field B or it creates a new linked record that merges the info that was in Field A with the info that was previously in Field B. Is it possible to automate this kind of update? thanks for any help! is this possible?

Hello,I've encountered an issue with the DATETIME_PARSE function not correctly converting a concatenated date and time from two fields. Is there something I'm missing?

I have a multipart task that I think can surely be accomplished with a few formulas. I looked around the forums for a while and I think I have an idea but I haven't been able to put it all together yet! Basically I have lookup field collating all the dates that a certain client has ads scheduled across multiple products. For our scheduling purposes, the first of each month have a "- [Month]" text added. I want to identify the first date among this group of dates, for a notification automation to let the team know when this client's contract starts. Using a Formula or Rollup field I can transfer that into a string separated by commas. From here, my general understanding is I need to:> Strip out the text so its just dates (I tried REGEX_REPLACE but it also removed everything after the first instance of text. These type of coding functions are really over my head)> Format the dates into YYYYMMDD numbers that can then have the MIN function applied to find the earliest

Hi Does anyone know of a way to ‘Filter’ a ‘Date’ column by something similar to “this week”? Basically, I’m just trying to create a Grid View that shows - via a Filter - all enquiries that have been received ‘this week’ (which is from Monday through to Sunday of the week I’m looking/accessing the View in). Any help would be greatly appreciated. Thank you Stephen

when i'm viewing my tasks i'm not able to see some projects. Probably because the project doesn't have tasks but I'm not able to add task if the project does not show. Anyone knows how I can solve this ?

Hello, I have posted about 15 questions this board and I have always received a solution my problem. So thank you all very much. I think I have a really tough one this time. I have a base to manage memberships and donations and legacy gifts for a not for profit. There are 6 membership levels with specific dollar amounts attached to them. So all is well as long as a person pays an amount that corresponds to an existing membership level. But when they pay an amount that is not a preexisting level, I have to assign the difference to a donation.I have a Currency field that records the actual amount paid. I have a formula field (thank you Alexey_Gusev) that shows the membership level closest to the payment amount. For instance, $35 would show as an Individual membershi which is set at $25. I need to then add the remaining $10 the donation field. The next level is $45 for a Family level. To be completely honest, I have no idea where to even begin with this. Due mostly to the h

Images to make it easier to understand. When a record gets the single select category “Investment from private”, this automation triggers. This is synced directly from my business bank account every day. This is the record i want to update: Thought i had it covered with this automation: Buuuuut the automation overwrites the linked records instead of adding to the end of it. Is there any simpler way to deal with this? Do i have to use a script instead? This is for a client that deals with tons of transactions and i have to make a separate table categorizing cashflow.

Hi there;I'm very new both to Airtable and formulae, so I hope this is just a beginner's issue and is not a function or possibility currently beyond the possibilities Airtable provides.I have a formula field (Sim Required?) that I would like to populate a green checkmark from a combination of possible options in the multiple select field (TikTok / Instagram / Router).The multiple select field has 4 options:TikTok 1, TikTok 2, Instagram and Router.I would like the green checkmark to appear under these conditions:TikTok 1 only is selected.TikTok 2 only is selected andBoth TikTok 1 and TikTok 2 are selected.I've managed to have the checkmark appear only when TikTok 1 is selected; when I try with only TikTok 2 or a combination of 1 and 2, the green checkmark doesn't appear.Thanks for any help you provide, 

Hi,I have a table to have a list of equipments and when they were cleaned. Apart from equipment details I have these fields:Last maint date (a date field - to be manually entered)Next maint date (formula which returns a date 120 days after Last maint date)Actual cleaned date (date field - date on which an equipment was actually cleaned - to be manually entered)Status (Formula - I want this to be evaluated for 3 conditions and return text phrases accordingly)Conditions:If the 'Actual cleaned date' is greater than 'Next maint date' then return 'Delayed' in StatusIf the 'Actual cleaned date' is equal to 'Next maint date', then return 'Cleaned on time'If the 'Actual cleaned date' is lesser than 'Next maint date', then return 'Cleaner early'  I tried this nested if IF({Actual date cleaned}>{Next maint date},"Delayed",IF({Actual date cleaned}={Next maint date},"Cleaned on time")) But it is not returning any phrase as needed.Kindly hel

I'm using sidesheets in Interface Designer and want to add sections/groups for organization. Maybe it was luck, but I do have one sidesheet with sections that I cannot reproduce. View the screenshots. One is my base, and the other is from Airtable documentation.How can I add sections to a sidesheet when they are not available?

Hi, I'm a little lost with where to start looking for a simple tool that allows me to create a permission-based API on top of my Airtable data.I'm looking to enable an external collaborator to request the availability of a certain set of products. For that I would like to limit the user to1. Read only access2. A set of records via a view or filter3. A set of fieldsThis is a small scale experiment and I would prefer a quick to setup and free solution.I have looked at nocodeapi.com, which looks great but it doesn't appear to support the permissions I'm looking for.Thank you! 

It seems the more I learn here the more ideas I come up with that I need help with.I have a membership payment table. There are 6 levels of membership.Individual  $25.00Family  $45.00Patron  $60.00Sustaining  $100.00Benefactor $250.00Sponsor  $1,000.00I would like to write a formula in the membership level field that fills in the membership level in the membership level field using the amount entered in the amount of the membership payment field. There are 6 membership levels as above. So if they pay $35, then it would put in as an Individual membership, etc. The $10 difference would but put in a field of the donations table as a donation. I will start that formula when I get this working.This is what I came up with but it has an error. Am I missing an OR statement maybe?Many thanks, Scott IF(AND({Amount Paid}=25,{Amount Paid}<45),”Individual”,IF(AND({Amount Paid}>25,{Amount Paid}<45),”Family”,IF(AND({Amount Paid}>45,{Amount Paid}<60),”Patro

Hello, I'm trying to find a function that will pull all of the long text; rich field checked boxes away from any unchecked boxes. I've found the solution linked below and it worked great for the opposite problem. Does anyone have a formula to solve pulling only checked boxes? https://community.airtable.com/t5/automations/extract-filter-unchecked-items-from-a-rich-text-field/td-p/27036Subtasks are all our tasks. Next steps are unchecked tasks. Activity completed should be only checked boxes from the subtasks table.  Thank you!!  @TheTimeSavingCo @Brian_LWA 

Does Airtable have a simple search feature similar to the "Find" in Excel? Suppose a user is updating random fields in a 10,000 record mailing list. They need to quickly find a specific record based on varying criteria such as an unusual last name, phone number, address, whatever information might be available to find the record. In Excel this type of task is a no-brainer, what is Airtable's (hopefully) equivalent search functionality? I've seen the filter feature, that would be extremely tedious for random searches of this type. I'm new to Airtable, maybe the feature I need is right in front of me and I overlooked it. Thanks

I have a database where I have a check box that’ll indicate that a material has arrived. Im trying to have a formular to automatically record the date the check box was checked. Sofar I’ve tried with the following. IF({Trim arrived}=1,TODAY(), BLANK()) The problem that the date follows todays date and dosen’t stay at the date the the check box was clicked. Is there a way record the date it was checked in in the formular field

FolksI am getting this error now, after thousands of emails sent through several automations along the time, using only one email."Google reported an error while processing this action:You've temporarily hit Google's rate limit for sending emails."How can I prevent to get this error?What is the google limit?Will a professional google account prevent this from happening?I am trying to get these answers from the net, and nothing yet has showed up.Did someone already got one of these?Thanks in advance for the help

I’m calling an Apps Script which works as intended in the browser. However when using automation I get the error. I have read that this is to do with google redirecting the url. I don’t need to receive anything back from the script as everything is handled there. Are there any other ways around this? I could put it in a button but then it wouldn’t be automated. Also if possible I would like to avoid using another intermediary service.

IF({Last Renewal},DATETIME_DIFF(TODAY(),{Last Renewal},'days') > 365,"🔴","🟢") The above formula, without the first {Last Renewal}, works fine. But I have records that are empty and I want them blank. I obviously am not constructing my syntax correctly. I want to say that if {Last Renewal} is not blank, then do the following. as I said it works if take out the first {Last Renewal}. I'm sure it is simple. I just don't see it. Thanks, Scott

Hello! This filter does not take into account the time part when applied in URL: filterGreaterOrEqual_Date=2023-10-17T22%3A00%3A00.000ZExcept for when I set it at 22:00 where it filters OUT all records with date October 17, 2023 and "allows" them back in when I set it to 21:59.Other settings such as 06:00:00.000Z or 18:00:00.000Z show every record of October 17. Dates on my table are:17 October 2023 00:00 UTC17 October 2023 00:00 UTC17 October 2023 10:00 UTC17 October 2023 10:30 UTC17 October 2023 22:30 UTCIf I remove the time altogether it catches Dates very well: filterGreaterOrEqual_Date=2023-10-17 works fine. Any Ideas please? 

I am trying to auto-number a group of records for one person in a table with multiple people listed with numbers 1,2,3, etc.. In Excel, I would use a formula to add one number to the above cell, and it would number all rows sequentially. I usually manually number each record, but I am hoping a simple formula would number the list.Here is a screenshot of my table consisting of the records I need based on a filter.  The row with # in the title is where I would put the formula.  Any suggestions? 

I have to get approval for all software on an annual basis. The software request form now requires the name and phone number of a support person from Airtable before I can renew for next year. There are no exceptions to this rule. Does anyone have a name and phone number I can put down for this?I will never actually call this person. I just need something to enter on the form. I know the official answer is that Airtable doesn't provide phone support, but I will have to use a different product if I can't find real contact info for an Airtable support person.  

I'm trying to write a formula to check whether a lookup field contains a specific value.These lookup fields might contain one or multiple values, e.g.applesapples, pearspears, bananas, strawberriesI've been using the formula IF(FIND("apples", {fruitName}), "yes", "no") In this case, I would expect 1 and 2 to return as "yes", but only 1 is returning yes. Find seems to require an exact match, and if there are other values in the lookup field, it returns false. Does anyone know what I'm doing wrong here?

Hello and thank you for considering to help me!Every day, my Airtable is supplied with additional lines through an x ​​bias.How can I create a view that only collects last week's rows?I only manage to get the lines from 7 days ago and not all those from last week.Any idea ? 🙂Kindly