Solved

Hello,I have a table with fields like this : The "First char" field is a formula that return the first character UPPER of the "First name" field.  Then, the field "check" is used to filter a view from A to E. So i need a formula that show "OK" if the "First char" field contain A or B or C,,,,,,,,,E or else it will show "KO"Any ideas how to do it ? Thanks.

Hi everyone, Can a record be updated by an external user through an interface button ? Or do you have a link to solve this problem in another way (like a form) if it's not possible. Thanks for your help, François

Hi Airtable Wizards, I have the following formula which is formatted in currency and occasionally returns a -$0.00 result, where to my untrained eye, I cannot see why.  {PM: TOTAL BANK ALL EFTPOS}-{PM: TOTAL EFTPOS SALES}"PM: TOTAL BANK ALL EFTPOS" and "PM: TOTAL EFTPOS SALES" are computed fields that simply tally up totals from other columns. When both of the above columns match, it should return $0.00, which for some outputs it does, and others it computes as a negative.  Just wondering if anyone can figure out why?

I'm struggling to create the right formula and hoping someone here can help me: I have Field 1 as a single select. It's a list of brands with an "Other" option. Field 2 is a write-in field for when Other has been selected. I'm trying to create Field 3 as a formula field that merges the brand names—both the ones selected in Field 1 drop-down and ones written into Field 2. I have the second half working with ... IF(Field 1 = "Other", {Field 2}) But I can't figure out how to get the first part merged in. Whenever I try to add to the formula to make it add in the non-other names, I get an error. I tried a second IF formula, like ... IF(Field 1 != "Other", {Field 1}) But it doesn't work, and I've tried adding CONCATENATE, but I can't get that to work either. I'm not very proficient with formulas, so hoping someone here can help me get what I'm attempting. Thanks!

I have this table to track some gym progress.I have a number of updated values for each record, e.g.:for a 1 set of 10 for 245 for b 2 set of 8 for 356and etc.there is also column for tracking the latest update.I need to be able to somehow store the progress/history of this values. So what if i update smth like this:for a 1 set of 10 for 245 => for a 2 sets of 9 for 250i could have bouth record in my baseI'm aware about the Revision history function, although it's not providing acces to the information in the most comfortable wayIs there a way, through some formula/automation/etc. to copy the current record each time i'm updating it? 

TL;DR: what's the difference between 'contains' and 'has any of'?I'm setting up some automations with a 'when a record matches conditions' trigger.When I set my 'find records' trigger to the condition 'has any of' the dynamic value I want to use, I get 'invalid value: when a record matches conditions cannot be converted to an array of string'.When I set the condition to 'contains', it works perfectly.What is the difference between 'has any of' and 'contains'? In natural language the two are synonymous (to my sense of the language, anyway), but I assume there's some important distinction in the underlying code that I don't understand.

Hi everyone,Background:I'm in the process of creating a base which is to be used by our company and an external company to share information and update the status of job packs for solar installations.ScenarioI have a single select field called "Job Pack Review Status" which contains the properties "Awaiting Review", "NMI" and "Approved". I want to keep track of the time when the external company changes the status to either "NMI" or "Approved" by logging a time stamp. However, there are scenarios where if the job pack may be rejected (NMI) and then resubmitted after being updated. In this instance the status would change back to Awaiting review before the external company makes an update. In this scenario I'd like to keep a second timestamp when the property is updated for the second time.  QuestionIs it possible to log multiple time-stamps in separate columns based on the status of a single select field changing multiple times, or should we be splitting this into a separate

How a collaborator can view only their records

I am trying to set up a database of past video shoots, including who worked on them and what position they worked as. I have a table of people, a table of positions (director, cinematographer, producer, audio, makeup, etc), and a table of projects. The issue I'm running into is that our team often juggles positions, so John may be the director one day, and producer the next. Sue may be doing makeup, and then audio another day. (I admit it's chaotic and we're working to nail down positions... Part of why I specified that this is a database of past video shoots!)So, simply linking the people and projects tables doesn't work, because that doesn't say what position each person worked as. I could add individual fields to the projects table for each position and select the director, the producer, the audio tech, etc, but that seems clunky and would make it hard to simply view a list of who was on the shoot.The solution I've found is to create another table that simply links co

