Other Questions

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

I’m trying to port over my UPC check digit calculator formula over to airtable but they don’t support “sumproduct”. Here is the formula, can someone help me find a solution in AT? Excel Formula =A1 & 10 - MOD( SUMPRODUCT(MID(A1, {1,2,3,4,5,6,7,8,9,10,11}, 1) * {3,1,3,1,3,1,3,1,3,1,3}), 10)

Today I am unable to add new rows to my base table on my free account. I get a pop up screen saying i need to upgrade to have more than 5 collaborators. I only have four defined.  Does anyone else have this issue or know what i need to do to get round it?

I have outlined and organized my novel in Airtable. It's a beautiful, perfect system for this. But I want to do one more radical step: actually write the novel. I need a basic text editor window bigger than the one currently supplied for "long text" fields. Are there any extensions or solutions out there? Or hey airtable people, can we get a text editor extension? Please?

Can someone help me figuring out how I can copy all the options in a single select (my example has 5 options, but assume a have a sigle select with 1000 options), and paste it in another table, as a regular text field? i need this because I want to create a db with all those options, and use link record.. as this info is in many of my forms, and get updated regularly , thanks! 

I'm sitting with a client who needs have a massive library of materials that is put into subgroups depending on category. I thought the AI search could be a potential game changer, however they don't want to switch it on before they have an idea about cost.We've been trawling the Airtable AI and billing section, but so far haven't found where it says how much credits the search functionality takes. Does anyone know?

Hi, I wanted to provide a link to a separate site in the help text of a specific form field. Is there a way I can add links to that or is it all just plain text?

Hi everyone, I'm building a personell planning Module where you have your Project and you can assign workers to the project for certain time periods. The basic Idea/Tables behind is: 1. Projects: All info about the project. Start & end Date coming from "timeslots"2. Timeslots: Can be either a project or work term. Work terms are linked to projects. I then set up a timeline view and see my project and am able to plan out work terms beneath it (grouped by project, sub grouped by type). This is all nice and well. However there is one fundamental Problem: If I group by Project, sorting by date suddently does not have any effect anymore. Ideally I want to have the current projects at the top and the further down i go, the further they are in the future. But like this I have lots of projects inbetween that only start sometime in the future. Is there any way I can so

Probably a niche use case but wondering anyone can think of a way to make this happen.I'm trying to use airtable to organize some wire and cable take-off quantities and routing for a large scale construction project. The main entities (tables) are wire/cable, conduit, and pull/junction boxes. The boxes are like the nodes, the conduit link nodes together, and the wire runs through the conduit and boxes from an origin box to a terminal box. There may be many levels of branching. Possible that there is some spider-webbing as opposed to just straight branching but not positive yet (rare if so).I have the table setup so that there is a record of conduits, with an "origin" and "destination field each linking to the table of pullboxes. This link defines the end points, or nodes, of the conduit IE Conduit #1 goes from Pullbox A to Pullbox B. Conduit #2 goes from Pullbox A to Pullbox C, Conduit #3 goes from Pullbox B to Pullbox D, Conduit #4 goes from Pullbox D to Pullbox E, et

Hi,I have a table called Launch Calander that I link records from other tables like Email task, Website tasks and Digital & Print tasks.The lookup fields for all the other records show fine in the Launch Calander except for Email.I've tried deleting the linked record for email and starting over by creating it again from within the Launch Calander, then creating Lookup Fields and making sure they are linked to the Email Linked Record. Yet, nothing shows up. 

I've used Airtable for several years and have a workspace with approximately 80 bases.  Prior to one of the "upgrades", I had organized my bases in a way that was easy for me to find which base I was looking for and that made sense to me.  Now that the workspaces are sorted by opened by you, alpha, or last modified, it is very time consuming to find the particular base that I am looking for.  The "upgrade" may have been great for many people, but it was horrible for me.I have looked and can't seem to find a way to manually sort my bases so that they stick.  I suspect that this is no longer an option for me.Does anyone have an answer?I tried to contact support, but it has been several weeks and the only communication that I received from them was asking if I had received an answer yet.  Of course, I had not, because no one had answered. Thanks! 

I need to be able to export a airtable views from the mobile app. Do I have any options?-It doesn't appear that there is any functionality for this currently in the app- It doesn't appear possible with automations- There doesn't appear to be any extentions that do this- There are third party apps, but as a small charity we can't really justify paying for one for this use