Ask the Community

I have a button that I would like to trigger two tasks: 1 - trigger a webhook that passed the data to zapier (done) 2 - automatically update the value of a single select field to ‘true’ While the webhook script runs when I click the button, it seems that the other script I am using (to update the single-select) wants to take in a user input every time and it does not run automatically. Is there a simple way to set the value of a single-select field automatically to true without me having to specific the field and the value every time with a script?

Hello!Adding an entry to calendar view automatically set the time to midnight. Is there a way to change the default time to anything other than midnight?! Thanks!

Is there any plan to encourage developers to build more apps and write more scripts to marketplace? From the conversation I saw in the forum, getting your apps approved is so difficult and long. I feel Airtable now lacks vibrancy and enthusiasm of other tools (monday.com or coda.io).

Hello, I am seeking to pull a record that would have an image and then a few fields under the image from the same record and then repeat for all records in a filter. The custom text and layout fields of the page designer as well as being able to export make it quite desirable for this but I’m having issues getting the records to populate in this manner. The gallery view provides most of what I need as it gives me multiple records (of which I can filter by field) but the limitations on styling keep it from being an answer to my issue. The screen shot is of a gallery view, the first image/ record is laid out in the manner I’m seeking, and the second is the gallery view unchanged. Any assistance would be great.

Hi 👋 I'm not an expert with formulas, but I think I'm overthinking this / making it more complicated than it needs to be.I have a CSAT (customer satisfaction score) form in Typeform that is being automatically sent to Airtable. What I'm trying to do is:a) calculate the CSAT score (# of 4/5 star ratings, divided by # of total responses, multiplied by 100)b) have it calculated every calendar week (so there should be a new rating every Monday)I can do this manually for now, but I want a way that each week, people can look and see what the score is, without anyone having to manually calculate it.I'm totally lost, although I think I am overthinking this. Any ideas? &#x1f605I've attached screenshots of the set-up currently. We have two sources for the feedback form, so there's one table for each of those.Then I have the 'Score' table, which has 5 records, one for each rating (1-5 stars), plus another

Hi, Am I missing this option, or do I need to submit a feature request? I have a Table called Statuses, which I use on multiple tables and multiple fields so that I don’t have to setup a single select 20+ times. When I make a new record, any fields linked to Statuses should default to “0-Not Started” record form Statuses. Is there an option I am missing to set the default linked field?

I am trying to create an automation that sends an email or a slack notification when a record matches conditions when X is one month from now. However, I received the following message. I have included two screens shots (a) the trigger and (b) the table and conditions chosen. Can anyone advise me to how to fix this issue?  

I am using Integromat to pick up a webhook sent from Airtable. I want to then whitelist the Airtable IP addresses How to know the IP of my airtable account - #2 by Bill.French ← question was asked here, but not answered (a re-open might be a good option so we can re-open questions). To answer some of the questions in that original post: I understand this is not a cure-all security method, it does provide one more layer of protection. Yes, a webhook is my preferred method of sending data from Airtable in this instance as this webhook works across a number of services - so it is not a read Airtable first scenario. Thanks

Hello,Want to strike through text in a cell if a given string is found in another cell in that row.  Is this possible?The cell whose text I want to strike through is already a concatenation of various other field values.  It's looking in a different field for the term "OMIT", and if that is found I'd like the text strike-through'd.The "OMIT" will be searched for in a single select field, but I don't think that matters since I've already successfully searched for and IF'd stuff based on single select text contents.TIA for any assistance.

HiI have some linked tables. The first link is between "People" and "Working Groups". When in the Working Group table I can look up people's names and add them to the field "Members". When in the People table, I can make a link back to Working Groups, and a field called working groups will self populate with all the Working Groups that people are members off. This is all working fine.I have a second link between "People" and "Training". When in the Training table I can look up people's names and add them to the field "Attendees". When in the People table, I can make a link back to Training, but I can't make a field that will self populate with all the training people have received. What am I doing wrong?The only difference in layout between Working Groups and Training, is that training's unique identifier is a date.Any light you could shed would be very helpful.Thanks,Davva

Hello, I am trying to create an algorithme in AIRTABLE using the script automation. I have 3 tables : Mission_Request, Cookers and Companies. My script compares all the pattern in both Mission_Request (wich is connected to Companies table) and Cookers and when there is a match, it is supposed to fill the "MatchingCookers" cell in MissionRequest with the Cooker best match. My script doesnt' have any type of error and i don't have any kind of mail error. My script is active. My journal log don't have any kind of error. Does anyone have an anserw ?? It will be very helpfull. Thanks !!! And i would like any advice from people who have made an algorithme in airtable!!! Thank you! 

Hello, I am trying to write some automation that should call some function in our server through a script and pass as input the image data that is stored in some field. How can I pass the image data ?The url I get there is private and  inaccessible through the server. I tried to convert it to base64 but FileReader is not available, also to pass the binary data using FormData but it is unavailable as well .Any help will be much appreciated.Yaniv

For some reason I cannot select the text within my formulas, meaning I cannot choose which text to copy for pasting later. It is only within the formula editing that I cannot edit the text. I can select text everywhere else:Selected text on here:Can't select text hereOkay to select text here:  

