Solved

On my AirTable, it sends out an email when a view updates because the view in question is made to track employee records that are past their respected due dates. I would like an email to be sent out every Monday and Wednesday to the specific employee/collaborator, alerting them to follow-up on the past dues–until they no longer appear on the list. How can I do that? Drew

I am trying to solve the following problem. I have thousands of registration numbers that always start with a “T” and are followed by 10 digits. This is how they are delivered to me T3090728379. But they all need to look like this T-309072837-9 which translates to the following format T-[9 digits]-[1 digit] The last digit can be anything between 0-9. What formula could I use to reformat these fields in Airtable? I managed to substitute “T” with “T-” but I do not know how to get a hyphen in front of the last digit. Is this something one would use the LEN() function for? (I have never been able to fully understand how this works…) I’d appreciate any help. Thank you so much in advance. This is how far I got: IF(STRING,SUBSTITUTE(STRING,"T","T-"))

Hello. I have built several Interfaces from a particular Base in my Workspace. However, I need to move that particular Base to a new Workspace. When I move this base will the associated Interfaces also move or will I have to recreate them all again from scratch (shudder!)?

Hi, I need help to split this string into four pieces and put them in four new columns… Maybe split two times with different delimeters? {“email":"mail@gmail.com”,“firstname”:“John”,“lastname”:“Hong”,“phone”:“1234567”} Column 1: mail@gmail.com Column 2: John Column 3: Hong Column 4: 1234567 Thanks in advance!

Hi all! I’m on a fairly time crunched project and am stuck on solving a problem. Specifically, I am fetching data from an API using DataFetcher that is a table of products that have columns with “tags” for the product. There are a total of six columns with different tag names in each column. What I’m hoping to do is in a separate table entitled “Tags” to a have a column key where each record is a unique value of any tags in those six columns in the other table. Ideally, this would also update automatically when datafetcher runs and updates the other source table and new tags are added. Is this feasible? Many thanks in advance for any consideration.

Is it possible to color code a record based on a due date, but just the ones that are in the current week? Example: Today is Thursday, so all the records with a today or tomorrow (Friday) due date would be colored red. I know that color based on “within the next week” or “within X number of days” exists, but I need the records for the current week only. Thanks!

I’m using Airtable to build a list of donors for our non-profit organization. The records are identified by the name of the donor. Some donors make multiple donations throughout the year. How can I reflect these frequent donations without building a whole new record? Thank you so much.

Hi there, I have two different forms feeding the same table. I am trying to teach my students about A/B testing to figure out which is more effective. I can’t find a field that gets passed indicating which form the information comes in from. Does that exist, or is there a quick workaround? Thanks!

Hi all, I’m trying to create a formula to help me calculate invoicing periods. If the payment date is before the 20th of the month the invoicing period is the current month, if the payment date is on or after, then the invoicing period will be the next month. Essentially, there should be two outputs, the first day of he current month or the first day of the next month. I’ve tried to build this with an IF formula, but I’m coming unstuck with the first half of the formula when testing as it doesn’t seem to be calculating correctly: IF({Date paid} < DATETIME_FORMAT({Date paid}, ‘20/MM/YYYY’), DATETIME_FORMAT({Date paid}, ‘01/MM/YYYY’), “test”) How anyone advise on where I’m going wrong on this one?

Hello, I’m trying to summarize information in a Linked Record field type collected through Forms in which respondents can select multiple linked records. We invite respondents to select their Subject Area Expertise, options provided are categories from a sector-wide set of standard taxonomy. The Subject Area taxonomy is organized in a hierarchical manner. For example: Level 1 (Category): Health (SE000000) Level 2: Nursing Care (SE060000) Level 3: Home Health Care (SE60100) Level 3: Hospice Care (SE60200) Respondents can select from the whole list without seeing the hierarchy. I would like to generate charts that summarize and collapse respondents’ answers. Using the example above, I would like the chart to collapse all individuals who selected “Home Health Care” and “Hospice Care” to fall under the bar/pie chart slice for "Health" I tried using a lookup field for each Subject Area’s category, but it duplicates responses In the example below, the row with three different “Environment”

