Ask the Community

Hello,Let's say I have a table for employees and have an Interface Gallery.  In the Gallery I am showing a headshot, name and title.  When someone clicks on the card it open up a Sidesheet with hometown, state and work history.  When I am looking at the Gallery view with all the cards (ie no Sidesheet shown) and do a search, the results are only showing cards where the search term is visible on the card.  In other words, the search is not searching the entire record, only what is shown.So, if I was searching for any employee named "Bob" then it works returning all the employees with "bob" in there name.  But if I search for "Maine" to find out how many employees are from Maine, then it does not work. Additionally, is there a wildcard available in the search? If I type in "Ma" then I would want anyone with a state of Alabama, Maryland, Massachusetts, Ma

Hi, I have a base where each record in a table represents an exterior item. When the item changes in AirTable, I need that change to be pushed to the exterior database. I want to check the external file for each record every 30 minutes or so to see if the file has changed on the external system.The code that I have implemented to do this is getting bogged down. There seem to simply be a backlog of automations to run. Even though I have turned them off, they are still running some time later and starting new ones seems to take forever.Is there any way to monitor which automations are running and potentially stop them? What about any way of ensuring that only one incarnation of an automation is running at any given time?

I am going cross eyed trying to figure out the correct formula for getting a % field to show up in an automated email as a whole number %. Either rounded up or down. I have tried so many and it still is not pulling correctly. I have tried round up, ceiling and a few other but they never carry over correctly.  

HiI have descriptions filled out on some of my fields in the base. However, it seems like without base editor access, users cannot see the descriptions icon on the interface. Is there a way for viewers without base access can see the descriptions?I'd like users to see the descriptions icon on the interface like below,but users are not able to see the descriptions icon without base editor access. Is there a way to work around giving base editor access? Thanks!

Hey All,I maintain a fork of one of the R packages for manipulating data in Airtable and have run into some issues while trying to create a function that uses POST to handle extremely long queries or queries with more than 22 fields and the offset values to retrieve a table with more than 100 records. See package here: https://github.com/ecohealthalliance/airtabler/tree/masterThe function in question is this one: https://github.com/ecohealthalliance/airtabler/blob/master/R/air_post.RWhen using POST, the  offset param seems to have no effect. The offset ID changes with each request. So if i have 600 records, the first offset id is "itr72y1g3QhvFAKE1/rec9RPMSRlQrWVyum", then the second is l ""itr72y1g3Qh

I want to know if it’s possible to remove airtable branding, when I send emails to clients directly through the email integration inside airtable. Additionally - I am trying to email a large list of people with their assigned presentation time slot. Their time slot exists in the start and end time columns. Even though I can see start time displayed as 4/17/2021, 5:45pm, when I link that column inside the email, the result is this: 2021-04-17T22:45:00.000Z. I want the timestamp to appear in a readable format, and right now I can’t send all my presenters emails with their time slot without doing it manually. Is there any solution? Thank you, Essie

Hi!   So I am an agent who books talent for conventions.  I have a base that has like 75 sheets in it.  Each sheet is a convention and on those sheets it is marked which talent is going to that convention.  My question is, can I make another sheet for the front of the base that is basically a "Master Convention list" which would list each of the talent in column A and then in columns B-whatever, list what conventions they are invited to (which sheets they appear on) I can't seem to figure this one out. Any help would be appreciated

Hi All,Is there any option if I upload a resume in My Airtable base and with the help of any extension,  parse the basic information like Name/Email ID/Contact No./Current Company in respective field.I agree that I am expecting too much from Airtable but it is fabulous. Thanks & RegardsNitin Tyagi 

We're having an issue with analysing some data/ representing it in charts in Interface designer.We have survey data and one of the questions is a multi-select field. When you try to represent the answers as a pie chart/ percentage, you get strange answers, 41 out of 45 people picked a particular answer (as one of their options) but the pie chart says it is 9.5% rather than 91% of people who gave this choice if that makes sense. I guess it's calculating it as a percentage out of all the options ticked by everyone rather than out of the responses... I can see the data better as a bar chart but this just gives the number of responses, not the percent choosing that option if that makes sense.I can figure out the answers using count/ roll-up fields in a totals table if needed but this feels quite a complex solution, does anyone have a better idea of how to get the answers we need? Ideally in one chart rather than lots of individual percentage calculations but maybe that's j

One of my fields has a copy of a record that should not be there. Is there an operator or formula that will find the two records which are NOT unique?I did a simple search for 'copy' - that did not work. Any other suggestions are welcome.Thx.

Hello,I have 3 tables Beijing, Shanghai and General in the same base. I want to auto copy/paste records from the first two to Table General when any records input in them. I created 2 automations with same triggers when a record enters a view and same actions to create record in Table General for Table Beijing and Shanghai respectively. I have 2 questions.Question 1 - Automation BJ ran well but empty lines created without any data appearing. Input 2 lines of data in Table Beijing,A

Hi!Recently a form I made had several of the fields overwritten when I added another form to it. The field went from a text response to a file upload, deleting all the text responses. I can see the deleted responses if I go to the individual row items and look through the version history. Is there anyway to undo the overwriting on the field level?

