Ask the Community

I’m building a solution for a client that may have around 80 K records… was thinking of breaking it up into multiple bases given that there’s a 50K record limit. However, they need to be able to search across the bases at the same time. I was thinking I could achieve this through a custom app that would allow them to do this search and return results from multiple bases. Has anyone tried this? Any suggestions on how best to do this? Regards, Ruchika

How can I search globally in all tables ? No the existing search app doesnt work. See the image below. it only search in the records in current base not globally. Please guide me whats the possible solution to this. Screen Shot 2020-09-17 at 10.53.07 AM

Hello! I’ve just come across Airtable and was experimenting with it as an alternative to Google Sheets. My question is, if my application requires multiple databases, can string searches be performed across them? Thanks, B

I need to search records in multiple databases and if the search result is not empty then set a variable for that particular organization. I will then compose an email using non empty variables. Scan Airtable A base, if the output is not empty, set the variable Clinic A to results. Scan Airtable B base, if the output is not empty, set the variable Clinic B to results. Compose email that includes non empty variables: Hi John Smith, Please submit the following items: Clinic A variable (has value - not empty) [Clinic B variable is not included as the variable in the previous scenario was empty due to no search results) Can’t figure this one out as Integromat requires everything to go in a flow as I am using filters to filter in or out empty search results. But if search results for variable A are not passed then the rest of the flow does not happen.

Hey guys, I host my own pub quiz and since I’ve done around 80 of them I start forgetting and sometimes I add question I had before. I’m looking to make a database which I’d update after each quiz so I can quickly search for keywords or answers. This tool does seem really useful and I’m willing to explore it. Now I’m curious if I’d be able to somehow search for the answer across all the different quiz tables I make? Thanks for your help! Screenshot_1|690x201

I’m setting up a new base for my construction company. Would like suggestion on best basic structure. We will only do 3-5 jobs a year. What is best layout of tables for grouping Bids, Tasks, Production Schedules, Job Cost Estimate, Job Budget tracking. I guess my question is how do I best structure so I can view individually for each of these and also combined across all jobs for everything except budget and estimates?

Is there anyway to change the text alignment for long form text to be left justified instead of right.  See screenshot.

Hello....I need to automate a record when its status changes and reply to the original email (attached msg format into each record) to the sender with some editions. Has anyone tried this? 

Hi, I was wondering how does the 10 login badge work? Or is this effectively broken?

My text fields imported from excel have a question mark where an apostrophe should be.  Is there a simple formula to correct this?

Hi There, It seems that there is no way to call directly an external API to a record on Airtable. My goal is to be able to shorten URLs (using Bit.ly API) in my database. I was wondering if there is a way that scripts might be able to help? Here is Bit.ly API reference : https://dev.bitly.com/api-reference I appreciate any help on this subject. Thanks

We dont have URL shortener? Any free workarounds, formulas, links? Tnx!

Hi everyone - I have a Airtable based that hosts events across states. And another base that hosts emails and location of users. I'm trying to create an automation that send emails weekly event reminders to users based on the event location that matches the users chosen locationsIn the email list base - a user can input multiple location based on their preferences. In the event based - events are listed based on state. I think I should be doing the automation in the email list and link that to the event base. I hope to send a list or grid of event to X user name and email. I was able to setup the first half of the automation using find records but not sure how I can automatically send the emails with limited manual work. could someone please help me out? Happy to share my base to assist 

