Ask the Community

Hi everyone,I have an issue with the color formatting for Formula Feilds displayed as progress bars, it seems buggy:With decimal percentages the conditions are not recognized properly, I have the following conditions on a fieldbut the results are unfortunately wrong for values that are near the "breakpoints".Any suggestions?Thanks

Hello! I am creating a form for a table (let’s call it Table A) which has fields linking to another table (table B) in the same base. When filling out the field on the form on Table A, the user can only see the data in the primary field of Table B. However many of the records in Table B have similar primary field data making them difficult to distinguish. Being able to see one (or multiple) of the other fields would be really helpful. For the time being, I’ve made the primary field on Table B a formula that merges the most helpful relevant fields from that table, but it makes all my Table B views very messy/ugly. I wish this formula could be in a non-primary field so I could hide it, but then my Table A form wouldn’t show it. Please tell me there’s something stupidly easy I’m missing! Is there a way for a form to reference/show any thing BUT the primary data? Or is there a workaround I can use with another table? Cheers, Nathan

Hi fellow Airtablers!Could anyone suggest how can I make the ''Next charge'' date field recurring on a yearly basis every year if the toggle in ''Frequency'' is set to ''Yearly''? This dilemma is driving me nuts 😞 Right now, I just have a formula in that field:DATEADD({Latest charge}, 1, 'years')But it's not ideal because I would need to manually update ''Latest Charge'' field with the previous year every year.Ideally, I'd love to solve this with a formula because I'd have lots of entries, and it may be a bit cumbersome to create automation for each and every entry.But if automation to update the latest charge is absolutely needed, what is the best way to go about it/set it up? 

I have set up automations to send messages to Slack channels when specific conditions are met. These automations function correctly, displaying the intended bot name and bot icon. However, I've noticed an issue over the past few weeks. After an unpredictable amount of time, usually about an hour, Airtable sends a duplicate message with "Airtable" as the bot name and the Airtable icon as the bot icon. I'm unable to find a way to prevent or deactivate this secondary notification.Your help would be greatly appreciated. Thank you.

I like this reminder feature I tapped into sometime last year.  I am using it to monitor subscriptions based on their "Expiry Date".The triggers have worked so far, but I just noticed that obviously the Expiry date needs to be updated each time the date passes so that the reminder is triggered yearly/monthly recurrently, until I set the subscription to "Disabled".  What is the best way to do this?Sorry if this has been covered.Many thanks 

Say I have a base with two tables, A and B, where the primary field of B (a single line text field with the name B_name) has values B, 1 and B, 2, and where A has a field, B_name, linking to B. And say I now want to use the CSV import tool to import a single record into table A: A_name,B_name A1,"B, 1, B, 2" When I import this using the CSV import tool, the correct links to B, 1 and B, 2 are not established. How can I either Format the CSV I’m importing, or Configure the import in the CSV import tool such that the correct links are established? Thank you!

Hi! I have recently discovered OpenApi and I am working on a project that requires me to translate text from English to French. I used scripting extension. The script fetches the translation from OpenApi and outputs it to “Translated field”. For some records, Everything seems to work fine. However, for other records the translation doesn’t always work and sometimes it outputs incomplete sentences or random links. Is this because of my script or is the OpenApi random? What can I do to make it work? // Change this to the name of a table in your base let table = base.getTable('Translation'); let openaiUrl = "https://api.openai.com/v1/engines/text-davinci-002/completions"; // Prompt the user to pick a record // If this script is run from a button field, this will use the button's record instead. let record = await input.recordAsync('Select a record to use', table); if (record) { // Construct the body // Change the field name to

Any Idea why the scripting block would give me this error?  I've seen let query = await table.selectRecordsAsync();used in other scripts.

Is there a way to link my Phone Number field to RingCentral so that when I click on the phone number it’ll make an outgoing call in my RingCentral app or give me the option to send a text?

Is it possible to share Airtable automations between other users or bases? I’m interested in the following depending on the situation: Create an Airtable Automation and then share it with another user Create an Airtable Automation and then share it with another base Share a Base and allow another user to copy the base with it preloaded with automations Thanks!

Hi! I'm trying to create an automation to assign a due dates to tasks that all have a due date of Thursday, and the tasks vary by how many weeks out they should be completed. For example, our "Final Paperwork Due" task always needs to be due the Thursday 2 weeks out from the event date.I've been able to make a formula that can automate the deadline to a certain number of days out from the event, but I can't pin down how to always make the due date a certain day of the week. Any help appreciated!

HiI am new on Interface, and I need to know it the thing I want to do can be done and how.  I have a database with thousands of records o cases we are working on.  I need to be aware and in control of several situations, each record is about a case and every case needs start with a formal notification to the a 3rd party, so in the table there is a field with the notified title and 2 posible answers yes or not.In my interface I want to see how many cases have not been notified,  I know I can create a Page in the interface with a record summary and a filter, an then create a button on the interface to open the record summary page.  But, what I want to do is not only see all the cases that are not notified, but also have the possibility to open each record in a diferente page, and work with the record, like edit the fields.  Is that posible? 

