Ask the Community

Hi All, A search of the community yielded the same question but no definite answer. I have created a view on Airtable, shared it so users can search and find info that they need. Problem - filtering, grouping, and search work only on desktop or laptop browsers. None of those options are available on mobile devices. Is there a workaround or some way to get at least the filter and search to work on a mobile device? Thanks in advance. Regards, usha

Hi all -I am working to update an Airtable table using responses to a Qualtrics survey via Zapier. I have many multiple choice questions, some up to 17 options, and the column these feed to in Airtable is itself a multiselect field column (so I want each item to show up separately). At first, I had the issue that when I listed all multiple choice fields from qualtrics one next to the other, it put it in as one giant option, as shown in the right of the attached Airtable screenshot (early stage growth stage as one item). I resolved this partially by putting commas between the fields, as shown in the zapier screenshot. That turned into the left example in airtable - now they are separate items, but if an item is not selected, it still includes a blank entry. Is there a trick to resolve this? Open to all ideas - thank you!

I'm not certain if the OAuth flow is working as expected...When initiating an OAuth flow for an existing, and currently logged-in user, the OAuth pattern works as expected. After the OAuth consent screen is displayed, flow correctly redirects the user to the redirect_uri.However, if a user is NOT logged in, the flow works to the point of providing an Airtable login screen for the user and then drops them into their admin page WITHOUT a OAuth consent screen. I would have presumed that for users who have not logged in, Airtable would allow them to login and then proceed to the OAuth consent process. As it stands now, users are dropped into Airtable without ever redirecting back to the calling site leaving users stranded. And assistance on this would be appreciated.

Hi there, we’re looking for an alternative solution to Jotform. We are wildlife rangers working in African National Parks. We use a Jotform to complete our ‘Daily Station Report’ which includes daily roll call and station statistics. We use ruggedised iPads, we open the form online, go offline to do roll call, and then go online to sync the form (I believe airtable can do same).Our challenge is the insanely convoluted and over complex back end. It takes an entire (frustrating) day every time we want to add a name to the roll call, because of the calculations which add up how many staff present, away, sick etc.We have 64 staff at this park in Zimbabwe, and the Staff Sgt has to read them out and tick the right box (present, away etc). So he can’t write in the name each day, or he’ll standing in front of the rangers for hours! We need a SIMPLE front end (see iCloud link to screenshot of current Jotform) to this, and the ability to EASILY make changes when need

Hi, So for the purposes of this problem, say i have 4 tables: Customer table: a list of all customers. New Leads: a list of all leads. Orders: a list of all orders currently being executed. Disputes: a list of all disputes. All records in new leads/orders/disputes have a record from the customer table as a linked record. We have over 100 customers. For our meetings, what we’d like to do is have a dashboard of sorts where we can select any particular customer, and get the new leads, orders & disputes to all appear on one page. Afaik, i can’t see any easy way to do this in airtable. Is there any block or any way that could help me create this? Thanks zeta

Is there a way to track viewership, clicks, or engagement in general for an interface? I'm currently using Interfaces for a Project Status Update site, and it would be quite interesting to see how users are engaging with its content. I'd love to see a heatmap of sorts as to what pages or content is being viewed most, or where the drop-off is to inform if what I've created is providing value. I could otherwise solicit written or vebal feedback through an Airtable form, but figured data would be another compelling way to gain that feedback. 

I make extensive use of the hierarchical list function, but there is one thing I can't work out how to do. I've made a minimal example here: I have three tables, projects, groups and records. Projects can have several groups, and groups contain several records. I would like to be able to filter the view based on which project a group is assigned to. I can add a lookup field inside the record (which is what is shown in my screenshot filtering for project Bob), but I would like to have groups A, B and C hidden in this view, because they are on project Alice. I can't use the 'hide sections with no additional rows' option, because I would like my users to be able to add new records to group F, which is a member of project Bob but empty. Are there any features which would allow me to achieve this goal?  

Hi everyone!Okay.. so... bear with me... I have people that have multiple roles {Contact Type} in the company (Humans Table)I also have a Junction table (CT Category by Human) so I can manipulate the dataso in my third table (CT status NEW) now that each role {Contact Type} is on a separate row I can add a different 'Status' to each roleMy issue arises when I add a new role to a contact in the 'Humans' Table. I have a working automation that populates the Contact Type row in the junction table with the new human that has been assigned

Hello everyone,I can't create a formula to find pieces of text in the "Libellé" (Text) field and transform them into a word.Example :IF “PAYMENT” or “PRLV SEPA” in the "Libellé" fieldTHEN “VER” in the formula field

Hi, I have a list of images in my table.Every image has a unique name. When I generate links for those images, the script alters the file name in something like  M3dW46KbO3yqx_jfWYnF3SwxGH6d9PEdzd4yeZbX3dID2qspnfxaSfTEpkB3b7iNsbSQj4Hpg/10xqzlyS2mPOE3cH5VsVa9R66zIEbaZyldHHlpcvqmAThis is not ideal, as I need these images to have the original name.Is there a way around this annoyance?Thank you

When trying to read or write data to and from a long text field via the API, I am loosing the newlines.This is an example of what I have in the field:When reading the content through the API, I am getting this:Also, when writing \n to the field via the API it get's stored literally, i.e., is not translated into linebreaks:I cannot find any hint how to encode newlines in the API docs or the forum.Any help would be highly appreciated.  

