Ask the Community

Is there a way to use the Multi-Select Field WITHOUT the field options being in Bubbles (i.e., as just plain text). I currently push several multi-select fields into Page Designer to generate record reports; however, have to maintain an interim field for each that uses a formula to strip out the bubble. It is a cumbersome workaround. Seems like there should be a "Bubble" toggle just as there is a "Color-code option" toggle.

Hello Airtable Community,I'm working on a project that involves calculating the Qibla direction using Airtable. I have latitude and longitude data for various locations stored in my Airtable base. I need to create a custom formula that can accurately determine the Qibla direction for each location.I have come across the term "boussole prière en ligne" (online prayer compass) and understand its importance in providing precise Qibla directions. Could someone guide me on how to implement the necessary trigonometric calculations within Airtable’s formula field to achieve this? Specifically, I’m looking for a way to:Input the coordinates of the Kaaba (latitude: 21.4225, longitude: 39.8262).Use the haversine formula or any other relevant trigonometric function to compute the initial bearing from any given point to the Kaaba.Ensure the result is displayed in degrees, representing the direction to the Qibla.I would appreciate any examples or step-by-step guidance on setting up this formula. If

Hi there!Quick question: If a recipient of an automated email from Airtable (sent by Airtable mail server) clicks on the "unsubscribe" link, will his/her email address be "blacklisted" for all automated emails from that Airtable base or is this specific to the automation which has executed the "send email" step?Cheers!

On one table I have item name/type/start date, and I’d like airtable to auto-fill some cells next to it in that row depending on the type/start date selected (type is a dropdown single select). So for instance on this table: When the type (green arrow) is monthly email (or whatever the type is), then fill in the cells next to it (purple box) which is called from this table: I’d also like it to fill in dates according to the start date of that item, so for instance if it’s type “monthly email” starting on June 17th, then according to the second table calculate the date of 2 weeks before the start date. Going to sync this with our CRM for activities, so these cells next to it are the item activities name/date. Here’s a loom video if it’s easier, thanks a lot Loom Charged Production [Copy for Development - June 10, 2022]: Pipedrive...

Hi all,I am trying to add info from a linked table (one to many relation) in the body of an e-mail in an automated action.This is my setup:TableA with Fields Name, Age, Status, Email, ...TableB is a collection of dates on which the person in TableA is expected. Fields: Name (from Table A), date, type of meeting)One record in tableA can have multiple lines in TableB.Now I want to be able to send an automated mail that contains the info from TableB (date and linked type of meeting).Is this somehow possible? If yes, can someone please help me how to solve this?Thanks in advance.Kind regards,Kenneth De Vos

Is it possible to link multiple filters to a single grid in an Interface? I have a base with 11 tables; 1 primary table and 10 support tables. In my primary table, I have 31 fields, 10 of which are linked records. I would like to create an interface for my client that will allow for as simple or as complex a query as needed. To explain further:My primary table is a plant directory. I would like my client to be able to choose a simple query, such as:All plants that are Red. I would also like my client to be able to choose a complex query, such as:All plants that are Red or Orange, Low Maintenance, requires Full Sun, is Fragrant and is Deer Tolerant.Is there a way in Airtable to be able to accomplish this?Thank you in advance, Mr. Brad B.

Hi,I'd like to give users a button to create a new table in the backend with default fields and table name. This table could be a duplicate of an existing table. Is is possible to implement this functionality on the front end?

Im loving MiniExtensions and Airtable. It does exactly what is needed without clunkiness. Creates a portal for users to work with and see your data.  Id looked at Softr, Noloco and others, but they get very pricey or very complex fast and need a lot of line by line field crafting. MiniExtensions is simple and does the trick.Keen to see though, with anyone else using Airtable and MiniExtensions, how are you better managing login and front end access?  Airtable creates users and magic links well, but Im hoping someone may have worked out a way to manage password or phone numbers to send the passcodes to? Users at my end are fairly simple so I need to dumb it down and keep it secure same time.

Hi everyoneTrying to see if an idea is viable from a cost perspective but can't work out licensing implicationsI want to build a FREE, NO COST application for a community scenario where kids are collecting and trading stickers.  The plan is to use Softr and Airtable and the app is basically built but now I'm wondering if it's viable using free licenses.Not sure of the number of users, don't anticipate it will be that many, maybe 100 even if successfulAny thoughts?ThanksMike

As per the title, has anyone connected a standard html form to Airtable? I’m struggling to work it out and need a little help.

I already have an automation using a webhook, that when I add a new record in a certain table, a sign request is created and sent to the relevant email address. What I need to do now is after the document is signed by the recipients, save it as an attachment on the same record.Any idea how it can be done?

Hello!I have a table (table A) that has two fields I want to display in another table (table B). One of the columns in table A is a check box value, the other is free text. I have linked table A inside table B and created two look up columns in table B to display the check box column and the free text ones but they turn up blank. Any ideas on why this is happening? 

Trying to set up the barcode generator (Little Appy Co) suggested by airtable - however the content field is not valid. I have tried all the suggested field types numbers / auto number / single line text etc but still telling me when I try to generate invalid field. Does anyone know what I am doing wrong. 

