Solved

I’m capturing leads from a webform in airtable I can’t keep people from submitting information multiple times (the webform is a drawing for a prize). How can I create an automation for the original names entering a new view - that will check on email address as a unique identifier, for any other record already in the view with that email address before copying from the grid view/original view to the new “deduped” view?

Hello - I am using a simple formula of: DATETIME_DIFF({Today},{Start Date :star: },‘days’) to calculate the number of days from the Start Date to Today. I would like to combine an IF statement to do the following: I only want to return a number IF the Field ‘SOP Status’ contains the words ‘On Ramp’, otherwise return a blank result. Any help is greatly appreciated. Thank you

Hello, I believe this is simple, but I don’t understand what syntax is needed. I’m trying to read the results of a single-select field as a string. I’m doing a running total calculation, but resetting it whenever a certain reading is found. The running total part was working, but I can’t figure out how to get the single select output as a string. When I run this, I get: typeof respGroup.records[0] returns “Object” output.text(typeof respGroup.records[0].getCellValueAsString) returns “Function” let table = base.getTable(‘Prints’); let view = table.getView(‘MTBF layout’); let respGroup = await view.selectRecordsAsync({fields: [‘NDD - Responsible Group’]}); //NDD - Responsible Group must be manually filled out! let elapsedTime = await view.selectRecordsAsync({fields: [‘NDD - Elapsed print time’]}); //NDD - Elapsed print time is a calculated field let groupRecords = respGroup.records; //trying to understand how to get the group records into a string format output.text(typeof respGroup.re

How do I remove a comma from in front of an email that has been extracted from a rollup. I am very new to this formula writing. I have a rollup field that has two emails in it. I have extracted the first email by itself. However, the second email alway has a comma in front of it. I need to remove that comma. How do I do that? Can I do it by altering this formula in any way? REGEX_REPLACE({Email Roll Up from Educator}, “([^,])(.)”, “$2”) Again, thank you for any help on this.

Hello! I would like to calculate a ‘winning streak’. Each row has the result of a game with a column for wins/losses, as well as a column for the dates of the games. I would like to calculate a winning streak. In Excel, I would do this with a self-referencing formula: IF({Win/Loss}=“Win”,{Win/Loss}+1,0), How might I do this in Airtable? Thanks! Here’s a sample table: https://airtable.com/invite/l?inviteId=invEhMSt3pM1PhMUr&inviteToken=022c846bffe765f7904cc3124920d800b61f879f25b7d41b5030bfabcc64b7bb

Hi I would like to use the extension to convert URLs to PDFs. It works for sharepoint URLs but I can’t get it to work for google docs - any idea how I do this? thanks! Clare

Is there a way to achieve this kind of view or similar where I can easily track the release status of my Product? I have two types of releases I need to track, a “Beta Release” and a “Final Release”. Each release consists of many different type of tasks. The tasks are predefined and I would like to enter them at once and be able to glance at them just like the picture here to be able to tell what I need to focus on. I could have many different Products going on at the same time. I would appreciate it if there are any examples

I have a field with multiple select; I need to get a count of EACH selection AND would like to display each response with the count. For background: the field is part of a survey and those filling out the form choose all that apply to them. I tried the linked field route and it counts everything in the field; doesn’t separate them. Do I have to do a linked field for EACH option? I’ve looked at several related items in the community but it all reads like a foreign language that I don’t speak to me…

