Formulas

Hello! I would like to know if there is a formula to identify duplicates? I have a database with codes for each product. When a new product is entered into the database, I would like to be informed if the code assigned to it already exists. Thank you for your help.

I have a table a that has a column with a paid field. I want another table column to bring over that paid field column only if it is filled. Not empty.

Hi Everybody, I am trying to create a “concatenate formula”, that creates a line break and a fixed size table cells, all text should be aligned left. because I am applying a bulk query search and I want one result per line. I know the “\n” creates the line break My formula is CONCATENATE("\n",{Google Slides Format Title}," | “,{Google Slides Format Release},” | “,{Google Slides Format Origin},” | ",{Google Slides Format Title Rating}) so my output is like this “Bilal: A New Breed of Hero | | 1x105 | 01/09/2020 | UAE | :star: ” I want all of that to be in table cells fixed sizes and always aligned to left I think it needs some code for app surface to land right on google slides Thank you so much guys for your help in advance

Hello there, Is there a way to get an email reminder with tasks by daily? I’m trying to find the way to setup recurring email reminder. For example, I want to get an update from a view “Tasks due in 7 days” everyday at 7am. with the tasks and details. The closest way that I found is from the post below Daily recurring reminder emails formatting

I’m trying to figure out how to write a formula that matches a field that contains a link to records. In my setup, I have a field that is a link to another record. I’ve tried {Field_Name} = rec########, {Field_Name} = “rec########”, {Field_Name = “Record Identifier”}. What am I missing??

I’m looking for a CURL formula that will filter out dates in the past. As in a schedule I don’t want it to show me the scheduled times in the past. More Specific I need the Query Parameter Value

Hello all, so I have a table of Cars Status, which show the status of each car for each each day - Up, Down for engine prob, down for brake prob, down for tire/wheel prob etc. (My fleet is much larger than in this example, but let’s just consider a fleet of three cars.) So each car has a record in the Car Status table for each day. In my Daily Reports table, there is one record for each day, and (among many other things) I would like to have a field that counts how many cars are “Up” on each day, as recorded in the Car Status table, and another field showing how many cars are down for “Engine” and so on. So for each record in the Daily Reports table I need to have a formula (?) field, that looks at the Date field for that record, and then counts how many cars there are in the Car Status table which are “Up” on that same date. Here is a read only link to a base I set up which has these tables set up as I describe, for clarification.

I am new to airtable. I can’t find a way to write following query in airtable using filter by formula. Select * from tablename where bertha={varibale1} And berthw= {variable2} I have the 2 variable in my hand and i have the fieldname too But in search table contain ids not direct values Means BerthA table [ id] Berth B table [id] So direct matching is not possible. Anyone please help me to search a value inside the array. I did OR( ${berthA} = ’ xxx’) Doesn’t return anything because berthA is array

Hello, Thanks in advance for reading my post. I have a table which includes a list of equipment, and then I have another table that contains dates of bookings (a booking is per day), location of booking and other fields. I would like to be able to see on the first table the last location of a booking and it’s date. Is that possible to do?

As you can expect, I am using a function field to manipulate a time field; two issues appeared gmt zone went crazy inside the new form field language for dates now are shown in english. Two solutions came to rescue: For issue # 1 I can use: DATETIME_FORMAT(SET_TIMEZONE({date field}, 'America/Bogota'), 'dddd, MMM D, YYYY h:mm a') for issue #2 I can use: DATETIME_FORMAT(SET_LOCALE({date field}, 'es'), 'dddd, MMM D, YYYY h:mm a') They both work perfectly INDIVIDUALLY, How can I combine these 2 formats inside one single formula.

I’m looking for a formula that can help me add the numbers 1-6 to records, looping. So: Row 1 - 1 Row 2 - 2 Row 3 - 3 Row 4 - 4 Row 5 - 5 Row 6 - 6 Row 7 - 1 Row 8 - 2 I’ve thought about using the autonumber field and then trying to extract the number 1-6 from that, but I’m genuinely at a loss.

Hi, I would like to achieve something that seems basic but i can’t find a solution. I have a table of contacts, another table of companies and of third one of projets. I link a contact to a company and a company to a specific project. I have several contacts for each company and i would like to link a project to a specific contact. I obviously can link the project to a contacts but i would like to only be able to select someone from the company in charge of the project. At this point i can pic any contact. I know that we can make a condition on a specific view but the view as to be “dynamic”. I don’t want to manually create a view for each company. Thanks for your healp!

