Solved

I have a base with two tabs:post IDcontent IDFor each post i can select a content: via link to another record (content ID tab)What I can't manage to get done is the following:I want to go to the Post tab and select "published" next to an post ID & it's according content (from content ID tab) and this information should then also automatically appear in my other tab: content ID.At the moment I found a solution but it adds an extra step. I have connected the two tabs via link to another record but I have to select the post first to get the "published" information transferred. Is there a solution to get it automatically?I would like to add new information to the content (select: published) in the post ID tab, also updating this information for the content used in the post, therefore this change should also be visible in the content ID tab.Anyone here has a solution for this issue?Thanks a lot 🙏

Hello guys!I’m creating a platform for freelance recruiters from all over the world. To help with registration, I created a form and I’m quite happy with it. Also, I would like to have all the registered users in one place in Airtable. I now need this form to be available in different languages: French, German, English, Italian, and so on. My concern is mainly with dropdown fields. How would you proceed? 

I have two Date fields. I need a third field that simply displays the date in the first field unless it's blank, then displays the date in the second field. Here is the formula I'm using: IF({Dev End} = '', {Deadline}, {Dev End}) The formatting options for both Date fields and the Formula field are the same:I'm having two problems. First, the output date in this new Formula field is coming back one day before where it should be. I assume I could just add a day to the result within the formula, but I'm not sure why this happens in the first place. I suspect they have to do with the Time Zone. If I display the time zone, I see GMT, but I can't seem to select my time zone (EDT) unless I also display the time. I'm not interested in the time.The second problem is that I'm not able to use the Formula field as the end date in a Gantt view. I received the following error: I assume this may also be because of the time zones.Can I globally set the base to use EDT rather than

Sorry if something similar has been posted already - I'm hoping to figure out an automation where when a record on one lable is labled (via checked checkbox) as a primary contact, that record links to the "primary contact" linked record field on a different table. In a perfect world, this could coincide with an automation where if the primary contact changes (a record is unchecked), that record is unlinked, and replaced with the new record.Or - is this possible to do with conditional formatting at all? I can provide screenshots if that would be helpful!Thanks all!

I am trying to do a formula where I have a row with numbers (=calculation field/column) and depending on the number a certain text value (Tier 0 / Tier 1 / Tier 2 / Tier 3) should be the result in my formula fieldTier 0 : 500,000 - UnlimitedTier 1: 100,000 - 500,000Tier 2: 40,000 - 100,000Tier 3: 500 - 40,000I tried several approaches but none of them worked, I always get an error message.IF( {Calculation} < 40000, "Tier 3", IF( {Calculation} < 100000, "Tier 2", IF( {Calculation} < 500000, "Tier 1" , IF( {Calculation} < 100000000, "Tier 0"))))ORIF({Calculation} < 40000, “Tier 3”, IF({Calculation} < 100000, “Tier 2”, IF({Calculation} < 500000, “Tier 1”, “Tier 0”)))ORIF({Calculation} < 40000, “Tier 3”, IF({Calculation} > 40000, “Tier 2”, IF({Calculation} > 100000, “Tier 1”, IF({Calculation} > 500000, “Tier 0”, “n.a”))))Any ideas what I did wrong?Thanks 🙂

Hi, i have a formula field named "Jenis Parts Regex" where its value is "15.9mm Karet stabil FR RH/LH ES1|05".I want to extract anything that matches "end_of_name" field, in this case "ES1|05", and the result shall be in "regex replace" field.But what i got there is "15.9mm Karet stabil FR RH/LH |". Why am i getting "|" ?Here is my formula in "regex replace" field:REGEX_REPLACE({Jenis Parts Regex},end_of_name,"")Please helpThanks 