Hi all,We have a marketing calendar table which links a CAMPAIGN to individual DISCOUNT records in another table. Each CAMPAIGN has 4 or 5 DISCOUNTS in successive panels, and so we have 5 linked records from each CAMPAIGN to the DISCOUNT table, labeled Panel 1 - Panel 5. I would like to have ideally one field in the DISCOUNT table corresponding to the date of the associated CAMPAIGN, but I can't figure out how to aggregate the multiple PANEL fields into one single lookup. Is this possible?I've tried Concatenate & run into issues with datetime format, as well as issues concatenating empty records). I'm sure there's a way to set it up with IF functions that might work, but figured I'd see if there's an easier way!For context, I know this might not be the most technically "correct" way to set this up, but I'm trying to convince my team to get on board with Airtable by replicating the functionality of a Google Sheets calendar they were using and adding in some a

Hi! the last column in booking details is payout week. how can I bring that to payout details table to show what each person did each pay period? it shows me what each person did, but it doesn't specify what pay period it is

If anyone could shed light on this I would be appreciative. In my example, I have two columns, one with a ResourceName, the other a URL. A third column would hyperlink the ResourceName with the URL. Easy peasy? Not so. Still. A: ResourceName    Brown CowB: URL                        https://browncow.comC: Resource              Brown CowI tried this script from another thread but, line 2, let query = await table.selectRecordsAsync (); function is deprecated. It does work... for 15 rows but, stops there, and no matter what I try, 15 is all I can get.   let tb = base.getTable("My Resources"); let query = await tb.selectRecordsAsync(); for (let record of query.records) {

Hello!I have practically no experience with Javascript and scripting but I am turning to the Run Script in my Airtable automation as a last resort.In my automation I am finding a list of schools and then using a repeating group to go through each school and find values where the school is in the schedule table. I am running a script in this repeating loop to get all the entries in the schedule where the input value is from the schools. I am doing this so I can then order these according to start date which Airtable doesn't let me do.You can see my automation in the attached screenshot.The script is below and it works but I keep get an error on schoolName (which you can see in my other attached screenshot) telling me: Property 'schoolName' does not exist on type '{}'.(2339) Can anyone help? I don't really know why I am getting this error?

Hi!I'm trying to populate new records based on existing data and I'd prefer not to create a new table. Is this possible via an automation? Here's the use case:1. We receive letters from prisons across the country. When we have not previously received a letter from that facility, a user submits a form with the new facility and selects a state value from a dropdown menu that matches their facility (ex: AK)2. Prison policies are the same across states (all prisons in Alaska have the same length restrictions, for example), so I want to avoid the form-submitter from having to do the research again. Instead, I would like to use an automation to populate the fields with the existing data while allowing for the data in the field to be amended in case a facility in a state has slight variations.In this view, Spring Creek Correctional already existed and I subm

Is it possible to consolidate a list of all forms (and links) to administer from one place?

Hi All I am attempting to create an automation where a project can be copied or duplicated to another tab with all of its comments still included on it and then deleted from its original location. Does anyone have an idea where I can do this?I am currently using an automation and a script to copy the project name and column fields but I am not sure how to also get the comments. 

Hello everyone,I can't find the old page where I could see my published interfaces, my unpublished ones, and create a new one. For a few days now, when I click on Interfaces, I'm redirected on the new interfaces page where I can see all my published interfaces on the left menu, but I don't have any option to create a new one.Has something changed?

Hello.I need to calculate the average of the entire column (called total score) but using the average formula I am getting the average of each cell. Is there any solution please?Thanks

I have several helper tables for linking and allowing users to choose from sets of pre-defined values. They do not need to be directly accessed and can confuse end users. I would like to find a way for them to be hidden. I found an old thread about this that is marked as solved, but as far as I can tell, it hasn’t been solved. Some options that could work: Allow these tables to move to a separate Base that can be accessed from the Base the consultants interact with, meaning allow Bases to access data across other Bases in the workspace. This way I could group the tables into functional and boilerplate Bases. Access to a show/hide UX in the Base with the tables listed and a toggle switch for visibility. Off state would hide the tab. System or even a hack that allows for custom CSS. Unfortunately the tabs do not have ids, but I may still be able to hack something with nth child. Are any of these availab

Hi! I’m trying to create a kanban view and it won’t let me choose any of the fields from the table i’m creating a view from - it only allows for me to add in a new field which i don’t want to do. Kind of defeats the point of this view. what button have i not pressed? any help would be appreciated!

Hi everyone! I followed this support article almost exactly in an attempt to repeat yearly deadlines (grant applications), but for some reason, everything automatically copies over except for the new date. I used the formula DATEADD(Date, 365, ‘day’) to create a column that adds a year to each date (which does work), then tried to input that as the date when my automation creates a new record (triggered by it entering a “past events” view, containing any event with a date before today, so that when a day passes it gets added to next year’s calendar). But alas, the date just won’t copy over. Does anyone have any suggestions? Thank you! <3 The support article I followed:

Hi, I'm unable to upload multiple images to record templates - keeps giving me an error. Is anyone else experiencing this? 

Hello,I have been googling this for a few days now and really need some help!I am trying to set up an existing customer email reminder automation that uses date the next time we are going to visit a venue. The trigger will start a month or so before the visit date. A new customer fills out a form and a record is created. This gets linked to our Class bookings table with the venue that they have visited. The bookings table is linked to a classes table which shows each venue and the 4 dates we visit that venue. So far i have managed toLookup the dates from Classes in the class bookings table - this gives me an entry with all 4 dates in the same cell. The format of this row is a date. (perfect)In the customers table i am able to use a rollup to get this date across and then use an ARRAYSLICE to get the individual dates i need. They come in a really long form