Hi, i have two forms named form A and form B in two different pages and on airtable when the webhook is received, i need to run a script to check whether the data is coming is either form A or form B( either by form name or by hidden field). Am new into this and am not able to run the script functionality using this. am confused about data fetching. Could anyone please help how to update script code to check conditionally which form is submitted when a webhook is received?

Hi all! I’m looking for a way to copy airtable record URLs in bulk. In order to find a specific record’s URL I need to right-click it and select the option “Copy record’s URL”, but how do I do it when I need to copy the URLs of 1000+ records?

I currently have the following IF nested statement. I don’t get an error when saving, but it only works when the first IF is found (13) and produces nothing for a result when the other two are in the identified field to check. Am I missing a key element to make the “false” portions of each IF statement work with a new nested IF statement? IF({⛔ Extender Weeks}=13, SUM({👌 WEEKS in Program (26 = 6mo)}+13, IF({⛔ Extender Weeks}=9, SUM({👌 WEEKS in Program (26 = 6mo)}+9, SUM({👌 WEEKS in Program (26 = 6mo)}+4)))))

I’ve read the community for how to get the harder-to-read date cleaned up for automation with emails that include that field. I made a new column that formats the date/time to MM/DD/YYY and it populates fine in the table. However, the emails show nothing of that date and just has the space blank in the email. Here’s the formula I have to set the date format: Any suggestions?

I want to write a script that copies the value from one field to another field in the same record. Trigger and condition are already set up. But I don’t get the script done. Automation trigger: When record enters view. (Done) Automation condition: When field ‘Album_curated’ is empty (Done) Action: Run script that does: Copy value from field ‘Created’ to field ‘Album_curated’

I’m struggling to pass an empty date to Airtable without throwing an error. My integration is with python, and so far I’ve tried an empty string and Python’s None (i.e. null) keyword. But with the None keyword I run into this error… ‘422 Client Error: Unprocessable Entity for url: https://api.airtable.com/v0/…[Error: {‘type’: ‘INVALID_VALUE_FOR_COLUMN’, ‘message’: ‘Cannot parse date value “None” for field Effective Date’}]’) Passing None to other fields clears the fields correctly so I’m really hoping this isn’t an API limitation where we can’t clear dates? Thanks for any thoughts!