Can someone help me modifying this formula so that if the condition 'Trækdato (FarPay)' field is empty, the formula field is left blank? Right now it returns an #ERROR!  IF(AND(DATETIME_FORMAT({Trækdato (FarPay)}, "D")<10, DATETIME_FORMAT({Trækdato (FarPay)}, "D")<10), IF(WEEKDAY(DATETIME_PARSE(DATETIME_FORMAT({Trækdato (FarPay)}, "YYYY-MM-10"),"YYYY-MM-DD"))=2, DATEADD(DATETIME_PARSE(DATETIME_FORMAT({Trækdato (FarPay)}, "YYYY-MM-10"),"YYYY-MM-DD"),1, "weeks"), IF(WEEKDAY(DATETIME_PARSE(DATETIME_FORMAT({Trækdato (FarPay)}, "YYYY-MM-10"),"YYYY-MM-DD"))<2, DATEADD(DATETIME_PARSE(DATETIME_FORMAT({Trækdato (FarPay)}, "YYYY-MM-10"),"YYYY-MM-DD"),2-WEEKDAY(DATETIME_PARSE(DATETIME_FORMAT({Trækdato (FarPay)}, "YYYY-MM-10"),"YYYY-MM-DD")),"days"), DATEADD(DATETIME_PARSE(DATETIME_FORMAT({Trækdato (FarPay)}, "YYYY-MM-10"),"YYYY-MM-DD"),9-WEEKDAY(DATETIME_PARSE(DATETIME_FORMAT({Trækdato (FarPay)}, "YYYY-MM-10"),

Hi everyone, I've two tables with two type of granularity, for instance Table Name and Table Sport, and I would like to create a table with one line equal one name and one sport. I show you this juste below, for the moment I have In my first table one record = one name  Name 1  - Tennis Rugby FootballName 2 - Football In my second one record = one sport Tennis - Name 1Rugby - Name 1 Football - Name 1 Name 2 I would like to create a third table NameSport where one record = one name and one sport like this : Tennis - Name 1 Rugby - Name 1 Football - Name 1 Football - Name 2 I created an automation, when a new record enter a view in the table name, it runs a script, to create in the third table the good granularity. I inspire myself from this community message but it takes the all table and I would like only the triggered record. I created an input variable with the record id, but it's still inserting me in my

Hello, looking for help on how to trigger the update of formula field when a record reaches a condition. My example is the following: I have a "Birth Date" field which contains the birthdate as Date. I have a formula field which calculates the current year "Anniversary Date": DATETIME_PARSE(YEAR(NOW())&"-"&DATETIME_FORMAT({Birth Date},'MM-DD')).How can I trigger the update of this "Anniversary Date" when the record reaches the day after the anniversary? 

I have tried multiple way, know I am missing something, but can't work out what. I have one column for Date and the next column is yes. Meaning that consent has been given and on the date in the column. I now need a formula field that will return the word 'valid' if the consent date is less than 365 days from today, and 'not valid' if the consent date is more than 365 days from today. Hope I have explained that well. I have so many good ideas, and I truly do try to work them out before I come here 🙂 Thanks in advance!

Hello amazing people! I am working on my film workspaces and trying to build a table to use for a Page Designer for a Call Sheet. I have several tabs I need to pull details from, all based on the Date Field. This Scenes tab is one of the places to pull from, and it has a Filming Date field.I am pulling IN to this Call Sheet tabWhat I need is if the Date on a record in the Scenes tab matches the Date in this Call Sheets record, I want the records to link. I will be using a number of associated lookup fields from the containing records.I assume I will need to use a Formula? I have trouble wrapping my head around those for some reason 😖 I've tried various other options and none will allow me to just say "If this date matches that date please link" and I can't restrict to a view because I would need to change that parameter for every new call sheet.I hope this makes sense! If anyone has any suggestions I would really appreciate it!

I am building a new base for my company's Inspectional department to help the coordinators input and track historical, ongoing, and schedule inspections for our housing agency's low-income housing vouchers.We are tracking a combination of inspectional protocols: Move-In - When a person moves into a new unitAnnual - The yearly inspection for an ongoing participantSpecial inspections. I broke it down into five components (tables) to reflect the relational data that I want to connect with bullets that represent the fieldsParticipant (Voucher holder):  Last NameFirst NameHousehold IDLanguage PreferencePhone Number EmailProperty OwnerOwner NameOwner IDOwner PhoneOwner EmailUnitsStreetCityZIP Code# of BedroomsType (i.e., Low-Rise, High-Rise, Townhouse, etc)Year BuiltInspectionsProtocol (Annual, Move-In, Special)Requested DateScheduled DateOutcome (Pass, Fail, Reschedule, Cancelled, etc)Inspectional Report Attachment fieldInspectorsInspectors&

