Ask the Community

Hey all, new at the community. Been using Airtbable since many years and love it. Just have been pushing it further wiht scripts, automations, and integrations. Many springs ago (25) I used to be a developer and the database thinking runs still through my blood. So when I make an base with some use case in mind (probably not wherefore Airtable is intended for) I think of tables that have the flexibility of SQL. Imagine thisBase to keep scores me playing boardgames with friends (because we're nerds and we wnat to know who is the ultimate better player over the years etc.) ps. I actually do also serious things with Airtable but this is simple for people to imagine 😄Table: players (list of people)Table: board games (the actual game, eg. UNO)Table: games (a session until someone wins)Table: rounds (all the rounds played in a game until its over)Table: scores (per round, per player) which links to a round & player, and adds a scoreThen in an interface i want to select

I know we have a "Contains" operators which works, but it would be nice to have a "Starts with" operator, for example when dealing names that contains the some or more of the same letters but doesn't start with the same letters.

I have a screenshot above where the linked record displays Tags and Employee ONLY. I discovered that they normally pull the displayed fields from the primary view of the table. However, I already checked my Tasks table but I really cant find the view where this is being pulled from. It's not accurate at all. Can someone please help?

Hi, Could you please help me with a formula I have 3 values: Estimated start dateEstimated end dateEffective end dateToday's dateI want to display "in progress", if I have no value in my effective end date cell and if today is inferior than estimated end dateI've tried the following formula but it doesn't work: IF(AND(({Effective end date})=BLANK(), {Estimated end date (Deadline)} > TODAY()), "In progress")Could you help me please? Thanks,

Is it possible to identify if there are any duplicates in a lookup array? I have 3 tables, all linked together: Entities (companies)MeetingsMonthsEvery Meeting is linked to a month (for various uses) and to an Entity. From the Entities table, I have data as such - the linked meetings and a lookup of their linked months. What I'd like to do is identify if a month appears twice in any row. I don't want to eliminate duplicates (i.e. ARRAYUNIQUE). Instead I need to see if 2 or more meetings occurred in the same month for any company. Is there any way to do that? 

Hey guys, just wanted to check if the charts in the interface are showing for anyone in the iOS App?iPad App does not offer interface support currently?

Is it possible to add color to the automated email body copy. We are hoping to emphasize certain areas of content to our partners through the use of color. Thanks!

I have a field that includes:NameEmailPayment linkPayment_made (checkbox)Created at (Jan 14)Send_reminder_1 (checkbox)Send_reminder_2 (checkbox)If the payment_made is not "check" even after 3 days.I want a send_reminder_1 to be auto-check or something with a formula that will say true.-------If the payment made is not "check" even after 6 days.I want a send_reminder_2 to be auto-check or something with a formula that will say true.-------How can I do this using formula?

 [SOLVED]  Thank you for your help!UPDATE:I resolved the syntax issue.Hi Everyone! I just need help with the search filters.  TYI am getting an error message, when I run my scenario: “The operation failed with an error. [422] The formula for filtering records is invalid: Unknown field names: 321” I need help with:Airtable filter in the Search moduleI don’t know what the make.com filter syntex is for searching records. I am not a programmer, so I will need step by step instructions. The unique ID is SCOTT #. TY 2. Creating filters to avoid duplicate records in my Airtable base, in Make.com for: 1. New Records 2. Update records These search filters will be in the same scenario. I am using a Google sheet for all record data, there are new records and existing records in one Google Sheet. I am attaching screenshots. Any help would be appreciated. I am just starting to use make.com a bit more now and to me, it seems to be a bi

See an old discussion on this but nothing recent...any suggestion on best practices for copying an entire Workspace?  Built a workspace for a non-for-profit organization with multiple geographic chapters, looking for a means to give the tool we've built to others void of all data.  

HiI tried to get all the records in a table by the associated User.Im used make.com to get this information and when I entered this formula and is not working - SEARCH('user_email@example.com', {user_field_name})Does somebody know what is the correct formula? 

I'm trying to create the following automated options in a project management base:2+ days remaining1 day remainingdue today!1 day overdue2+ days overdueThis is my attempt, but I'm struggling to work out how to write the multiple IF statements required to make it happen: IF((ISERROR((ABS(DATETIME_DIFF(TODAY(), {Milestone Date},'days')) & IF((DATETIME_DIFF(TODAY(), {Milestone Date},'days'))<0," Days Overdue", " Days Left"))))=1,"",(ABS(DATETIME_DIFF(TODAY(), {Milestone Date},'days')) & IF((DATETIME_DIFF(TODAY(), {Milestone Date},'days'))<0," Days left", IF((DATETIME_DIFF(TODAY(), {Milestone Date},'days'))=-1," day left", " Days overdue"))))

Anyone have success syncing event details between Airtable and EventBrite?  Make.com only seems to tie to date and name of event, none of the detail fields appear to be mappable.  

Is there a canonical URL that will allow me to display a record in a given table?

Hi,I've created an inventory and order system using airtable but I'm being held back from having airtable calculate my order cost using a roll up. We sell some products with a special offer, for example, a hoodie normally costs £30 but if you buy two it costs £50. Another example, a pin badge costs £4 but you can buy three for £10. I thought this would be really simple to implement but can't seem to work out a way around it and I'm not clued up on writing formulas.Any help would be appreciated, thanks.

Hello, I'm trying to merge records in my table when 3 criteria match. I've been able to identify which records are duplicates, but I am having trouble merging them. Logically I believe my code should do what I want it do, I am not super familiar with asynch and I think that is what is messing me up. When I run this code it throws: Syntax error: await is only valid in async functions and the top level bodies of modules [script.js:33:9] I've been reading through documentation and discussion posts, but I'm not sure what is happening to cause it to throw an exception. Any help would be appreciated.   var table = base.getTable('Testing_500'); var query = await table.selectRecordsAsync(); //let records = query.records; let upPN; let upEM; let upID; //identify duplicates let duplicates = query.records.filter((record) => { return query.records.find((potentialDupe) => { let fName = record.getCellValue("First Names") === potentialD

I am new to Airtable. I have create a Form to capture Emergency Contact Information. When I shared the link, the end user must register to complete this form. Is there a way to have the employee complete form without having to create an account or register?Note - I am currently using the Free version of Airtable. I don't know if this make a difference.

Hi I am trying to update Airtable records using Integromat. I am getting an error: “The operation failed with an error. Insufficient permissions to create new select options” I have found out that it has to do with my multi-select option fields in Airtable (when I remove those options the record gets updated.) I would like to know if there is a workaround or some other solution, so that I don’t have to go back into the Airtable records and manually select all the options. I have over 200 records. I don’t want to have to do this for each record, that defeats the purpose of using an automation app. Is there a solution? Thank you, Mary

Hi. I have a very basic password system that uses letters to denote numbers. The numbers come from a client's DOB.I have a date (DOB) field and another field using DATETIME_FORMAT to only show the numbers (DDMMYY). That's all fine.I would like to have a new field that displays a particular letter for each number - to create a very simple password. Lets say: 1=a, 2=b, 3=c, 4=d, 5=e, 6=f, 7=g, 8=h, 9=i, 0=jIs there a formula that would do this please? 

My airtable has two fields, for example, 1st field name is "Test" and 2nd field name is "Solution". Records from both fields are come from Lookup of other fields so multiple records appear in "Test" and "Solution". i.e. one record of 'Test' contains 'Test item 1, 2 & 3'. One record of 'Solution' contain 'Solution item 1, 2, & 3'.I use below formula to present Test item 1, Test item 2, Test item 3 in separate lines under one record of  "Test" fields. Solution item 1, Solution item 2, Solution item 3 in separate lines under one record of "Solution" field. SUBSTITUTE( ARRAYJOIN({Your Lookup Field}), ",","\n" )However, I would like to present the information in pair but separate line in NEW FIELD?  e.g. 1st line - Test item 12nd line - Solution item 13rd line - Test item  24th line - Solution item 25th line - Test item 36th line - Solution item 3Would anyone propose how to do it? Thank you. 

Hello, We are a custom shoes company and our customers can select their desired heel types. We have 13 different heel types with 13 unique codes (ex. 4544, 2017). Everytime we have an order, we are creating a record line with the necessary information, and one of the columns is HeelType column. We want to create an inventory table that we will update manually when we buy new material, but it will decrease automatically everything time relevant heel is typed in the Order Table. For example, if we bought 50 pairs of Heel 4544, we will increase the value by 50, but we want it to automatically decrease if we write an order record with Heel 4544 on the other table, so it will be 49. Same goes for the other heel types. I feel like this is so easy but I couldn’t manage. Thanks for your help in advance!

Dear all,I'm using the calendar in the interface; in the month view, if there are more items, accondingly to the zoom setting, only some items are visible, while others are not visible, even though the label "+ x more" is present.Even by clicking in the day the other items appear only for less than 1 sec, after the click.Are there some ways in order to see the title of the items withuot open the right summarize column? Thank you. Best regards. A. Borriero

Hi,Every time I try to convert the multiple select field (automatic field from import) to Date (with time included), I get this message that some cell data may be cleared. And indeed, most of the cell data were cleared. I don't understand this as my data is clean it is a standard 03/05/2023 7:00:00, 10/05/2023 7:00:00, 17/05/2023 7:00:00, etc As you can see, the three rows show up blank after I try to convert to Date (with time) field.This is the original data after importing from Excel sheet. Would appreciate any advise on how I could convert all data successfully. Thanks!  

I have a project stage field that I need to convert into generalized phases. I have the below SWITCH formula and I cannot get it to save. All of the articles I have read have examples formatted this way - What is the issue? SWITCH(  {Project Stage},   ’Discovery’, ’In Progress’,   ’Planning’, ’In Progress’,   ’Account Build/Import’, ’In Progress’,   ’Execution/Migration Prepped’, ’In Progress’,   ’Imported’, ’In Progress’,   ’Import Prepped’, ’In Progress’,   ’Complete - Migrated’, ’Complete’,   ’Migrated/Monitoring’, ’Complete’,   ’Project Closed’, ’Closed’,   ’Pending')

Hello! I have checked out the the community for an solution to my problem and can't find what I am looking for to help me with my formula and automation. I am trying to set-up an automatic alert announcing someone's birthday on the day of their birthday. It did work but it sent the announcement the day before as well as on the day of the persons birthday.This is my formula: DATETIME_FORMAT({🎂 Birthday}, "MMDD") = DATETIME_FORMAT(TODAY(), "MMDD") My automation is set up for when a record updates, it sends an email on the day of the persons birthday. However, it sent an email the day before and the day of.I only need it on the day of the actual birthday. Can someone tell me where did I go wrong?Thanks in advance.