Hi all, I have a form which sends data into a grid view. One of these columns has 7 options as a single select each with a rating number followed by a rating name. I created a column within the grid view that runs a script I wrote which essentially checks the input column and isolates the rating number in the new column for quick data pulls. However as our form inputs increase, I created an automation that would run this script every time a form was submitted and lately I have been getting the 15 mutations error. Would anyone be able to help me review my code and see if I wrote an unsustainable program? let table = base.getTable("Intakes/Submissions"); let view = table.getView("Partner Creator Survey External"); let csat = await view.selectRecordsAsync({fields: table.fields}); for (let line of csat.records) { let csatRating = line.getCellValue("CSAT Creator"); switch(csatRating.name) { case "1. Very dissatisfied": await table.updateRecordAsync(line.id,

I have two separate tables… contact list (table A) and an interaction log (table B). I’m trying to get a ‘date’ field from table B to be auto populated to the respective contact name in Table A. I have it already set up to link the table B record to a field in table A, but I need the date added to a separate field so that I can use the calendar view… I was able to create the automation – when a record is created in Table B, the action is set to create record in table A. but I don’t want to create a new record in table A (just need it to update a record) HELP PLEASE

I wrote a very simple formula for my first field column to include fields from other columns in my table. I have only two fields in my formula with text strings to include spaces between them. My issue is that one of the field ends up between two brackets like this " ". As you can see, the field Prix Fab Gastier is = 12" BW STD in the table, but in my formula it returns “12"” BW STD" So why is there in total 3 additional " ? One before the 12 One after the 12" and one after the STD

So I have a table called “US states”, which other tables have linked fields to. One issue I encounter often is that when I have a form in a different table and add a field called “Select state”, which is linked to the “US States” table, I often have people who fill out the form start typing in the state and accidentally insert a new State (sometimes misspelled or sometimes just the abbreviation) thereby creating a new record in the linked “US States” table. Is there a way that a linked field in a form restrict creation of new records and only allow users to select from the list of linked records?

Hello, I am wondering how you can prefill a form where the field type is “Checkbox”. For instance, I have a Contact Info form I send new clients. I have two Checkbox fields that I do not want them to see but would be helpful for me to be checked. When checked, mark the client as being an Active Account and an Active Contact. Field Names “Act. Acc.” “Act. Con.” Example Prefilled Form URL Client Contact Info Form???&prefill_Act.%20Con.=???&prefill_Account%20Name=Client%20Name&prefill_CSM=First%20Last&prefill_ST=UT&prefill_Acc.%20Exec.=First%20Last&prefill_Account%20Name%20Dropdown=Client%20Name Thanks in advance!

I’m looking to create a datestamp field based on if a Single Select field is either COMPLETE or CANCELED, otherwise it should remain empty. I’ve searched through this site and tried a variety of options but have had no success. IF(OR(Status=“COMPLETE”,“CANCELED”,LAST_MODIFIED_TIME())) **This returns all cells as blank Thanks in advance!

Hi! I’m working on setting up a long-running {Task Due} date formula field that will eventually span across multiple years. The {Task Due} date is already successfully calculating a variable workday amount prior to the {Key SR Date} (the date of the actual event) using negative values found in the {Days Out} field. I’ve created an IF set up to accommodate some of the {Days Out} are 0, where I want the output to be the same as the input. Here’s the formula I’ve got going successfully: IF(({Days Out}=0), {Key SR Date}, (WORKDAY({Key SR Date}, {Days Out}))) Now, I want to factor US holidays (and specifically a string I made for my company’s holiday list). I created a separate table with a {Reference Year} and a {Holiday String} field so that I can create a string for 2022, 2023, etc. I’ve used lookup fields on the current table so that the correct Reference Year is applied to each record, and it displays the applicable {Holiday String} from the other table. My thought was, shouldn’t I be

Hello all, I started a base and before I get too far I thought I might ask the community to help me start on the right track. I would like to track the fabrication of a lot of piping assemblies. Here is what I have in mind : One table for the list of pipe assemblies to track the drawing status (for comments, for construction) One table to track the fabrication status (drawing for construction received, in progress, completed, shipped to paint shop) For this step I would like to have an attachment for the invoice from the fab shop and the delivery bill from the fab shop to the paint shop One table to track the paint of each assemblies (received from fab shop, in progress, completed, shipped to work site) For this step I would like to have an attachment for the invoice from the paint shop and the delivery bill from the paint shop to the work site One table to track the receiving of each assembly to the work site (received from paint shop, installation in progress, completed, inv

Hi! I am trying to write data to a airtable from Rasa chatbot. But when i run the code, it returns me a 422 Client Error: Unprocessable Entity for url: https://api.airtable.com/v0/<base ID/<table_name> error. load_dotenv() airtable_api_key = os.getenv("AIRTABLE_API_KEY") base_id = os.getenv("BASE_ID") table_name = os.getenv("TABLE_NAME") def create_convo_record(category, price, storage, ram, battery): request_url = f"https://api.airtable.com/v0/{base_id}/{table_name}" headers = { "Content-Type": "application/json", "Accept": "application/json", "Authorization": f"Bearer {airtable_api_key}", } data = { "fields": { "category": category, "price": price, "storage": storage, "ram": ram, "battery": battery, } } try: response = requests.post( request_url, headers=headers, data=json.dumps(data) ) response.raise_for_status(