I am creating a raffle ticket lookup system to enter in sold raffle tickets and then find the ticket winner info once a winner is determined.I start the process by entering a phone number and a starting ticket number along with how many tickets were purchased. This creates an array of every ticket that person purchased in a field.In another table, I have basket 1, then enter the winning ticket number. I created an automation that searches the arrays - when the ticket number is found it updates the record for the persons telephone number. Then a txt message goes out to the winner. This worked great for a few weeks. Now, it updates the winner with every entry - so every phone number from every buyer comes in. 

I have 2 tables: “Home Staging Projects” and “Inventory Items”. In the “Home Staging Projects” table, I want to vlookup on the “Project ID” and return the sum total of “Rental Price” for each inventory item selected for that project listed on the “Inventory Items” table. I hope that makes sense.I’m not sure if this makes a difference, but the “Inventory Items” table is linked to the “Home Staging Projects” table by (formula) “Project ID”.Is there a way to use a formula for this?

Hello,I would like to know how to add tokens to the message body for an automated email which are from a different table than the single table linked to the button in the trigger. Is this possible? I have 2 linked tables: POs and line items. I need the automated email to contain a list or grid of the line items and info from the PO table about the supplier and the PO#. Or, is there some way to format the grid in the email so that it doesn't get scrunched up like this? I need the numbers to align with line items exactly.Thanks in advance for any suggestions! 

Hey guys. I’m trying to simplify a de-dupe routine. Scenario: I have a significant amount of records I’m importing. Many have identical IDs but have one multiple-select field that is different. I need to merge those into one record to combine the multiple selects. My manual process has been to do the following: Copy/paste new data in. Run De-Dupe App manually, checking every record. This works, but it’s super time-consuming. I need to automate the process. Is there any batch process to handle this? It’s always the same result. Needs to merge against the ID. All other fields remain the same, the only change is the multiple-select field. Ideas? Thanks.

Hi,I try to set a link within the same command, that created a new record. The createRecordAsync command works as long as I set all other attributes, except the one with a link (the red line). As soon as I add the red part, I get the error message - see screenshot. Can anyone help me please with that? let newrecord_miete = await table_tacs.createRecordAsync({                     "TAC_Date": per_positive_tac.getCellValue("TAC_Date"),                    

Hi, we have a Table 1 with many fields. We want to use the same fields for Table 2, with different data. Often we want to change some of the fields, such as formulas. So, suppose I modify the formula for my "Average Cost" field in Table 1. Is there a way to make the formula change identically for my "Average Cost" field in Table 2?

I am looking to purchase a digital kiosk for Airtable apps that runs on Android 7.1. Can someone tell me if interfaces run on Android 7.1. I've recently learned that interfaces do not run on an iPad so just checking.

Hello, I've looked around for an answer to this but haven't found one yet, apologies if I've been looking in the wrong place or the answer is obvious.My airtable has a list of filename prefixes in one field and a corresponding number of files in another. The prefixes are formatted something like this: item-01, and then there would be a file count that can range up into the dozens. What I am hoping to do is use those two fields to create a file name list. So if the file count was 2, I would want a list that would go something likeitem-01-001.tifitem-01-002.tifThis data would then be output to a "filenames" tab in the airtable. Is this doable? I am not good with formulas so I've been trying various solutions using linked records and automations but I haven't had any luck. Thank you for reading! 

hello everyone, I have a question that i can’t change the order of my wokspace. It’s just can arrange depend on my “Created date”? btw i use the app not the web airtable. if someone can help , I’ll Appreciate.

Hello - I could use some help with a formula or automation to get what I'm trying to achieve to happen.We have job numbers that are coded as follows:23 = year1 or 2 = office identifier0001 = job number for the yearExample: 2310023 What I need to happen is the next sequential 4-digit job number to be added to the year and office identifier each time a form is submitted to create a new record, and it needs to reset each year so that on the first '24 job, it starts over at 0001. Does this make sense?

I am in year 2 of using a pro license of my Airtable workspace. My organisation is based out of Mumbai, India and since the end of last year our central bank does not allow us to make payments that do not require a two factor authorisation.Luckily our payment went through the first time around last year as we made the payment prior to this rule being enforced. This year when we had to pay for the annual subscription renewal we used a colleagues American bank card to make the payment as to avoid any issues - this card was used by another team in the organisation to successfully make a payment for an Airtable pro license a couple of weeks ago. This was the second American card we'd tried to use. Both were declined and we can't figure out why. Airtable support hasn't been of too much help and we risk losing a lot of data. Any and all suggestions welcome.PS: We are trying to update an account with approx. 7 collaborators

I’m looking for a way to take a duration field (eg 1:32) and show it as “1 hours, 32 minutes” like with text. I’m imagining there might be a formula I could use, but I’m not sure the best way to go about it. Any thoughts would be great!

After creating my tokens i cant see my api keys and i have tried everything Now im trying to create an Oauth and i cant seem to get the hang. i'm Trying to get my bot to input data into airtables and also get information from the same table but i have not been able to get it to work on make.com i already figured out how to get it to my google sheet via make.com but im not able to call back information hence my need for airtables