Ask the Community

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?

Because automations are so limited in formatting options for email messages, I'm stuck having to create a bunch of extra fields solely to copy specifically formatted other fields and change them to flat text so they'll appear correctly when emails are sent.Because of this, I'm currently hung up trying to get currency to format properly. I have a formula field that outputs values as a currency into a field that we'll call "Dollar Total", including thousands and decimal separators. I was able to use a concat formula to get the basic copying done, including adding the $ manually at the start, but it doesn't handle decimals properly which then further complicates trying to get a formula to manually insert the thousands separator commas.For instance, if a value is "$14,500.00" it'll output as "$14,500" but if it's $14,500.80" all I get is "14,500.8". It'll go out as far as I do with numbers after a decimal, but if it's only zeroes it drops them, and then that breaks the manual insertion of

Is there any way to archive a chart in airtable?I created some graphs using the airtable interfaces, the point is that one of these graphs represents how much I spent on each category in the current year until the current moment, so when the year turns, this graph is reset.I would like to be able to archive it or "freeze" it within the airtable itself, so I would have a year-by-year history to analyze in which categories I spent the most in that particular year.If it were possible, I would like an automation to copy this graph and archive this copy on December 31st, since on the first day the information will be reset. If this function doesn't exist yet, please think about implementing it, it would really be very useful. 

Hi all, Can one base be the central CRM and the content editable in all other bases? For example, one central base could hold the organizations (companies, etc.) and their contacts, while the other bases could be used by different team members. The central information would be in each base and could be changed.I've created an image and each square represents a base.  

When creating a form, we can limit the options the submitters can select. Is there a way to do a similar set up at the user level?I was thinking maybe, at the interface level, we'd be able to limit the selection of a single select field. But that doesn't seem to be an option. Maybe there's another way to do this? Here's my scenario:I have a dropdown that my users can edit, but I don't want to give them all the options. Maybe I split the options and connect them with formulas?I have an Inventory Table with a drop-down where users can change the status. Some of the statuses are for office use only, so I'd like those options to be filtered out.Thanks in advance for any ideas!

Hai,I am trying to connect Airtable in .net maui. I installed Airtable 1.4.0 ,AirtableEfcore 1.1.0 and CData.Airtable.EntityFrameworkCore. This is my codepublic class TestDbContext : DbContext{public TestDbContext(DbContextOptions options) : base(options){}public DbSet<Student> Master { get; set; }protected override void OnModelCreating(ModelBuilder modelBuilder){base.OnModelCreating(modelBuilder);}}public class Student{public string Id { get; set; }public string Name { get; set; }}protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder){var services = new ServiceCollection();services.AddDbContext<TestDbContext>(o => o.UseAirtable("app66666Xep", "patSOBFs83Vv6"));var sp = services.BuildServiceProvider();var scope = sp.CreateScope();var db = scope.ServiceProvider.GetRequiredService<TestDbContext>();TestDbContext Db;var x = db.Master.ToList();}But I could not get a connection Services is null.Please help how to get connected. Thanks 

This connector method exposed the PAT in cleartext. If I share the Excel spreadsheet, the user can discover my PAT and query other company tables. They would need to know different table and base IDs. If my computer storage gets compromised, the hacker will get access to this PAT. Is there a better way to authenticate than using a PAT as a parameter?I do see a method in data source settings of query editor (PowerBI or Excel) called Web API but Airtable has deprecated its use.https://support.airtable.com/docs/visualizing-airtable-records-in-microsoft-power-bi-power-query

Hi all,I have a question about exactly when an 'update' change type notification would be sent via Airtable new Webhooks API.For example, say I'm writing some text into a 'Single Line Text' or 'Long Text' field, will my webhook subscription for 'update' notifications be called multiple times as the text is being entered, or will it debounce and wait some x number of seconds after I've stopped typing?In the documentation for webhook notification delivery, it states:If multiple changes occur in rapid succession, then we may generate only a single notification for them.Does typing text into a field, at a normal typing speed, fall into the category of 'rapid succession'?

HiWe are trying to build a form with the new Interface. We noticed an issue when adding a new Number field from the interface. The field will eventually be created in the base, but once we click on "Done" or Published, this is what will pop up in the form. The fields initially created in the Base will eventually disappear too, which is really annoying. Any ideas about what the potential issue might be? Thanks!