Ask the Community

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:      

Hello, I have posted about 15 questions this board and I have always received a solution my problem. So thank you all very much. I think I have a really tough one this time. I have a base to manage memberships and donations and legacy gifts for a not for profit. There are 6 membership levels with specific dollar amounts attached to them. So all is well as long as a person pays an amount that corresponds to an existing membership level. But when they pay an amount that is not a preexisting level, I have to assign the difference to a donation.I have a Currency field that records the actual amount paid. I have a formula field (thank you Alexey_Gusev) that shows the membership level closest to the payment amount. For instance, $35 would show as an Individual membershi which is set at $25. I need to then add the remaining $10 the donation field. The next level is $45 for a Family level. To be completely honest, I have no idea where to even

I'm creating a workflow/process tracker using Airtable. I have the following tables:WorkflowsStepsWorkflow RunsStep RunsThe Workflows table contains a list of workflow names, e.g. "New client onboarding workflow".The Steps table contains all the steps within each workflow and I have a link back to the workflow table to know which step relates to which workflow.I have automations in place so that when someone wants to run the workflow it will add a record to the Workflow Runs table and then another automation that will pull all the steps from the Steps table and add them to the Step Runs table linked back to the relevent row in the Workflow Run table.This has allowed me to create an interface where anyone can see the progress of the Workflow Runs and Step Runs that they're assigned to.What I'm struggling with is how I can add unique sub-steps to each step similar to how it is done on the dedicated workflo

Does the web api offer a way to get a field's type?  It seems like the record endpoint  does not this information. I've been looking for a while but cannot seem to find it. Am I missing something?

I have an expense base.It has two tables - All Expenses and Budget.The All Expenses table contains a form that is filled out by anyone submitting an expense. It will categorize based on program, sub-program, and category within that program.The Budget table contains every category of budget items. The overall program, then the hierarchy of sub-program and category within the program.The automation I created triggers upon the creation of a record in the All Expenses table via the form. It is set to find records that match in program, sub-program, and category. Once found, it will update the budget item record in the Budget Table. Specifically, it will update one field titled "All Expenses" in the Budget table. This field is a lookup field to the All Expenses table. There is a connected lookup field that will show the value connected to the title of the expense attached. So, the theory is that as expenses are submitted via the expense form, the automation w