Ask the Community

Hi all!I have two tables, the first is Stores, the second is Customers. They are linked. Customers has a Region single select, Stores a Region multi-select. All of the Region single selects are populated for the Customers tab. I need some help creating an automation or bulk update for the regions of the linked Customers are visible in the linked Stores region field. Thanks in advance! 

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

For the automation above, I kept getting an error OR inaccurate output. When I would test it out and submit a 90% score, it keeps creating a record as if the score was less 89.99 

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

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 instru

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 Lef

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((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? T

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