Is it possible for the submit button on a form to not be visible until all of the conditional fields are satisfied? 

Hi there, I'm not sure if this is possible or if I'm approaching correctly the solution, but here it goes: I'd like to create some sort of dynamic filter that when I input a date, everything else in this table will update accordingly. The link records that won't meet the filter criteria will be excluded, therefore, updating the COUNT calculation and all related formulas. To give you more context about the base setup, there are two tables: TicketsSuppliersWhat you see in the screenshot above is the Suppliers table, which is aggregating all the tickets. Is there a way to exclude linked records based on a filter?Thanks everyone!

Basically we have two workspaces. One is for project management. The other is for accounting. Once the project has been completed, we change it's status to "ready for accounting" which then automatically syncs with the accounting workspace. So no new records are being created in the accounting workspace.We then generate a "price code" based on the company name and the product. The price code reference a price list which is a different table in the accounting workspace. I have nearly all the mechanics of this worked out, but currently have to manually copy/paste from "price code" column to "price" column (see screenshots). I'd like to automate this, but I've had trouble with the tutorials I've seen, and I also don't know what an appropriate trigger would be.Thanks in advance for any help!

I have an airtable view embedded on my site. When I click on Filter-> Add Condition, the webpage jumps down the page a couple hundred pixels, which makes for a terrible user experience - the user can't even see the filter box anymore and has to scroll back up and reclick in it to add a filter. You can reproduce this on our site and see for yourself: https://www.highimpactprofessionals.org/talent-directoryAnything we are doing wrong here? We just copied the embed code, so not sure what could be wrong.In case it is useful, we use Wix to build the site.

I have a column named MIN and need to add leading zeros when the value in column is less than 4 numbers:BeforeAfter Formula220022456045610000100008888888888999999999999999999This is what I have right now but is giving me an error for the largest number:IF((COUNT(MIN) <= 3), (REPT('0',4 - LEN({MIN} &''))&{MIN}), {MIN}))

If you look at my attached images below, I'm struggling with the CONCATENATE function. I want to add the COMPANY as a  prefix to each of the multiple items listed in the PRODUCTS column, but concatenate only adds it as prefix to the first item.I am doing this so that it will reference a price list. We offer the same products to each company, but each company has a different set of prices. I was going to figure out how to automate the copy/paste from PRICE CODE to PRICE, but I couldn't even figure out how to get the price code in the correct format. Thanks in advance for any help! 

We're using a base to track actual work done on multi-project invoices, but the invoices from different vendors format the info differently - some tell us a percentage of the time worked spent on each project, while others tell us $ amount subtotals by project. I have a table recording the actuals from each invoice, which includes a "Project Percent" field and a "Project amount" field, and I can enter the info on each invoice in either field and leave the other blank, but is there any way to have the populated field do the math against the invoice total to automatically fill in the other field that's left blank? I can't see any way around the problem that having the fields update one another reflexively would cause a circular logic error. Anyone have any ideas on how I can automate filling in percentage when I have $ amount, and fill in $ amount when I have percentage? 

Hey! This is driving me mad and I'm sure it's either: - I've been working on this for too long and I am overlooking the obvious / need a break- A bugContext: I have an interface where there are requests from form submissions. There is a 2 step approval process, where approvers should set a status by clicking a button. These users are "editors" in the interface, so permissions should not be the issue.When I "View As" / Preview as one of these approvers, I see that the buttons function correctly and I can set the statuses. Image below.  This approver though has a different view - they cannot click the buttons. I'm a bit at a loss for what to do in terms of troubleshooting. The tricky part is, there are 5 or so approvers, and ONE of them is able to interact with the buttons and set the status (calibrated / flagged / clear).  Any suggestions/thoughts? 

I'm trying to create an automation to update a record. I want to change the status of all tasks associated with a sprint to have an "archived" when that sprint is "done".The trigger is based a table called "Sprints Lists" with a condition of "Status: Done".And as an Action I want to edit the "Status" field from a different table called "Tasks Lists" so that the new value of Status is "Archived".I've tested the trigger successfully. However, when I click on the "+" button to select the corresponding Record ID from the "Tasks Lists" table, it only shows the fields from the "Sprint Lists" table used in the trigger. 

Hello!I'm hoping you guys can help. I'm a total newb with formulas.I'm trying to build a animal shelter manager and usually we don't have the exact date of birth. Just an approximate age (ie, 2 years, 5 months, 4 days, etc.). Is there a formula that can calculate an approximate date from those numbers?I've looked everywhere and tried a million different formulas.