Hi folks, It's just a simple question that I wasn't able to find an answer inside Airtable documentation. Is there a maximum number of files allowed in an attachment field? Or is it tied to the max size limit of 5GB?Thanks

I am trying to create an automation that will update a record. I want to add a linked record from one field (Field A) to a different field (Field b). Field A will have only one linked record in it. Field B allows multiple linked records. Right now, whenever i update the record with the info from Field A, it either overwrites everything that was in Field B or it creates a new linked record that merges the info that was in Field A with the info that was previously in Field B. Is it possible to automate this kind of update? thanks for any help! is this possible?

Hello,I've encountered an issue with the DATETIME_PARSE function not correctly converting a concatenated date and time from two fields. Is there something I'm missing?

Hello My department is trying to decide whether to move forward with Airtable or not and the feasibility of the items below would help us decide. Is it possible to do the following in a native airtable form? If so, could someone please tell me the specific steps I should take? I’m currently using the trial version. Unfortunately I can’t use any third party integration but I can use the extensions currently offered within airtable.1/ Can Airtable auto populates fields whenever a selection is made in another field?I thought “link to another record” was it but apparently it isn’t.There are project IDs that the form submitter will choose from a drop-down that are linked to specific tasks, owner names and other values that need to be auto-populated whenever said project ID is selected 2/ Is there a way to create an automation between my form and main excel spreadsheet in Airtable

I have a table from Base A that I've synced to Base B. I no longer need this specific table in Base B, so I would like to delete it. If I delete the synced table in Base B, will it also be deleted in Base A?I checked different threads and couldn't find a definite answer and I definitely don't want to proceed until I know for sure.  Thank you!

Hi there,I'm working on an integrated communications calendar for the upcoming year, and there are some dates where we do not want multiple communications going out. So, I'm trying to figure out the best way to either black out the date (i.e. if someone enters the date no comms should go out when creating a record or filling out a form to create a record, they are forced to choose another date), or at least have a prompt that says "no communications this day, please select another date." Unsure if this would be a function, automation, etc. -- slightly new to Airtable, so any insight would be helpful. Thanks! 

I have a multipart task that I think can surely be accomplished with a few formulas. I looked around the forums for a while and I think I have an idea but I haven't been able to put it all together yet! Basically I have lookup field collating all the dates that a certain client has ads scheduled across multiple products. For our scheduling purposes, the first of each month have a "- [Month]" text added. I want to identify the first date among this group of dates, for a notification automation to let the team know when this client's contract starts. Using a Formula or Rollup field I can transfer that into a string separated by commas. From here, my general understanding is I need to:> Strip out the text so its just dates (I tried REGEX_REPLACE but it also removed everything after the first instance of text. These type of coding funct

Hi Does anyone know of a way to ‘Filter’ a ‘Date’ column by something similar to “this week”? Basically, I’m just trying to create a Grid View that shows - via a Filter - all enquiries that have been received ‘this week’ (which is from Monday through to Sunday of the week I’m looking/accessing the View in). Any help would be greatly appreciated. Thank you Stephen

Hi,I want a URL field to create automaticly with YouTube videos from Field A and Field B.Field A is song title, and Field B is artist, and I need a URL that automaticly finds the music video of that song.Let's use Hello - Lionel Ritchie as an example. I do not need the URL to be YouTube Search (https://www.youtube.com/results?search_query=hello+lionel+richie) But i need the URL to guide me straight to the  music video: https://www.youtube.com/watch?v=mHONNcZbwDY  Is this possible? 

Hey there!I am very new to Airtable. I wanted to connect PowerAutomate to Airtable. I want to use Airtable as alternative to Google Sheets. I created a token in the settings, used the table and base ID (pulled it out of the link like described in the Airtable Documentary) to configure the PowerAutomate step. Then I got a connection prompt asking for the API and a Name. I entered the token I created in https://airtable.com/create/tokens/new and then, tested the flow. Everytime I did that I got the Error: "Authentication required". I thought maybe its because airtable wants to remove API's completely but I am pretty sure I am just doing something simple totally wrong. How do I have to do it right? Best Regards

Hello, Can someone help me if this is possible or not?You may watch this loom for more information.So we have this view called "HitList" which came from the sheet of "Client Briefs" This hitlist has our client list that is waiting for some properties that we need to buy for them. We also have another view called "Rejected" which is under the sheet of "Properties" What I'm trying to achieve is that,Is it possible to gather all of the Rejected properties and group them to specific clients from the Hitlist?Do you think this is possible, if yes could you pl

I would like the holidays to be recurring dates yearly. This is to be included in the same table as the leave tracker so that everything is in 1 calendar view only.

Hi. I am trying to use the "Find Many Records (With Line Item Support) in Airtable" in Zapier and keep getting zero results. My goal is to attempt to return all records that had a specific column modified that day.Airtable:Zapier: