Ask the Community

Hi, I'm copying contacts from one table and pasting them into another table. I'm looking for a preview of these contacts on a button click. Is there a way to add a button in the script?

Hi all Airtablers, I was trying to connect a task from Apify to Airtable via Datafetcher. I did that in the first run a few weeks ago and it worked. Now i tried to schedule the task, but it gives the error below.  I checked the actor task and it's fine. not sure where is the issue. any help/advice is appreciated.  

I've come across a strange issue.Using MAKE (aka Integromat) I'm using an Airtable Search Records module with the following formula:AND(Lower({Email (from Members)}) = "{{lower(2.`recipient email`)}}", {Order Number} = "{{51.`$1`}}")It accepts it but does not return the required record. The Order Number is a number field, and I've tried the formula with and without the "I've done with this similar tables and records but for some reason this one is not working and I cannot fathom out why.Any ideas?

Anyone know how can I enable these selections shown on the video?https://www.youtube.com/watch?v=38sS2hJKKtk : This is what it looks at my end: 

Why is the GRID view not working, but the LIST and other views are ok.It reports an error in the GID viewNo tasks found for "https://airtable.com/sh********I".Try editing your search query.Please some advice and help

Hello, I have been using the Airtable API and having some problems in that.First of all, OAuth access token is getting expired before 60 minutes. When I try to refresh the token using refresh_token it stays this:{"error": "invalid_grant","error_description": "Invalid token."}If I refresh the token frequently, it works fine. But it is getting expired before 60 minutes (as written in docs) and after it expires, I am unable to generate token again. PLease Help! Thanks

Hi community.I have a single-select field called Sector in a table called Projects. I'm trying to cast this field to a string.The reason I'm trying to do this is that I'm trying to build an automation, in which I will need a conditional step that will check this stringified single-select field to a multi-select field in another table to see if the multi-select field contains the the selected value in the single-select field.Thus far, I've created a formula field in Projects with various formulas (or formulae, for the sticklers out there), including:- ARRAYJOIN(Sector)-Sector-LEFT(Sector)No matter what, when I go to the automation it won't let me choose the field because AT says "Cannot assign list of string to a string".Please help!!!Thank you!

I've been building interfaces that have "add record" buttons in them, and because of that I've realized that I've miscategorized some primary record fields for what a record is called when I first created a table. For a table that is based on personnel records I somehow selected "company" from the dropdown list when I first made the table and now in the interface for a personnel record I have a button that displays "Add Company". Ideally I could change the "What should each record be called?" option in each table, but I'm not seeing any way to do this once the table is created and the initial selection is made. Alternatively, I would love to be able change it to "Add Person" as one of the options in the interface designer, but doesn't appear that's an option either.Does anyone know a way to do this either in the interface designer or after a table has been created?

I'm getting the error 'Field "Student" cannot accept the provided value: Cannot modify a computed field.'. The field "Student" ISN'T a computed field, though; it's a linked record field.What confuses me the most is that when I tested this automation it worked flawlessly, both in 'generate a preview' and 'run as configured' tests. It's only in live runs that it fails. Does anybody have any clues as to what's going on?

As of this morning, Grid Elements have been showing an error message:"No Records found for [email address] that match current filters. Remove filters to see more results."Tested with List Element instead and that's working fine.  Any idea when this will be fixed? My team relies on Grid elements to access their workflow.

I am trying to create a script so it will give me a running total for a base view on certain columns. For example. My brokerage I want to make a top 5 in different categories on our interfase. From what I am seeing I can not add columbs up so I created views for each agent. Within those views I was hoping to have an automation that searches the view every so often and runs a script to talley up the totals in a columb and then the automation will update the number on another base acocrding to that agent.  So Agent is Mary White on our brokerage tracker I made a Mary White View. Set up a automation to Find All records for Mary White in her view Set up a script to run totals for Columns "total sales" , "total commissions" Total Unites and so forth Script enters total into selected field in leaderboard base under designated agent and this is automatically updated every day. through the same s

Dear,I have created different gallery views and would like to embed them on a website, but without the Airtable logo (on the bottom left) and the enlarge option (on the bottom right).We have a team licence.I couldn't find the solution 😞Thanks for your help

Hola! Hi! i'm new using Airtable! so, everything in my code was ok but when i try to do a Update Records, i have problems with patch. I have all permissions in my token, i write well the sentence to change, but appear this:

When I @mention someone on Interphase and they get an email notification to link them to the base to see the comment, is there a way to link them to the Interphase via that notification? I’m running into a bit of trouble with @mentioning someone and they’re taken to a gridview instead of the Interphase view. My gridviews and my interphase shows different fields so when they’re taken to a grid view, they don’t see the necessary information/fields.

Hi,I have created a prefilled Airtable Form.Whenever I click on the link from my Airtable Base, it opens the form and prefills the form with all the desired information (including line breaks, see image below).The trouble begins, however, when I try to use this exact same URL in an Email Automation (see image below).The link is displayed properly in the email (see image below).However, the linebreaks no longer work (see image below). This makes the text unreadable. It's an important part of the process, so if

Hi there,Is there any method to write a POST request with the filterByFormula parameter within the request's data, while also applying a sort? I've attempted to add the 'sort' parameter within the request data payload but I'm encountering parameter validation issues. I also tried to append on the 'sort' as a URL query parameter but it isn't being applied to the data correctly.