I’m hoping the community can help me out. I think that my formula is a bit off. Here’s the logic I’m trying to do in the Difference field: If Baseline Value is empty, leave Difference empty If Baseline Value is 0, use the value in Target value If Baseline Value is NOT empty, calculate Target value minus Baseline value divided by Baseline value so I can get the percentage difference As you can see, if Baseline Value is 0 or empty, there’s an error My current formula: IF({Baseline} != BLANK(), IF({Baseline value} != BLANK(), (INT({Target value}-{Baseline value})/{Baseline value}), IF({Baseline value} = 0, INT({Target value}), BLANK() ) )

How can I detect the number of records in each status: Todo In progress Done So that I can notify team members when there’s too many in a column. Example: if more than 5 In progress, notify team Any suggestions?

Hi all - I know dates and timezones are complex, and I’ve tried to do my homework but I’m really stumped. My end goal is to identify records created yesterday and send off a notification. To start, I’m attempting to calculate how many days are between Created Date (w/o time) and Today (without time). Ideally, I would say if Today - Created Date = 1, then that record was created yesterday and I can filter on those records in a view. Trial 1: ‘Created Date’ is set to use GMT for all collaborators, and does not include time I created a formula variable called ‘Today’ with formula “TODAY()”, which is set to use GMT for all collaborators and does not include time. The value shows as 8/31/22. In a formula field I compared the 2 dates: DATETIME_DIFF(Today,{Created Date},‘days’) For both yesterday and today, the value of that comparison was zero with Detail: today is 8/31/22. The record created yesterday on 8/30/22 had a calculated value of 0. The record created today on 8/31/22 had a ca

Hello! Does anyone know how you can transform a week number and a year number to a date?

Hi, I have a base for all of our book projects. Each book get a tab in which I work with the Gantt view. Can I do a sync of all the tabs into a new tab with the same Projects base to see all the Gantt view at once or should I record link somehow? Thank you.

Hi all, I have a problem with a project i am carrying out. I have a table A. with a X record which is linked to a field Y in table B and field Z in table C. After I have a table D. This records are linked to a field in table A. So , records in table D , are linked indirectly to table B and C. Now i have a table E, which is an input record to control hours. When I add a record with a field linked to table D, I can add a field with a lookup function, to show the linked field in table A. My problem is that i need to fill automatically as well, fields Y and Z which are linked to field in table A. Some idea how to perform this task? Many thanks in advance

Hello! I am new to Airtable and have been chugging along until now lol. I have done hours of research and received advice from a few people but I am still very much stuck. I have a multi select field and I am trying to write a formula that takes the options in that field and replaces/substitutes them with values from other fields. So let’s say my multi select field contains the following values: Buyer Agent Closing Attorney Closing Attorney Assistant I want a formula that looks at each value and replaces each one with an email address from a lookup field. ‘Buyer’ would be {Buyer Email} ‘Agent’ would be {Agent Email} ‘Closing Attorney’ would be {Closing Attorney Email}’ ‘Closing Attorney Assistant’ would be {Closing Attorney Assistant Email} The email addresses would need to have commas separating them. And if there is no email address in any of the lookup fields it would just ignore it. Please help!

In the documentation it is provided that we can do a conditional roll up. But i can’t see the option in the tool. Attaching the image for reference.

Hello, I’m Sorry if this topic may have asked before, but I’ve tried searching and didn’t found the similar one. I have 3 sample tables as kind of below, and I don’t know how to realize it to Airtable: the case is if I updated by adding item name ‘A’ to SO with subject ‘ee’, the result will automatically update like this: My main question is how to separate a ‘linked to’ field which is can contain multiple values, to be an individual record/ row, and update it automatically from SOTable?

Hi! Is it possible to compare single and multi-select fields across columns in one table? Would a formula be able to do this? I have a single select field listing the launch month for content. Then there are 2 lookup fields with the launch months for connected content (each with multiple months selected). Ideally, I want to compare the single select field to the 2 lookup fields and output anything that is after the single select field month. Would these fields need to be dates rather than single or multi-select fields for this to work? If so, is there a way for multiple dates to exist in one field? Or is there another way to do this? Thank you!

Hi All, I’m in the process of creating a catalog of related books that I can hopefully email out to customers, and, so far, that’s involved creating an Entries rollup field in my Catalogs table that pulls from my Books table using the ARRAYUNIQUE(values) aggregation formula. I did as much formatting as possible in the Books table, adding caps with UPPER() and spaces with \n, but I can’t figure out how to eliminate the comma after each rollup field item. I tried this: SUBSTITUTE (ARRAYUNIQUE (values), “,”, " + ") But I kept getting “Sorry, there was a problem saving this field. Please check your formula text.” I’ll add a screenshot here so you can see what I’m talking about and why I’d want to eliminate the comma . . . Thanks in advance for your suggestions!

Hi our homepage views have suddenly gone blank displaying no data - if we apply a filter the relevant data appears but without a filter nothing is showing. Personal view are not effected. This is very troubling - we initially thought our whole database was lost. Please can you help us understand why/how this is happening and how to prevent it happening in the future. many thanks Clare

Hi I would like to change the date format returned in my formula field - I’ve tried using datetime-format but keep getting an error DATEADD({Date Invoice Raised}, 30,‘day,’) DATETIME_FORMAT(‘DD-MMMM-YYYY’) thanks Clare

Hi I would like to add a formula field which calculates when an invoice is due for payment. I have an ‘invoice issued’ date field and would like to use that to calculate +30 days. this is where I have got to but its returning an error DATEADD({Date Invoice Raised} +30,‘day’) many thanks Clare

Hey Guys, first time here. Airtable support forwarded me here. I need your help. I have a such formula: IF( {routine type}=‘daily’, DATEADD({task date}, 1, ‘days’), IF( {routine type}=‘weekly’, DATEADD({task date}, 7, ‘days’), IF( {routine type}=‘bi-weekly’, DATEADD({task date}, 14, ‘days’), IF( {routine type}=‘monthly’, DATEADD({task date}, 30, ‘days’) ) ) ) ) and I would like to combine it with something like this: IF( WEEKDAY({next date})=0, DATEADD({next date}, 1, ‘days’), IF( WEEKDAY({next date})=6, DATEADD({next date}, 2, ‘days’), {next date} ) ) Can you help me, please? The first formula creates new task depending on the routine type. Weekly routine, monthly routine, etc. The second formula should move the task to the Monday if the first formula lands task on the Saturday or Sunday. Appreciate your help. Jack

Hello, I have a fairly simple question, but I’m not sure how to do it in Airtable: I have a group of students that are completing book reports. I have the “Students” table with a list of all students, and I’m creating a “Book Report” form for them to fill out when they finish a book. When completing their form, I want them to be able to select their name from a Multiple Select list of students in the “Students” table so that their Book Report will be automatically linked to their record. The form is located in the same “Students” table. How can I create a Multiple Select field on the “Book Report” form which is populated using the Primary ID (student name) on the “Students” table? Thank you!!! -M

Hello community I was wondering if you could help me. I want to make a formula that shows me the emoji “ :white_check_mark: ” if the names and emails are in the contact fields, otherwise it shows me “ :x: ” but I don’t know what I’m doing wrong in my formula. Could you help me?