Formulas

hello, I need help, I have my airtable automate with make for my bnb reservations. my lock generates a temporary code then add it in airtable. msis if the code starts with 0 , the 0 disappears this is very problematic for customers. how to do ? the code always has 10 numbers 

Good day team,  I would like to ask let's say for example I have these email addresses and I want to use a formula to get "ABC" to "ABC Company Philippines." What would be the correct formula?For your reference, this is the formula that I am using right now. IF(RIGHT({Email},LEN({Email})-FIND(".",{Email},FIND("@",{Email})))="abc", "abc company Philippines",IF(RIGHT({Email},LEN({Email})-FIND(".",{Email},FIND("@",{Email})))="bcd","bcd",IF(RIGHT({Email},LEN({Email})-FIND(".",{Email},FIND("@",{Email})))="cde","cde", RIGHT({Email},LEN({Email})-FIND(".",{Email},FIND("@",{Email}))))))

I am trying to use the new list view to create a system for putting together quotes for events. I have a list of event enquiries in table 1, and in table 2, have created a list view, where I am adding line items to events using levels. I would like to have an auto calculated field in the event enquiry item that gives me the total cost for all the line items I've allocated to that event. I've attached a screenshot of an example. I assume the "Total event cost" field needs to be a formula - can anyone help with a formula that will do this calculation?

Hello!  I have text of the form:10 x 8 inches (image)25.4 x 20.3 cm16 1/8 x 13 5/8 inches (frame)41 x 34.6 cmin a field called Image Size.  This is how the text came in from an Excel spreadsheet.  There did not seem to be a Delimiter I could successfully use to separate the text previous to my importing it to Airtable.  I want to take the string on the line that precedes "(frame)" and that follows "(frame)" (basically the inch and cm dimensions of the frame as opposed to the image size) and extract it to a new field (the formula field), while, hopefully also deleting it and the cm dimensions following "(frame)" on the next line from the original Image Size field.  Sometimes "(frame)" shows as  "(frame size)".  Thank you very much in advance for any assistance!

Hello Everyone,Is there a formula for multiple values I set to equal "Success"? ( put several values like "1234" which would be equal to "Success") please thank you in advance,Best regards,

Hello, I would like create a table with summary results of all the base. For exemple, for a base with different tables like : 1 - Suppliers2 - Products3 - Customers 4 - SalesI would like have in a table (to use in a app built with softr) global datas like : - the number of records in the supplier's table or of customers- the average turnover - the total average ...How can i do that ? Thanks 😃 (I know it is possible with blocks "extensions" but it is not possible to have datas blocks in softr ... ) 

I'm pretty sure I'm over thinking this process so I apologize in advance if this is obvious to most.I have a field in Table 1 which when data is entered, I'd like that data to automatically create a new record in the primary column of Table 2.Table 1 is my ideas bank and when I have created a  "Working Title" (field name in Table 1) for that idea, I'd like the title to be automatically added to Primary Column in Table 2, thus creating a new record.Really hope this makes sense.Any help appreciated.

Hello, maybe this is not even possible, but if it is, what would be the proper syntax for this ?IF(VALUE({Total Rate 6})) >0, VALUE({Total Rate 6}), Blank() This field is showing the data of another column called "Total Rate 6", but i want it to be blank if the amount is 0(zero)

Hi everyone, I'm trying to get this formular to work, and although it parses there's no output.   ARRAYJOIN(ARRAYCOMPACT(Field1,Field2,Field3,Field4), ", ")  The fields are a mix of and link-to-another-record fields lookups (of link-to-another-record fields) where the outputs all are fine. The reason why I'm using an ARRAYCOMPACT as well is because half of the fields are usually empty.Thank you very much ❤️

Hi guys, I need help building formula automation and seem to have trouble with the Find function.So we have an outreach database for our customers and for each outreach, we track a response as "yes" or "no," Ideally after two constant rejections we would mark the customer inactive. If later on they respond or reach out then we will mark them active again. With this in context, I'm trying to build an automatic status update function in Airtable. If one customer's status is "No, No" or "Yes, No, No," the customer's status shall automatically change to "inactive." If a new yes is recorded, like "No, No, Yes" then it shall change to "active,"I tried a few different ways but none seem to work perfectly. The closest I could think about right now is to use the "Find()" function which in my understanding returns the last position of the string being looked up. However, when I tried it, this is what I got:only one str

I know this is super simple, but I am new to formulas. Here's my problem:I have volunteers signing up for a rotation and I'm trying to make a view that will capture their hotel needs, which are generally: Check In one day BEFORE their First Day BOG and Check Out one day AFTER their Last Day BOG (BOG = Boots on the Ground).This is the formula I am using to get their Check In date: DATEADD({First Day BOG},-1,'days')It is not calculating correctly.This is the formula I am using to get their Check Out date: DATEADD({Last Day BOG},1,'days')Also not calculating correctly. Help & TIA

Hi everyone,An application is sending me a date in ISO format (2022-02-13) and I want to convert it in the european date format without dropping the day and month leading zeros ( = 13/02/2022). I managed to convert from ISO to European but the leading zeros are dropped.If I use the DATETIME_FORMAT with the 'L' specifier, the leading zeros are back but the format reverse to the american format ( = MM/DD/YYYY).Is there a way to keep both the european format and the leading month and day zeros ?Thanks in advance for your help, Gilles