I have a table that contains my users, and their current balance of chips in a casino. I’m building a leaderboard that will tell them who the top five chip holders are. (This is the easy part.) I also want to tell them what place THEY are in, if they’re not in the top five. This requires one of two solutions: Grab all of the data, and iterate through it until I find the user. This is a heavy operation, because I’d have to pull all of the user data to my application before iterating through all of it. Have a ranked column that automatically updates every time that a user’s balance changes, much like Lookup, Rollup, or Formula fields. This is my preferred approach, but I can’t figure out how to do this. Do any of you amazing people have some guidance or advice? Thanks!

When calculating the difference between two dates it gives me NAN, since one of the cells is empty. ¿How can i fix it? Help me :blush: IF( AND( {start_isolete}, NOT(DATETIME_DIFF({date_out}, {start_isolete}, ‘days’) < 1) ), DATETIME_DIFF({date_out}, {start_isolete}, ‘days’) )

Hi, I need some help creating a formula. I currently have the following set up: Table1 Primary column = text Start column = date End column = date Table2 Primary column = date Notes column = text In Table1, I’d like to display what Table2 records exist that are in between the Start and End dates for each Table1 record. Any advice would be appreciated!

Hello all! I have a question. I would like to create a formula with 2 conditions. IF “Item” in row 1 = “item” in row 2 AND “P” in row 1 is equal to “P” in row 2 then “it’s ok” otherwise “it’s not” Do you think it’s possible? Thanks for your help!

Hello all! I wouldlike to know if it’s possible to have in the column “test” all the items which are in the same period. For example in the first row of the colum “test” the result would be “FRT54522” because “FRT54522” has a period in common with “FRT5678C”. Many thanks for your help :slightly_smiling_face:

I’m having a strange issue with my formula, it’s been working for the past year but then all of a sudden it didn’t seem to be updating. I ended up fixing it by duplicating the formula into a completely new field and it seems to work on the new field, but I don’t want to break any old references, etc. Any ideas what’s going on?

Hello all, Il have concatenate 3 cells and it gives something like that “FRT5678C9Validated”. I wouldlike to count in another column the number of time it appears in the fist column. As you see “FRT5678C9Validated” appears 2 times but it only counts 1. Can you help me please? Thanks and have a nice WE! For

Hello there! I have following problem: My database primary field is a date. I do entrys just like in a diary. For each entry, I can choose the select field 1 or select field 2 as type. Now I want to count all input fields in concurrence between select field 1 and select field 2 and display it in a third field. So for example: Name / Input Field / Accumulated Select field 1 - empty - empty Select field 2 - 100 - 100 Select field 2 - 150 - 250 Select field 2 - 125 - 375 Select field 2 - 25 - 400 Select field 2 - 100 - 500 Select field 1 - empty - empty Select field 2 - 50 - 50 Select field 2 - 100 - 150 … I know want a third field that displays the sum or accumulated value of input field between the two select field 1. The table is sorted by the date field. Is this in a

To give some background, I work at a fitness company; we treat “classes” as projects. Looking to: Count number of classes scheduled in a specific week. Count number of filmed, scheduled classes in that week Find out what the percentage is of scheduled vs. filmed and if possible, show in a block

hi, how can i use text with quotation marks inside of an if-statement? my simplified case: IF(Item = “string”, 1, 0) my string looks sth like this: ‘product “type” extension’ but it doesnt recognise the strings if they contain ", which the entry im trying to work with does. ‘string’ doesnt work either

Hi, I am creating a schedule, the schedule us currently ordered by start time. I have a formula that adds duration to start time to create an end time. However whenever I change a duration the order does not change automatically, this is because the start time is not connected to the previous session’s end time. Is there anyway to do this so that the start time equals the end time of the previous row?

I believe I need a script rather than a combo of filtered views/linked fields/conditional rollups to accomplish my goal: I have 3 tables: Employees, Seminars, Registrations I’m trying to populate a field in the Registrations table with a sum of values contained in the Seminars table IF certain conditions are met when compared against other fields in the Registrations table. Below is my best effort at writing this out…obviously not actual JavaScript or Airtable syntax, but hopefully its a start. Tables are bold, fields are italic. Registrations PDH Earned is sum of Seminars/Webinars (PDH) IF Seminars/Webinars Attendees contains Registrations Employee AND IF Seminars/Webinars Date is (>= Registrations Previous Renewal

I wanted to make the primary field of a table into a link to another table. (Like using a foreign key as part of a primary key in a database.) Of course, I immediately discovered that was not allowed. So, I created a new field, made it a link, then used a formula in the primary field to copy the value of new field (that was now a link field) to the primary field. To test whether that would be allowed, I created an exceedingly simple formula in the primary field. It was just the field name of the new field that was created to be the link to another table. At first, I thought it worked perfectly. But, later I realized that there was a problem. If the text string in the link field (which was the value from the primary field in the other table) contained a comma, Airtable automatically enclosed the whole string in double quotation marks. If the text string in the link field did not contain a comma, Airtable simply copied the text string without adding double quotati