I have a table where we can record incidents occurring at school and select an incident category (e.g., stealing). Once a teacher selects an incident, they can choose the logical consequences from another table. Each incident category has a list of specific consequences. Can you explain how I can create a dropdown menu in Airtable and Airtable forms so that the values available for logical consequences are filtered to show only those related to the selected incident category?

I'm an author, and I use Scrivener to write my manuscripts. As you can imagine, keeping up with characters and all their details is a necessity but until I started using Airtable and up until late last night when I had an "ah ha" moment, it's been a nightmare. Last night, I configured a base to keep tract of characters and locations. I then created a character development form to fill out when plotting and designing the story. Another "ah ha" moment later and I remembered that I can add webpages to Scrivener as documents and they will open up in the editor pane as if the webpage is a part of Scrivener. So, I grabbed the share view link for the form as well as the Gallery view for the characters of the book series I'm working on and attached them to the Scrivener file. Everything is working beautifully, but it will not allow me to edit the character records in this view within Scrivener. It says I need to login or create an account even though I've got the base open in another

Greetings allI have various stock lists from my suppliers all in their own various PDF / CSV format.Each suppliers stock list has its own Product SKU Description.Some suppliers have one document for 'stock' (i.e. quantity), one document for price list (price per product SKU), and one document for 'Special Pricing' (an override of the standard price list).I want to map each suppliers stock and pricing to my unique Product SKU so I can then show the total stock I have available to sell to my customer network and filter the lowest pricing between my suppliers etc. Any suggestions welcome...Thank you!

I have a lot of personal views. I'd like to split them into sections like you can with collaborative views. I can't find an option for this. Is there a way to do this?

I want to create a summary of my table row, which has linked records to them. Ideally, the entire summary in text, with the linked records expressed in text within the entire summary. An example below:Case TableCase |  Person |  Invoice  1234 |  Michael | XYZPerson TableName | DOB | AddressMichael | 1/1/1990 | 10 Oxley RoadInvoice TableID | ItemsXYZ | Hamburger; Fries; CokeDesired output:1234; Michael;1/1/1990;10 Oxley Road; XYZ; Hamburger; $2; Fries; $2; Coke; $2Ideally what I want to achieve is:Case: 1234Person: MichaelInvoice: XYZLine items1. Hamburger \t\t $22. Fries \t\t $23. Coke \t\t $2Total $6.Apologies for the lame example for hamburger and coke...I consider myself less than an expert, so if you do have better suggestions I am open to hear them.  

I have two existing bases in the same workspace on a Team plan. The new dynamic filter option appears in one of the bases as an option for new and existing linked record columns. It does not appear as an option in the other base, either on existing linked record columns or new ones. All of the linked records use text fields for the primary key. What makes dynamic filters appear as an option in one base but not another? Thank you

I could use some help correctly setting up a multiple select field that monitors changes in other fields. For context, this'll be setup for internal use mostly for billing purposes. Once the tagged change(s) in the multiple select field have been resolved, they'll be manually cleared. Scenario: I have a multiple select field called Changelog that monitors changes in other fields in the same table- Contribution Status, Contribution Amount, and Current Donation. Any change in a record associated in a specified group should have their respected outputs reflected in the Changelog field. Issue: I want the Changelog field to populate any and all changes. Sometimes the output looks accurate, other times it does not. In the example screenshots, I changed a record's Contribution Status which resulted in changes to both the Contribution Status and Contribution Amount- correctly reflected in the changelog. However, when making this change, it affects the other records in the group,

I am building a base to control the orders of my market. In there, I want to "Add a new order" and select the products of the order, while choosing their quantities. Is that possible? Also, I want to calculate the order value with the quantities of each product.

Good day team,I currently have a table wherein we have an auto number field as well as an attachment field or excel sheet with our clients personal data. Then the data on the excel template will then be manually transferred to another table. Is there a way or an automation that could also captured the correct auto number field and be seen as well on the other table based on the subjects in the file? For Example:Subject 1 - 1234Subject 2 - 1234Subject 3 - 1235 Thanks

Field Type and Compatibility:Ensure Field Compatibility: Verify that the barcode generator field is compatible with the system or software you are using. Some platforms may not support custom field types or require specific configurations.Check Documentation: Review the documentation for your platform to see if there are specific requirements or supported field types for barcodes.Configuration and Setup:Field Configuration: Double-check that the barcode field is configured correctly. This may include setting correct parameters, like the type of barcode (e.g., QR code, Code 128), and ensuring it’s linked to the appropriate data source.Validation Rules: Ensure that any validation rules applied to the barcode field are correct and not causing it to be flagged as invalid.Integration and Implementation:API or Plugin: If using an API or plugin for barcode generation, make sure it is correctly integrated into your system. Verify that all necessary libraries and dependencies are installed and

hellotrying to add end meeting time, which is a formula of one hour later of the meeting timeso I did a formula one hour later, but it wont work 

I am working with a new company that has five main areas I would like to manage using Airtable. These five areas operate independently but collaborate on the same projects, each contributing different inputs.Here is my question:Which is better: to have five different bases that sync (one-way) to a main base, or to have all five areas work in a shared base with individual tables and permissions?