Solved

I have 2 different kinds of {App Pseud} formats, e.g. kay_obsessive goblin fic (Kiestan) Then I have a formula to spit out a URL, where the concatenate is the important bit: IF(OR({Work Submission Pseud}!={Synced Participant},{Assigned Writer(s)}=BLANK()),BLANK(),CONCATENATE("https://autoao3app.firebaseapp.com/#/mfd2021_round2/user/",SUBSTITUTE(TRIM({App Pseud})," ","%20"))) And it spits out these URLs: https://autoao3app.firebaseapp.com/#/mfd2021_round2/user/kay_obsessive https://autoao3app.firebaseapp.com/#/mfd2021_round2/user/goblin%20fic%20(Kiestan)n The extra character on URLs where the app pseud has a parenthesis always matches the character just before the ). I don’t see what is causing it in the formula. Help!

Hi, I am currently connecting to airtable data via the API. I am able to sort my response in certain fields using desc and asc. However for non text fields in particular single select fields where in the UI you would sort First-Last. What would the parameter be for sorting these fields?

Part of my custom APP takes a number of different user inputs from a UI, and writes some of the resultant information as a new record in a table. In particular I want to do the following: Write a string value to a linked field in an existing table The string value to be passed is already guaranteed to exist as one of the linked options (since the user selected from a Select menu which is in turn populated from the table. *There are some other fields which need to be written as part of this record. The code looks something like the following. `` let machineNameField=tableTasksByMachineNumber.getFieldByNameIfExists(‘Machine Name’); let machineNamesRecord=useRecords(tableTasksByMachineNumber,machineNameField); let machineNamesList=machineNamesRecord.map(record=> {return(record.getCellValueAsString(machineNameField))}); let machineNamesListFormatted=machineNamesList.map(x=>{return({label: x, value:x})});` Machine Selection <Select

I’m developing an API on Node.js + express on Heroku, and every time I fetch anything with POST, I get a 400 Bad request error. Postman requests to the same endpoint work perfectly. So the only hypothesis I have is that I need a ‘Host’ header in my Airtable request (when I remove the ‘Host’ header in Postman. I get the same 400 Bad request error), but I don’t know what this ‘Host’ header should be. To reproduce: Create a simple Node.js+express app on Heroku where you return the same body as you get: app.post('/', (request, response) => { response.status(200).send(request.body); }) Create Airtable automation with fetch (or an app with remoteFetchAsync): let response = await fetch('https://....herokuapp.com/api/', { method: 'POST', body: JSON.stringify('Hello World!'), headers: { 'Content-Type': 'application/json; charset=UTF-8', 'Accept': 'application/json'

Hi, So I’m trying to have a single select field type of small mammal species of the world, that should have a list of more than 300 species to choose from; so when i select an option from this field A, i need a formula field B to be automatically filled out with the relevant ‘Genus name’ based on field A. I have tried using SWITCH, but I am allowed to enter a maximum of only 150 species. Is there a solution that would let me add 300+ options to the formula field, without having to create or link multiple tables?I have no experience in coding, so don’t know if this can be done using the scripting app? Here’s what the formula in Field B-‘Genus name’ looks like: SWITCH({FIELD A},"Hairy-footed Flying Squirrel","Belomys", "Namdapha Flying Squirrel","Biswamoyopterus", "Grey-bellied Squirrel","Callosciurus", "Pallas’ Squirrel (Red-bellied Squirrel)","Callosciurus", "Grey-headed Flying Squirrel","Petaurista", "Large Red Flying Squirrel","Petaurista ", "Spotted Giant Flying Squirrel","Petaurist

I have a table for Users, the primary field is UID, I have email, name, created time. I have a table for Orders. It has Order IDs, email, final price, order place date. I have a table for Cancellations. It has cancellation ID, email, cancellation date. I have a table for User updates. This ha User ID, email, new email (if updated), new name (if updated). All tables are populated automatically from Zapier upon events in another system. I would like to show the SUM of all order placed for the specific User ID under Users, however I can’t seem to link this via UIDs? Does this mean I have to change the primary column in both places to Emails? I need a custom field under Cancellations, that looks up the last date an Order was placed and adds a month to it. However, Cancellations does not have user IDs… will I also have to use emails here? Last but not least, User Update rows might indicate an email update. E.g. a user might now have a new email. What do you suggest I do here if I start usin

I’m using a base to record survey answers. The questions are constructed in a way that all answers are Yes/No. I’m using a single select field for the answers and I want two fields that will provide the total number of “Yes” answers and the total number “No” answers for each record. I realize I can create two additional fields for every question that will store numeric values for each answer choice and then use two SUM fields to provide a total for each type of answer, however this will result in two additional fields for every question. I’m hoping someone has an idea for a more elegant solution; most likely involving a script.

Hi! I’m trying to create a prefilled form URL, but I believe the prefill isn’t working because I’m trying to prefill information with hyphens. Any ideas on how I can make this work? Example: Field Name: Type Name Example data: Apples - Michigan Form URL: “https://airtable.com/shrxxxxxxxx?"&“prefill_”&ENCODE_URL_COMPONENT(“Type Name”)&”="&ENCODE_URL_COMPONENT({Type Name}) How do I make sure “Apples - Michigan” doesn’t break the URL (and in turn, not prefill the form)?

Hello! I am organizing and archiving all the films shown from our local cinema. We started in Google Sheets andhave now imported into Airtable. Now we have seperate fields for the Year the film was shown, the month and the day. Is there a formula that combines the numbered fields to a date field? I can’t seem to find it anywhere. Can anyone help? I asume this isn’t the hardest formula, but I don’t know how to do it. Thanks!

Is anyone seeing any errors for Integromat scenarios which are querying Airtable? Getting “Operation Timed Out” errors across multiple scenarios and accounts. Ruchika

Hi - I think I need a scripting app to solve my problem, but I’m new to Airtable scripting and so am reaching out for help. I have a table that I’m populating every day, but I want a 2nd grid/view with only the latest record showing. So I wanted to use a ‘latestrecord’ checkbox column, and use a script that would fire on a create record trigger to basically reset the checkbox on every row, and then only set it for that latest record that was just inserted. My 2nd view would be filtered on this checkbox - which would then be used in a combination of charts (on all content) and summary apps (just on the latest record) in a dashboard. I’m struggling with the scripting syntax, and so just felt it would be easier to stand on the shoulders of giants, and ask the community! Many thanks in advance, Dave. Note: I’m struggling with even reset all the checkboxes - the following code runs but just doesn’t seem to work (resetting/clearing all of the ‘LatestRecord?’ checkbox columns to be blank/un

So when I first built this IF statement, it brought back “Drabble” correctly when the Word Count was 100 words: IF({Word Count}=100,“Drabble”,IF({Word Count}=200,“Double Drabble”,IF({Word Count}>39999,“Novel”,IF(AND({Word Count}>17499,{Word Count}<40000),“Novella”,IF(AND({Word Count}>7499,{Word Count}<17500),“Novelette”,IF(AND({Word Count}>1000,{Word Count}<7500),“Short Story”,“Ficlet”)))))) Word Count was using the formula provided by airtable help (which is bunk), that is IF({Text}=BLANK(), 0, LEN({Text}) - LEN(SUBSTITUTE({Text}, ’ ', ‘’))+1) When I pasted in a long text that I already knew was 200 words and it brought back 185, I knew I was in trouble. Long story short, it turns out that word count formula in the official help counts the number of spaces and only works if you limit yourself to a single paragraph. So… Now I have the Space Within Paragraph Count field: IF({Text}=BLANK(), 0, LEN({Text}) - LEN(SUBSTITUTE({Text}, ’ ', ‘’))+1) And the Paragraph Count

I’ve done a ton of searching and can’t find any answer to the possibility of using an Array (list) in one field of a base as a search input for another field. I do not want to ARRAYJOIN(values) as I am not searching for the total string, I want to take an input SEARCH list of any values, and search each list item independently within another field. I’ve built a complex Theater scheduling base where there are company members, teams which contain company members, staffing which is a member, availability of each member, and junction tabled them to fit into a scheduling table that is connected to a Show table (date,title) My goal is to be able to compare the list of members on a team against their individual availability. Is it even possible to search each item independently (Team Member) that is within an ARRAY/List (Team) within another field that also contains ARRAY data (Member Availability)? I’m assuming this will need scripting to take the input search list then go one after the oth

I think this may not be possible based on Access fields from linked record in formula without creating Lookup fields - #2 by Kamille_Parks but I’m going to try anyway! I have a pretty complex base based on some longterm needs and incoming records and trying to squeeze things into Airtable that aren’t quite possible. Right now, I’m dealing with two tables that are linked together and linking existing records together. Table 1: Main table. Table 2: Form submission. Table 1: Over a years’ worth of information about people, including linked records of people who are in relationship with one another. Table 2: People who exist in Table 1 one are submitting updated information about themselves AND other people that exist in Table 1. When someone submits information via a form, we link their record to their record in table 1 (usually by the VLookup automation, but since this breaks a lot, often manually.) Table 2 has an important field called “Can you continue to pay for groceries?” that is fi

Hi all! I’ve been working on utilizing scripting within automations for a project. When a record in a table “MPList” is updated, I want to see if that record’s sort name matches any sort names in another table “memList”. If there is a match, I want the trigger record (from MPList) to be updated. I’m attaching my code below, and I think that one issue I’m running into may be with the input.config() process. The “toMatch” string in the test output window displays the ID, Name, and color for the text field it was pulled from. So, I’m not sure whether the Name of toMatch is correctly being tested for equality with the “Sort Name” field from the other sheet on line 9. let toMatch = input.config().toMatch; let mpList = base.getTable("Imported"); let memList = base.getTable("Members"); let query = await memList.selectRecordsAsync(); let result = false; let member = false; for (let record of query.records) { if (record.getCellValue("Sort Name") == toMatch) { await mpList.updateRec

Hi Team, Looking for some assistance on a formula. I want to know if the created date and time is within the last 12hrs. Thanks in advance!

Hello! Im trying to create an automated reminder - after setting a certain date record, a new field will be automatically filled with a date + 30 days Example: I filled the 1/1/21 in Date 1 - and I want Date 2 to be auto-populated with 1/2/21 Help please :pray: :pray: :pray: Thank you! Liran

I need to calculate a number based on selected single select option in another field. For instance if the users chooses “Excellent” then the number should be 10, if the users chooses “Good”, then the number shoud be 7, if the users chooses “Fair”, then the number should 5, if the users chooses “Poor”, then the number should be 3, other wise it should be blank. It so that I can then tally the score of nine different fields for a total score. Suggestions?? Formula? I’m fairly new to Airtable and I’ve trid numerous formulas toget this to happen an so far have failed.

It appears that I’ve merged some records accidentally and lost data. Is there a way to undo this? I’m looking at the record history and don’t see the old information, unfortunately. In this screenshot, this record should have more than one hour of history. (Edited to remove identifying information)

I was looking at some of the third party apps in Marketplace and am a bit concerned about the apparent lack of support for privacy. When clicking to add any of the apps, there is a standard phrasing, which includes the name of the app: “Your use of the app is subject to [app provider]'s terms and conditions and privacy policy” Given that many of the apps don’t have a website (so the support link is to Airtable support), there is no privacy policy or terms and conditions. Even where there is a website (eg for miniExtensions) the privacy policy and terms and conditions on the website relate only to the website, and not the app. Are all of the 3rd party apps at our own risk, as it were? What checks do Airtable do on apps before they are added to the Marketplace? I’m thinking that this means my organisation won’t be able to use any non-Airtable provided apps…

I’m pretty sure that in the past there was an info icon next to the view name, which showed the view description when you hovered over it. That has gone. 2 days ago I had no way to view the description at all, unless I edited it. Today I can see the descriptin when I hover over the view name (info icon still gone), but the formatting is lost (no paragraph spacing) and it’s truncated: This isn’t great, as I was using the view description to provide summary instructions for users, to reminde them what they should be doing there. (And so they don’t need to refer to our documentation constantly.) Apologies if I’ve missed a ticket on this. I did search but couldn’t see anything.

Hi - I created a column with an IF statement that pulls phone numbers entered from a survey into the field IF we haven’t recorded the phone number ourselves manually (the survey column is called Phone Number and the manual column is Phone # to differentiate). The formula is IF({Phone Number}, {Phone Number}, {Phone #}) When the numbers are pulled, some of the formats are in the form that the client filled out XXX.XXX.XXXX but we want it in (XXX) XXX-XXXX. Is there a way to add formatting to the formula to force the phone number to be in the format we want?

Hi! In my base I have 3 fields where various dates are entered, based on when a client was contacted. Basically a first, second, and third touch point in communication. I have a fourth field that currently pulls the most recent date based on what’s entered in the other 3 columns. If only the first contact field has a date, then the most recent outreach is that date. If the second contact point has a date, then it assumes that date is most recent. Same with the third contact date… if anything is entered into that field, it assumes it’s the most recent. My issue is that sometimes, 6 months to a year down the road, the contact points may start over, and that first date may become the most recent date. (But because there are still dates entered into the other two fields, the 4th field assumes they are still the most recent, when they aren’t) Is there a way for it to calculate within the system which of the three dates is actually the most recent date? I hope that makes sense!

Hi, I’ve been playing around with Airtable and Integromat via Webhooks, and I was wondering if there was a way for two Airtable bases to communicate via webhook and scripts. Here’s the use case: A webhook trigger is set up in Base 1 in an automation. A record is created in Base 2. This triggers an automation to run a script, which posts to the webhook URL from the trigger in Base 1. The automation in Base 1 is triggered by the incoming webhook, and updates a corresponding record. I’ve used Integromat to trigger webhooks via automation scripts using the following code, but unfortunately it gives me an error when I try the same thing with an AT webhook url: let data = input.config(); let response = await fetch(`https://hook.integromat.com/******************************** ?id=${data.ID} &email=${data.Email} `); console.log(await response.text()); I’d appreciate any help or pointers on updating the script to work. I know that @Justin_Barrett, you’ve posted about this in a few topi

So I watched an excellent Youtube video and figured out how a user can edit table data with a form. However, I got the Record ID to prefill, but I can seem to get the others working. Here is the code. It’s a mess. Hard to write it in since a tiny box. CONCATENATE({Form URL},'?prefill_Parent%20Record%20ID=',{Record ID},'&prefill_Doll%20Complany=',{Doll Company},'&prefill_Company%20Logo=',{Company Logo},'&prefill_Country=',{Country},'&prefill_Status=',{Status},'&prefill_Doll%20Lines=',{Doll Lines},'&prefill_Sub%20Lines=',{Sub Lines},'&prefill_Resin%20Colors=',{Resin Colors},'&prefill_Will%20they%20custom%20color%20resin?=',{Will they custom color resin?},'&prefill_Official%20Webpage=',{Official Website},'&prefill_Official%20Taobao%20Store=',{Official Taobao Store},'&prefill_Official%20Measurements=',{Official Measurements},'&prefill_Skin%20Color%20Comparison=',{Skin Color Comparison},'&prefill_Notes=',{Notes}) Company Logo is an attach