The bottom one should be a count of 2. Team A and Team B are two fields. I tried COUNT, COUNTA, COUNTALLHere's the formulaI can't even add a Count to that specific fieldThanks

Need the 'Test Formula' field to format the 'Trip Total:' as currency.  Any ideas anyone?

Hello, I'm stuck trying to figure out how many workdays exist in a given month. It is easy enough to get the number of workdays between a start and end date using the WORKDAY_DIFF() function, and it also seems possible to collect the total number of days per month. However, I have not come across a solution to determine the number of workdays per month. Any help would be appreciated!

Field 1: is a currency fieldField 2: a checkboxField 3: is a currency fieldI need a Formula in field 3 to do this: IF field 2 = 1, copy & paste the value in field 1 to field 3.Thank you.

I have content creation table that has a field for date and time.  I am trying to create a formula similar to this  If ( {Date to Post}=TODAY( ), "Post") but it is throwing an error and I wonder if it is because my column has both date and time. this is the youtube video that was helping me.  https://www.youtube.com/watch?v=pai7nmnLh6g But i can't get past entering the formula. Any help would be appreciated.

Hello,    Hope someone will be able to help me, I am trying to create a formula field for my employee to auto calculate his work hours for a day. He fills out the form and I am tired to calculate his hours per day.So, I've got one field "IN" with multiple select options "8:00am" "8:30am" and "9:00am" and another field "OUT" with multiple select hours "3:00pm", "3:30pm" and "4:00pm" (I have more options, but it does not matter here), so ones IN and OUT are filled, I want to have a formula field calculating how many hours my employee worked today. I thing it should be done as logical formula, like if IN is *8:00am" and OUT is "3:00pm" then HOURS result is 7, something like this, but I can not make it right, anybody could help?

Hello i have a list of ingredients that are in a single long text cell SaSweet potatoCarrotI want it to put a ▢ infront of each item ▢ Salmon▢ Sweet potato▢ Carrot TIA

I have a formula that works when a set decimal is entered but not when the decimal is inputted from a field reference. The formula that works (with manual decimal at the end): IF({Custom MSH Fee} > 0, {Custom MSH Fee}, ({Total Booking Price}+{Channel Booking Fee Amount (inc manual fees)})*0.1)The formula that doesn't work (with decimal from Field Reference) IF({Custom MSH Fee} > 0,{Custom MSH Fee},({Total Booking Price}+{Channel Booking Fee Amount (inc manual fees)})*{MSH Commission Decimal})What am I doing wrong her

Hello,I have a web scraper that is pulling in assorted data from a list of projects. The issue being that the date/time data that it scrapes into my base doesn't convert very well into an actual date field type.Here is what I am working with:Any ideas on how i can remedy this? I need the date field type so i can better filter the projects.Also welcome to any suggestions on how to best handle the "Bids In" column where it gives me varied answers that don't filter very well 😕😕 

Hi there, I know how to get things off the end of a string but not the start!!! I have recipes that look like this  Easy veggie, lentil and quinoa dahl with pita toasts (KIDS)Greek salad with crispy chickpeas and potatoesMiso eggplant with broccolini and edamameTM Pan-fried salmon with creamy pumpkin milletTM Moroccan spiced beef and lentils with carrot couscous I want to create a field that has all the recipe names - but without the TM at the start.  TIA

Hi,Am using a formula I've used in bases before, but it's behaving strangely.  It's subtracting a day off of the returned value.  I have two fields with dates.  Only one of the two will ever have a date in it.  I want the formula to grab the date from whichever field has a date already populated in it (from another table)Here is the formula.  IF({Shoot Date Rollup (From Scenes)}="", {Shoot Date Rollup (from Set List)}, {Shoot Date Rollup (From Scenes)})Example:Shoot Date Rollup (From Scenes) = 7/25/23The formula Returns 7/24/23Same if it's the other field that has data Shoot Date Rollup (from Set List) = 8/10/23Formula field returns 8/9/23Thanks for any help.

I am trying to follow this video tutorial: https://www.youtube.com/watch?v=BkAY7OHEgdcThe formula: 'https://airtable.com/shr12G6XKocbeGi0H'&'?prefill_Doll%20ID='&RECORD_ID()&'&prefill_Doll%20Name='&ENCODE_URL_COMPONENT({Doll Sculpt})&'hide_Doll%20ID=true' However, the part to hide the record ID is not working. This is what happened to the form:As you can see, the "Doll Name" area has the formula to hide the record ID in it. 🤔 🤔 I tried doing it exactly like the video and only having "(Doll Sculpt)", but it said there was an error with the formula and I was forced to use "({Doll Sculpt})". Could this be the issue?I haven't even tested the functionality (I haven

Hi there smart people!I'm looking to show the percentage of improvement since the implementation of our new Figma redlining process from our team survey. Right now, 5/8 people say the process has either improved or greatly improved! Is it possible to show this in Airtable's Interface? Either as 5/8 or 63%? Participants will continue to add to this survey in the coming weeks. So, I need a create a formula that will update the Interface accordingly. Please, let me know if anyone has an answer!