Hey all - I'm running a formula column with a lot of IFs in there. Only 1 out of the 6 possible responses returns a text field, the rest are date fields.The dates come out in a very ugly way, this is how it looks: 2023-07-12T23:06:37.000ZIt basically makes it impossible for me to use / property view.After some playing around with it, I've understood that the issue here is with the fact that one of the values returned is a text field.However, the way I have the formula and the intended use. Unfortunately, I can't do anything else but have a text in one of the IF's (since it's the if true, not false, that I could just leave empty).I've tried using the time parse formula like this: DATETIME_PARSE(the if formula), but the result is an error.How do I make this work?

The Airtable product team track record continues to baffle...I suddenly got the new record details layout experience, and although a bit surprised after having no mention of it in the What's New July 2023 edition that went out barely a week earlier, I was initially excited. The redesign is clearly inline with the record detail view on mobile devices (hinting at mobile interfaces coming soon??)...That is until I realized that it completely broke the ability to change edit permissions on linked record fields where the records are one-way synced from another base. As in, if you had fields that were set to editable before this update, they are stuck on being editable, and if you have non-editable ones or try to add new ones, they are stuck on being non-editable.If you hover over the "Allow users to link/unlink existing records" switch you see this message: "Users can't link/unlink existing records because this table is synced from an external source."To clarify: This started with

Hello! I am currently trying to extract information from an inconsistent string of text and having a tough time.Ideally, I would be able to drop the MONTH and DATE from the String of text and KEEP the all the text along with just theYEAR. The trouble is, both the intro text (represented as X's) and the dates are not consistent lengths. EXAMPLES OF TEXT:  DESIRED OUTPUT: XXXXX.RTW.Men.7.5.2023XXXXX.RTW.Men.2023XXX.RTW.Women.12.10.2022XXX.RTW.Women.2022XXXX.RTW.11.6.2022XXXX.RTW.2022Is there a formula that can do this? I am not great at these types of formulas (and I feel like this is potentially very simple!) - hoping someone can help! Let me know if I can provide further info to provide a solution. Thank you in advance for your help! 

I run a volunteer program where we reward our volunteers with comp tickets to our events.   We currently use a points based tracking system where they get 10 points for every hour volunteered.   I was wondering if there was a way to create something in Airtable that would help us keep track of how many points our volunteers have earned  and redeemed.    So whatever would be created I would need a way to add points and subtract points with ease. We allow our volunteers to bank their points to redeem and "upgrade" their tickets to better seats on the following scale:Tier 3- 40 PointsTier 2- 80 PointsTier 1- 120 PointsPremium- 160 PointsIt would be a bonus if the same base would allow them to request their redemption. 

Hello!How I can join two columns what I need Join with IF - example:AreaCityLocationHaljalaHaljalaHaljalaHiiumaaPaladeHiiumaa | PaladeMuhuMuhuMuhuKullamaaKullamaaKullamaaSaaremaaAsteSaaremaa | AsteIf the City and Area name are same then formula shows that name only one timeIf City and Area names are different then formula shows two different names With space or some symbol between them

Hello, I'm trying to formulate a triggered response, based off the fields value.For invoicing, I want it to send out an email if the record's field value is "Invoiced". I currently have 3 options for this field: Not Invoiced, Paid & Invoiced. IF the operator selects "Invoice" from the drop down of that record - it should automatically send an email to that contact. I have a field in that record as "Billing Contact" and it links to the customers DB table. I also have the PDF attached to this record as an extension for the customer to see once emailed. Any way I'm able to go about formulating a triggered response in automations?Thanks

Hi! Maybe someone over here can point me in the right direction. I am trying to build a custom extension, but the moment I add the extension airtable.com becomes “not secured” causing CORS issues with my extension. At the beginning I thought it might be my code, but I tried it with the “Hello World” extension and the same issue, the moment I add the localhost connection the site switched from secure to not secured Any ideas what I might be doing wrong or what else I could test? This is happening with Chrome, haven’t tested yet with other browsers. Thanks in advance

Hello everyone,I would like to run an automation to keep track of the previous values of a cell so that I can see how inventory is being withdrawn from the database and have a correct running tally of inventory items.Currently my airtable is set up like this.The quantity removed field is constantly updated as product is removed. I would like to have the sum or some record of all the values ever written into this field in the previously removed field. I have tried formulas but I keep running into circular references. Therefore I am trying to create an automation which will add the new the new value entered to the quantity removed field to the previously removed field value.For example: on the first day Quantity removed is entered from softr and now has the value 15 for a particular product. Therefore previously removed should be 15. On the second day another entry is made to the Quantity removed (value 20). Now the previously removed value should be 35.This must all happen to the s

I am trying to create an automation that updates all records in a table at a specific interval. The automation needs to look a single select field and based on what it is set to update another single select field.The automation works when the trigger is update or create, but the time interval trigger is eluding me.The automation is set to run every 15 minutes, and it looks for specific records. But How do we tell it to update individual records from the list it found?

I received the following prompt from Airtable's IDE, but I don't understand what it is asking me to do?Could someone please give an example as to how I would pass options.fields to selectRecordsAsync()? TIA!"Calling selectRecordsAsync() method without passing options.fields is discouraged.  Passing options.fields allows you to request just the fields you need."

Hello all, I'm working with formulas, but got stuck on something. What I'm trying to accomplish here is simple, but not sure how to formulate it. I have a linking record for an invoice for NET Terms: NET15, 30 etc. I have the formula set up, but I want that converted into a date format rather than what I have.  IF({TERM}="NET15", "15 Days from 'Due Date'", IF( {TERM}="NET30", "30 days from 'Due Date'" ) )  Simple, but this is the output:Pretty simple, however I was testing the formula, and for invoice structure - I wanted a date format approach. So If NET15, then have the "Due Date" 15 days BASED off of the "Date" field. I don't know how I'd structure that, but that's the primary goal. Instead of showcasing "15 days from 'Due Date'", I'd rather it show a date format. EX: Date: 7/9/2023 Due Date: 7/24/2023 TERM: NET15Any advice would be helpful! Thanks. 

Good afternoon! There are several product sections, each product has its own identification number. How to make the id is filled in automatically in a row (example P00005) and you need to save the number of characters (example, P00009. P00010)

Hi,I want to send forms to end users, using a link sent via mail.the link contains data that should be uploaded to the form with info relevant to specific users.I created the URL to the form successfully, but when I send the mail, the user receives it as a text and not hyperlink.the link to the form is very long, so I suspect that this is the reason it doesn't become active.Any Ideas on how to approach this issue?ThanksNitai

I want to send an email every day at 12:00 p.m. to each record that matches a specific criteria. Trigger: At a scheduled time Actions 1: Find Records Actions 2: Send Gmail When I run the application with the above settings, the email addresses of the target users are included in the cc and the email is sent all at once. How can I send each email individually?

I'm building a base that users can copy, and I notice all my tables, records, fields, and extensions copy over when I create a template of that base. However, I'd like the templated base to include the automations I built, plus the interfaces if possible. (Honestly, the automations are more important.) I've poked around the Community and even asked ChatGPT (which swears this built-in functionality is possible in Airtable, but I can't find it!).I see other topics in the Community related to duplicating bases (and thereby duplicating automations) but this base template will be set up for other users to use as a starting point, and they wouldn't have access to the backend of my Airtable system.Thanks for any guidance!

Hi, I've searched for an answer but haven't found anything posted recently. Thanks for any help.Simple question. I'm looking for records daily at 3 p.m. that meet certain conditions. If I find them, I send an email with the records. But is there a way to do nothing if I don't find anything that matches the conditions? Will the automation automatically abort if conditions are not met? I don't want to send blank emails. Thank you.

I have 2 tables each have one common column i.e website. How can I generate 3rd table which will be intersection of table 1 and table 2?Note: I am using airtable free plan

Hi I'm trying to use a nested formula to calculate a risk matrix if an entry has different conditions: F({ Platform product data sources (from Submissions)} =Platform Product/Data, OR ({Subproccessor (from Submissions)}=Subprocessor), ‘CRITICAL’,IF ({ Platform product data sources (from Submissions)} =HRIS (People data), "MEDIUM",IF({Platform product data sources (from Submissions)} =Commercial and Financial platforms/data, 'HIGH','low’)))But I'm getting a formula error, I'd appreciate any help on where I'm going wrong! Thanks! 

Hi all!I was wondering why ARRAYJOIN(values, "\n") is not working in my base.The only way I have been able to achieve line breaks is by creating a formula field.I added some screenshots!Thanks!