Is there anyway to do a sum of averages within a selection using the number boxes?Bottom grey number on the left is what I'm trying to tweak.  Over the last 12 months, I've sold 663 units for a total of $4,107,840 (bottom two green #'s).  I need to sell 118 more (top grey #).  Ideally, I want that bottom grey box to not show me the average per, but a sum total of the averages.  So $4,107,840/663 = 6196 * 118 = $731,128.  Any one have an idea on how to get there?I thought maybe build that value into the base itself somehow, but I'm having trouble running sums within the individual records so they all return the 6196 value in real time (or close to it)...

Hello AirTable Community,Here's a fun one that I hope I can pick some brains on.  We have a Workday integration that creates an employee directory that feeds quite a few bases. With the Workday integration, we have to use a unique identifier - that being employee ID. However, employee IDs are not regularly used in our company so many do not know theirs. When filling out a form, they would typically use the employee name, which is not the primary field in the Workday integration (because of the unique identifier requirement.)Is there any way, via automation or some other method, to have the linking record be the employee name instead of the employee ID? If not, has anyone made a successful automation that would switch these columns after each sync with the Workday database? This has become quite a big blocker for us, so hoping someone has an idea of how this might be accomplished. 

Is it possible to limit the options for a single select field in an interface form? i can definitely do this in a regular airtable form. but i can't seem to figure out the way to do this in an interface form.example: single select fieldOption 1Option 2Option 3Can i make the interface form only offer them the choice of Option 1? or only Option 1 & Option 2, but not display Option 3 as a choice?

HiIm trying to work out a fix for an issue where the automation is searching for empty records of a column and emailing the relevant editor. The issue that comes into play is that it will find say 3 records of one author and add their email in 3 times instead of just once ? Im not certain that I may need another logic step added in?    

I have a URL field that I need to grab specific text from (in bold). Does anyone know if there is a formula I could use to easily grab just the string in bold without pulling in additional data from the 3 possible formats?Here are the multiple formats that the URL could be in:Sample format 1:https://www.website.com/en/others/A1087A50-AB73-48AA-B056-A3A472711A9ASample format 2: includes ?ABC=1 at the end https://www.website.com/en/others/A1087A50-AB73-48AA-B056-A3A472711A9A?ABC=1 Sample format 3: includes 2 URLs only separated by a spacehttps://www.website.com/en/others/A1087A50-AB73-48AA-B056-A3A472711A9A ABC: https://www.website.com/en/others/A1087A50-AB73-48AA-B056-A3A472711A9A?ABC=1Sincere thank you in advance for anyone who takes the time to look into this and provide any suggestions!

Hi everybody,How would you go about sending an image from an Airtable attachment field to an image field in a Webflow collection item.I have set up a scenario in Make using a webhook. Works great so far for all the text based fields, checkboxes, etc.But I can not figure out, how to pass on the required image URL, so I can map it in Make.Does anyone here have make scenarios with images running?Thank you for your help!

Hoping someone can help me.  I'm sorry if this is not in the correct section.  I'm new to this and not sure of what to call most things.   I'm a crafter and i'm trying to use Airtable to keep an inventory of my craft supplies.  I have imported data from a different system, and have titled the column that contains the URLs for the photos  as "Image" and defined it as URL.  However, i can't get the images to populate.  I wrote an email to airtable asking for help, and although i keep replying to emails saying they're busy, with i want to wait, it's been well over a month and i still don't have a response.  I have tried looking up on the internet in various places, and have found issues the same as mine.  However, the fixes they show apparently are from a different version of airtable than is currently available, as many of the screens they show have different options from what I see, and i have not been able to equate the old to the new t

Hi, I'm trying to make a p&L. I'd like to grab the total expenses per month from the Expense Table and reference it in the P&L table. I've oragnised the data in the Expense table by month. In the group view I can see the totals, but I can't reference or copy them to the P&L Table. I tried to get around this by creating a "Lookup" linking the expenses in the Expense table to the P&L table. But I have to manually select each transaction. I have thousands of transactions and selecting them one by one is too time consuming. Does anyone have any advice for how I can make this work?  

Inside the Interface Designer, I've tried many ways to get this Record List from the Project Tracker template, but could not find a way. How do I get this? I have tried creating Record Review, but the behaviour is somewhat different. I tried creating from blank but the only option available is Record Picker. Appreciate your help and expertise. Thank you in advance. 

Hi,Please allow users to download all attachment files in one click. We should not have to manually download every file individually.Thank you!Kerry

Hi all I’m curious to know if there is a way to use single select tool in web forms pulling from data from the grid indicating that a selection has already made. For example, if 10 people are signing up for 10 potluck dishes and one person has already signed up, the potluck options are reduced to nine in the forms. I guess this is considered conditional but not sure how it would work. Thanks

Hi,Not sure if title accurately matches my question. I have 2 tables linked by "Part Code":Table 1: Parts. Columns: Part CodeTable 2: Offers. Columns: Supplier Name, Part Code, PriceIn Table 1 I would like to add columns that automatically select the lowest Offer per Part Code. So Table 1 would have e.g. columns Part Code, Cheapest Supplier, Cheapest Price. Latter 2 automatically filled.Is this possible, if so, how? Any help appreciated!