Ask the Community

I have two tables: "Billing" and "Activities". I'm trying to find a way to combine this data so that I can see $ received from bills while only including "TimeEntry's". In this specific scenario, the amount I would need to see is $530, since the $100 is an ExpenseEntry.It is way too time consuming to manually count the hundreds of records, so I need a formula or an easier way to compute this. Thank you very much!

I am a historian, constructing a historical database (1940s-60s). When I click on my linked record for a person or institution, some of which will have to link to 1000+ records, I notice that the records are almost arranged in date order - but not quite. As I scroll down, I will notice up to 20 or 30 records running from earlier to later, as I would like, then a record from a decade earlier will appear next, followed by another run of (successful) earlier-later sequencing, though often for yet another subset of years. Naturally, I would like the entire contents of a linked record to run from earlier to later. I cannot see what other sort criterion the linked record might be using. It certainly isn’t the random 6-digit number I’ve created for each record ID. What is odd is how the linked record is almost in date order.

Is there any mechanism which can be used to allow only some records within a list view to be editable? I would like my team to be able to edit records until they are marked as complete, after which editing should no longer be allowed. I'd also like to be able to show the completed records in the same view, so work arounds such as using different views (which is what we are doing currently) make our workflow less easy to follow.

Hello Airtablers, My base is a list of leads with linked tables of their respective organizations and locations. I am evaluating a new sales tool called Apollo and I’m trying to configure their API into my base so I can pull the contacts and organizations. I understand the basic logic here, but my experience using APIs like this is minimal. Can anyone shed some light on how I can go about linking Airtable and Apollo? Here is the github link to the Apollo API.

I have a base for which I wanted to create a daily email automation. - Trigger - every 1 day at 8am- Action (find records that have tasks (a field) with a status of TO DO. - Action (send an email)It looks like in the email that I am able to do attachments and either use data from the trigger (at a scheduled time) or action (find records). But when I click on Find Records....it will not let me choose anything...I either see invalid choice for input, cannot assign list of string to collection of complex types. It will not let me attach they actual data! Any help is appreciated. 

Is it possible to make a search box appear also in the “grid view” on mobile (as happens in the desktop version)?

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 be. Also, the Jotform e

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 this role....But I can't work out how to get that new info into a new row in the third table in order to allocate a status for it.... What I have been able to do is create a fourth table that creates records anytime the [Contact Type] field is updated in the first table... like so..  mainly so i can keep track of how often role changes happen. Table names 'HU to CT new':I'm hoping i haven't lost anyone so far... so currently AA2 AA3 human is a P

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 additional bells & wh

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) { let url = record.getCellValue("URL"); let text = record.getCellValue("ResourceName"); if(url) { tb.updateRecordAsync(record, {"Resource": `[${text}](${url})`}) } } 

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?   Thank you!let school = input.config(); console.log(`The value of schoolName is ${school.schoolName}`); // query for

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 submitted the Test facility for automation via a form. I'd like the filled out information from Spring Creek Correctional to populate in that

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?