Other Questions

I have tried to explore airtable marketplace but I cannot see any option to publish template created by users. Is there any way to do it so?

I have a base where conversations with customers are sorted into different category, like pricing, features, complaints, technical requests, etc.I want to create an overview that shows how many conversations of each category happened in different time periods (Last 24 hours, last week, last month, last 3 months,...).This is how it looks like: Is it possible to make that so that the number of conversations of, for example, pricing are rightly entered automatically into each of the columns?(This is where the conversations are saved:)

Hello Airtable Community! I need help figuring out an easy data entry model for our YOY production reports.The basics: We have ~150 clients and ~75 suppliers (every year some clients leave, some are added, which is true for suppliers as well, meaning those lists are not static). Our clients sell products from our suppliers. For every year, our suppliers report sales for each client, which we collate into an individual sales report per client (I need help with reporting too, but that's a problem for another day). So each record in the production table is something like this:(linked to Client Table)(linked to Supplier Table Sync)Sales YearSales AmountClient ASupplier 12023$1,000Client BSupplier 12023$0Client CSupplier 12023$5,000Client ASupplier 22023$500Client BSupplier 22023$10,000Client CSupplier 22023$0Client ASupplier 12024$750Client CSupplier 12024$1,000Other info: The client table and production table are two separate tables/tabs in one base (client base), and the supplier list is

I'm using the 'color' attribute to color-code my fields according to type of item in the primary field, but now I have reached six colors (including the default color), I cannot proceed any further.Is this normal?

I used the Dedupe extension almost daily to remove duplicate records from my bases. I also have clients that use it as well. Today I got the following error message. Usually reloading the extension takes care of any issues, but today, I just keep getting the error message, even after reloading. I tried deleting the extension and re-adding it. Still error message. I even tried adding it to another base and still had the same issue.Anyone else experiencing this? I reported the issue, but wondered if anyone else had the same issue.

Hard to believe, but iPad quality of life re: Airtable is worse today than it’s ever been?  My M1 Air running 17.4 does everything else I need it do, but the app is useless and the website looks ok upon first loading…. But I can’t even switch tables…Is anyone at Airtable listening?  Do any iPad users have any workarounds?   

Attention AT staff: The view on the What's New page is broken. Looks like the sorting has been set to Month of Release rather than creation date, meaning that it is listing in reverse alpha by month name.   

I have created a three table airtable, for project planning. Projects have a Start Date and End Date Resourcing links to Projects, and has a Start Date Override and End Date Override, as well as two Formula fields, Start Date and End Date, which choose either the project Start and End dates, or the overrides if set. Ie IF({Start Date Override} = BLANK(), {Start Date (from Project)}, {Start Date Override}) I have created a Gantt view using these formula fields as Start Date and End Date, which works fine as a normal user. However when I try to create a shared view, I see instead “Start date field is hidden or invalid” Table setup Gantt Setup The error :frowning: Any help would be appreciated

Hey guys!I am noticing my airtable performance has been really slow lately. I manage serval workspaces with multiple bases synced across each other so I'm not surprised to see it move slowly. I was wondering if anyone had any tip or tricks or preventing this? Thanks!

Hi guys, I can not find place to change language here. Can you kindly show me how to set language in my Airtable? Thank you

I have a lookup field in table A that is supposed to retrieve values from a number field on table B.Some of the values on table B are 0. Currently the lookup field on table A is showing blanks for all 0 values.0 is different than blank. For my purposes, blank means missing information and 0 means 0.How do I fix this? I have a feeling that if I changed the table to a text field it would help, but I have some integrations with accounting software and would rather not do that if I don't have to as it may muddy some other things.

There is a way to embed the google MAP extension view but I can't seem to find instruction on what the embed code looks like. There is a related question that's been open for several months and I sent a support question and I haven't hear back on the answer. They suggested to search here but I can't find any answers to this. Here's an example that does work on some other site but I can't get this embed code for my MAP view 

Does anyone here have experience with using miniExtensions? Couple of their features (like forms and shared editable view - especially this, looks like it could sold quite a few permission problems we could potentially have with default permissions of Airtable) looks like it could really improve and help with a workflow we plan to implement. But since they are not some well-known names (like Zapier or Integormat for example), or at least we haven’t heard of them before researching Aritable specific integrations (and I don’t mean any disrespect by saying this) my company can be a bit reluctant to depend on some software packages or integrations that we don’t know anything about So, if anyone has experience with using their services, it would mean to hear first hand experience, as they have some really good tools (from the information on their site) that could help us a lot and we are seriously thinking about testing them and hopefully using in our workflow if everything goes good.

Hi,how can I create default value to an attachment field?

Hello,We are having problems with some of our clients where they can't add records via the mobile app.The "+" button works once and then it becomes not clickable unless you exit the base and re-enter it.My clients are using Samsung Galaxy S9 and A (something).

Hi there,I'm looking for some help with improvement of a "Work on Today" field.The field we have currently is a checkbox for each colleague--each person has their own "Work on Today" checkbox with their name marking their field. In a view of my tasks on the base, I have it grouped so that when I check my "Work on Today" box, it will automatically then show that task (along with any others I have marked) at the top of my view.It works great as it is, however, we have more colleagues now and it would be great to have a single field for all colleagues that had the same function as the above one. However, I cannot get one to work in the same way because of groupings/filters.Initially, I thought a "Work on Today" multiple choice field would work as each person could select their own name when they were working on a task that day. The issue with a field like is that the view can't function in the same way. If a task a colleague and I are both working on is marked by that colleague as "Work o

Hi, i’m looking for a script or automation of airtable to put my table into a csv file. How can i do it? i found this. how can i download it? // display app title output.markdown('# Export to CSV'); // set the table name let sourceTableName = "Search"; // identify the fields to be exported let aFieldList = ["Name","Surname","Linkedin Link"]; // get the source data let sourceTable = base.getTable(sourceTableName); // get the data set for 2018/2019 let result = await sourceTable.selectRecordsAsync(); // set a counter for testing let count = 0; // iterate across all the records let csvFile = ""; let csvRow = ""; let csvItemCount = 0; for (let record of result.records) { // build the current csv row csvRow = ""; for (var i in aFieldList) { csvRow += record.getCellValueAsString(aFieldList[i]) + ((i < aFieldList.length - 1) ? "," : ""); } // add the row to the file csvFile += csvRow + "\r\n"; csvItemCount += 1; // increment the row coun

I have a field that contains people’s heights in centimeters. I’d like to create an additional field that converts those heights to feet and inches, specifically using the format #’#". The conversion part is easy; to get from centimeters to inches, you simply divide by 2.54, after which I’d want to round to the nearest inch. It’s the formatting part that I’m hung up on. For example, 175 centimeters converts to 69 inches, rounded to the nearest inch. But how do I force 69 inches to display instead as 5’9"? Thanks in advance for any help here!

I use Airtable for my property managers to update all of their respective property statuses. i would like an easy way to see when the last time they have updated their tables (should be every day). what’s the best way to accomplish this?

Hi, I have two dates in my base, one is manually inputted, the second is linked from another tab. The date pulled from another tab is the most recent date and we need this date to replace the manually inputted date so we can track most recent updates. I've tried creating a new column that merges these dates but that isn't working. I don't know what I am missing.I attached that it looks like not sure if anyone can help. Thanks in advance for reading this!Sam

Hello. I've been studying airtable lately.I'm trying to express a sheet in Excel with an airtable, but I want to create a cumulative balance field, but I don't know how.Is there any way to find the balance of this row after adding or subtracting this row's income or expenses from the previous row's balance? Please advise.

How can I make it so someone can add drop down items to a field but not be able to delete,rename,access specific views? Seems like this permission system needs to be more complex bc I’m finding that I have to give up a lot of control to simply manage a table/view or add new rows. I feel like there should be minimum one more level where I can create a user to manage rows and specific fields but not delete/rename views. am I missing something? 

Hi,I have paid for the team plan because I need the automations.And I have questions:1. If I want to add employee to the workspace, I need to pay for his user aswell?2. If I want to hide from the employee certain tables, views and dashboards, is it something possible to do with airtable? Thanks.

Full HTML support in automationForm/application in scripting both in extension and in automationNative Plecto integration for tables to be used as database for Plecto.Pandadoc support, with creation of contracts with info from records, and then backwards updating on changes like signing. (In generel programs for contract creation)Typeform extended features to update records in Airtable also instead of only creating records.Many of these features would make a. Zapier cheaper because less tasks would be used, and more could be done within the Airtable environment. If I'm requesting something that can already be done within Airtable, or you have any hacks to these, please give me feedback 🙏 I have already made som sneaky tricks myself to create time feelers by using formulas, automations and scripting to overcome things I couldn't do natively to handle Information and creating flows and processes to make manual intervention minimal. I would love to share these if anyone

I have a single table where I have different columns for Town, County, Region etc. I then have a Description field with some generic copy but at the end I want to automatically add the Town name within its row (see image).E.g. Town: Aaron's HillDescription:  Welcome to the beautiful town of {Town}Seems like a fairly basic requirement but I've done a lot of Google searching and I can't find the answer. Any help very much appreciated  🙏