Other Questions

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:

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 eve

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 mark

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; //

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

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  🙏  

Hello. I have used the script extension to get the URL stored in the URL field of the currently selected record. I am using the button field to send the URL to the script but ideally, I would want to just click on a record and the extension identifies the currently selected record. However, when I try to output the URL from the record in an iFrame, I simply get the HTML code for the iFrame in my output. How can I display the actual website? I know it is possible because the "URL Preview" extension built by Airtable is able to display some webpages.Here's a screenshot of what my output looks like:And here is my code:    let MyTable = base.getTable("Shopping List"); let field = MyTable.getField('URL'); // When run from a button field, the script skips the p

Hi, I have a formula that averages 2 ratings fields. I wish the formula field would show stars instead of numbers. Is there a way to do this with the rating field? Or with a more complex formula? See my current screenshot below.

While i do see lots of posting and tags saying “looking for a certified airtable consultant” but I am not able to find a accredited program or a pathway to become a certified consultant?

I have an inventory tracking challenge that I’m having difficulty with In my line of work clients order resources. Each resource contains a number of items from my stock room. I want to track inventory of items automatically based on resource orders that clients make. I think I need a formula that says "hey! a resource has been ordered.That resource contains items A,B,C…Let’s subtract “quantity items used” from “item inventory level.” Note: The quantity of items used will vary based on the number of participant the client wants to use the resource for. I haven’t gotten very far with this but the image below gives you the idea. I want to subtract 40 from the stock levels contained within records 114, 110, 107, 105, 104 and 112. I’ve learned a lookup isn’t the way to go but now I’m stuck.

I have some useful Airtable templates and recently discovered that Airtable credits are a great way to use Airtable for free by participating in Airtable's marketing campaign for growth. My question concerns the best way to attract users by making my private Airtable templates public. I have tried:(1) Inviting a user as a commenter. This worked, and I earned the credit, but unfortunately, the commenter cannot copy the base; they can only comment.(2) When I create a public share link, it works as intended; people I share the link with can easily register and copy the base template to their instance. However, I don't earn any credits this way.So my question is, is there any way to achieve what happens in (2) while still benefiting from the credits like in (1)? How can I share the templates with my fans and still earn credits?P.S. I'm not interested in money or cash; I'm asking for Airtable credits. Helping Airtable users and attracting new users to Air

Hi there,Is it possible to fetch job titles from Google or Slack without having people being an Airtable userThanks in advance for your help