Hi, is there a way for Airtable to automatically log me out due to inactivity? I dont want it to stay open if i am not using it. Thanks

Hello! We operate in an industry dealing with perishable goods, where the timing of receiving products (INBOUND) and the customer's requested shipping date (OUTBOUND) are crucial factors. We are trying to create a base structure/formula so we can keep track of inventory.Our primary challenge is to accurately determine the current inventory of raw materials on any given day. This inventory depends on the items we currently have on hand and any anticipated future deliveries of raw materials (INBOUND) for the upcoming week, provided they arrive before the customer's designated ship-out date (OUTBOUND Ship Date). Furthermore, our system must consider existing customer orders placed for the week and determine which incoming delivery of raw materials these orders will draw from.For example, suppos

Hello,I have a problem with a formula linked to a look up. I have a table with my banking transactions (linked to my bank) and another with forecast expenses. I did a look up to get the bank balance and I made a formula (Bank balance-expenses) for the first line the calculation is correct but for the other lines it does not give me the balance calculated above. Do you have any ideas to solve this problem?

While on a product feedback call with proj. management platform ClickUp, I asked if there were any 'Airtable-like features' in development or on their roadmap.I proceeded to explain my love for Airtable as an early adopter, but they continue to make user-hostile changes, refuse to listen to the community, & price increases. "Are you familiar with Airtable?" I asked.  "Yes, only because I've had 3-4 people tell me the same exact thing in the past few months. The team is looking into what it might look like." So to the point of my story. If he's heard it 3-4 times, ClickUp has had DOZENS (or more?) of requests from unhappy Airtable customers. This also means HUNDREDS (or more?) of folks have shared similar sentiments to other productivity SaaS. My true hope is to stick with Airtable, that it goes back to respecting the community, especially after all the layoffs but without changes at the top, I

I have these two fields Formula on Contract Yield % is this:({Contract Rent PW}*52)/{Purchase Price}I need to replace the formula in the Contract Yield, to an IF formula.More likely:When the result on Contract Yield is 0%,   If Contract yield = above 1%, use Contract yield formula, but if it's 0% I need to use Appraised Yield Can you please help me what is the correct formula to make it work?I already tried (IF({Contract Yield}=0,{Appraised Yield}but it's not showing the correct results

Apologies if this is a simple question - I've tried to figure this out for hours now and I'm at a loss. I'd prefer not to use automation for something so simple, but will do so if necessary. Here is my issue:I have an intake form setup to receive responses from sources external to my org. Let's say it's a form to request for sandwiches to be delivered. The user selects from various options for types of sandwiches (Peanut Butter, Ham and Swiss, Roast Beef). Each of these sandwiches take different times to prepare. Therefore, I have the following tables with the following fields:Sandwich RequestsTypePrepare TimeRequesterDate ReceivedEtc.SandwichesTypePrepare TimeThe "Sandwiches > Prepare Time" field is just a number - the days it takes to prepare a sandwich. I want this to automatically populate into the "Sandwich Request > Prepare Time" field automatically b

I am trying to assign 4 different users records as the come in.  I found this code const collaborators = [ {name: "Person 1"}, {name: "Person 2"}, {name: "Person 3"}, {name: "Person 4"} ] const chosenOne = collaborators[Math.floor(Math.random() * collaborators.length)]; output.set("collaborators", chosenOne.name) My problem is that it doesn't exhaust the 4 names before repeating.  What do I need to do to this code for it to go through all 4 options and then repeat?

I accidentally deleted a base and restored it from trash but none of my information is in it. I am getting an error message. Base not found.

I have three forms to fill out with data, and they go in sequence. Is there any way that the answers from all three forms go into one entry. Right now, each form creates a new record.

(Similar to this post though with an additional layer)I have a table with Interactions. There's a Status single-select field and a Timestamp field (since this data is being imported from elsewhere) that shows when the data was captured in the original system.There's a second table named Opportunities. All the interactions with one individual are linked to their respective Opportunity record. I need a field in the Opportunities table that reflects the Status of the linked Interaction record with the most recent / max Timestamp.The solution to the post I linked above pulls the max date, which would work if all I needed was the most recent Timestamp date pulled into the Opportunity record. However I need to know the most recent Status based on the Timestamp.Any thoughts? I may be missing a simple

I first want to say how much I love using Airtable. But am super confused. I thought I was paying for a monthly rate and the charge on my credit card today was over $1000. So in Canadian funds that is over $1300. I can possibly pay that!!! Help!

Hi,I am running into issues. I am not a coder at all and I ask GPT to help me. Usually, it does a great job in writing some basic scripts and it has already created nice solutions with scripts. But this time, I am running into issues. I have a huge database and I was asking GPT to write a script to merge duplicates. When I do it one by one, it works. But as soon as I let it search the whole database, it crashes and mentions that it's taking longer than 30 seconds. I was trying to break it down into smaller views, but the problem is that it should check all the data actually, and searching records is also not an option since that's limited to 100 only. Any idea would be awesome.here is what i got from GPTOption 1// Access the table let table = base.getTable("Online Stores"); let query = await table.selectRecordsAsync(); let records = query.records; // Define a map to track duplicates let recordMap = new Map(); // Identi