I would love to have Airtable help me to map out the prerequisites for an academic program but I'm having a little bit of trouble. Imagine a list of courses - some are required for the program, some are electives, etc... Many of these courses have prerequisites. For example, before you take course F, you have to have already taken course B.If it were that simple, I'd be able to use the flow chart extension to map everything. Unfortunately, it gets a little complicated when prerequisites include multiple courses and even "this OR that" cases. For example, "before you take course F, you must have taken both course A AND course B OR you must have taken course C". I tried to use different fields for each case with an "or". For example:Multiple Linked Field 1 includes "Course A" and "Course B" records.Multiple Linked Field 2 includes "Course C" record. This would indicate that you must take Course A AND B OR Course C. The problem I'

Hello everyone!I ran into a problem which I currently have no idea how to resolve.I have a script using an API call which logs the user into external system. This is not an automation script, but the script from a scripting extention. This is because fetch() function behaves differently and only passes authentication data when used in scripting extention. I can run the script pressing a field button in a grid layout.Data grid:Now I need to provide the user with an interface button that would finally resulted with logged in state. But this seems not as easy as it can be imagined. It is not possible to directly call a script with a button action as it is only capable of running an automation script, not scripting extention.Interface:

Hi,I have a multiselect field containing topics. It is a linked field to another table and each topic might contain a comma within its value. I need to prefill a form with that data but I find Is it possible or do I have to remove the commas within the field values?Example of topics:Agricoltura, Ambiente e Territorio, Calamità NaturaliPolitiche per il Lavoro, Formazione Professionale e Servizio CivileCulturaFormulas I tried:This only fills the first topic: CONCATENATE( IF( "Prefilling [Form Preferenze] view in [Contatti] table in base with id 'appYSPQbVoKOqpys7'", "https://airtable.com/appYSPQbVoKOqpys7/shrVvuD1tVKS88IiG" ), CONCATENATE( "?prefill_" & ENCODE_URL_COMPONENT("Temi di Interesse"), "=" & ENCODE_URL_COMPONENT({Temi di Interesse} & "") ) ) If I try to remove the comma+space, it doesn't work for the topics that

Does anyone else here use softr and is noticing severe lagging and slowdown in the app after oauths were implemented? When we confronted Airtable, they told us that:to summarise, there are actually 2 limits on the api call5 calls per second per base5 calls per second per user/integration pairand it is the second one that softr is having issue handling. Any suggestions on:1. what alternatives to softr are out there that have existing integration with airtable2. screw airtable altogether due to these new limits -> find an alternative

Hello,I want to send a slack message each time "Tag 1" is updated. But if 5 rows are updated, it will send me 5 times the same message. How can I solve it?  Thank you,Emilie 🙂  

Hello --As of this morning, when my team logs onto any interface with search enabled (on a grid), it is almost instantly searching the table for that user's email. I do not have "Viewer's records only" selected, and when I am in the editor view the search bar is blank. It's almost like it's trying to treat the stored information from the user's browser as a login (note: it is happening across multiple browsers).It has happening across multiple interfaces and interfaces that pull from multiple tables. I don't know if this is a known issue, or if there's some global setting I didn't know about that I've accidentally toggled.Thank you 🙂

I'm trying to automatically populate emails depending on team member names.So if "John Smith" then in this column "john.smith@email.com" ""And if "Kate Jones" then "kate.jones@email.com" ""etcetcetcfor about 30 team members. I can get the first formula to work but how do i do it for multiple? Tried this but didnt workIF({Name} ="x", "email x"IF({Name} ="y", "email y", ) )

I have 5 non-value fields that indicate if a person has paid an application fee or not. The fields are: 180 GBP, 210 GBP, 240 GBP, 270 GBP, and 300 GBP. If a person has paid, it will say "Completed" under the column that they have paid. It will say "Not Started" if they have not paid. For example: If person A has paid the fee of 240 GBP, it will say "Completed" under that column, and it will say "Not completed" under all of the other monetary columns. (it was not my idea to organise it this way, it is just the way it has to be!)I would like to add a formula field called "Paid" that can identify if a person has paid (Yes or No) based on the statuses of the 5 monetary value columns. I want it to recognize that if 1 of the columns in a row is "completed" that the "Paid" value will be "Yes."Does anyone know if this is possible? Please see photo attached for an example of how the fields are laid out, and a sample "paid" field. 

So I have a table called "Dealerships" and a table called "Services". Each record in "Services" has a date, an amount, and a link to "Dealerships". I'm creating an interface that will aggregate these, so I can know the amount that came from each "Dealership". I know I can do this with a Rollup, but the problem arises when I try to use a Filter element in the Interface.I have a "Dashboard" page and a "List" element sourced from "Dealerships". This list contains both the Dealership name and the rolled-up amount.I need the user to be able to select a date range via a Filter and have the Rollup be updated to only add up the services that match those dates. I haven't been able to find a way to do this. The closest I came to a solution was to use 2 levels in the List, which actually DOES filter the services in the 2nd level but does NOT change the value in the Roll-up accordingly.Any guidance would be greatly appreciated. Thanks!