Other Questions

I am trying to sort information for employee reviews in columns, but I;m not sure what tool I should be using or if it is even possible to do in Airtable. Here is the scenario: I have a list of email addresses (column 1) and employees (column 2). In column 3, using a linked record to the email address, I have assigned people who will do peer reviews. Now I would like to add a column that shows all the employees assigned to the original employee (column 2). Is this possible?

I have a database that uses tags. When a new tag is added, I have to manually change everything. This sucks because there are hundreds and hundreds of rows! I was hoping that I can create a separate table with all the tags in it and when I add tags to that table, it would be available in the dropdown menu. I know I can do this with a linked record?, but the search feature I want to keep would not be available, which is the toggle feature below. The linked method does not show the user what tags there are to use or search by. Anyway, just curious if this could be done…without having to pay for a service as this project has no funding.

Hello- I am a formula novice. I have created a countdown formula to track how many years and months I have before my leases expire. If looks as follows: ({Remaining Term (YRS) (as of today)}& " years, "& Months) This formula works well, but I cant seem to add a “IF” statement. that if my {Remaining Term (YRS) (as of today" field is blank, i.e., no date, that the formula returns the result “Vacant” Any help would be appreciated.

Hello, We create a workplace with differents collaborators. I would like to automatically send emails but with the email of a collaborator. Is it possible through Airtable? Thank you.

Hi everyone, I’m using airtable to keep track and make labels on our orders. The Page Designer app is very friendly in terms of the design and inserting relevant information on the label. However, I couldn’t figure out a way to make the printing part easier. For example, when I have a few items on each row and each has a different quantity (let’s say item A x1; item B x5; item C x3). All I can do now is to go to “Current record” from the app and print each item one by one. It is very frustrating when we have more than 100 items. I’d love to hear your experience and what you could think of to solve this problem. Cheers, Jane

Hi, I want to know how to the change the avatar background color. As you can see in the attached screenshot, two of the collaborators have the same background color for their avatar icons. Apart from updating the picture, can I change the background color to differentiate them? Thank you. Victor

Trying to to get a percentage in a column called %won. I have a basic formula of {actual amount/amount needed} however some of my actuals are $0 so NaN appears in those columns which won’t give me a total Average of % won. So I used an If statement IF({Minimum Credit Needed} = 0,{Actual Credit}, IF({Actual Credit} = 0, 0, {Actual Credit} / {Minimum Credit Needed})) Now I have some crazy percentages and my average is not even close. When any of the columns have a 0 I really just want it to not factor into the overall average. Can someone help me with the formula? Thanks

Feature suggestion for Airtable. Make markers on text for comments like you do for images. That way a user can identify what another user is commenting about like the part of a text field. Comment tracking is the main reason our writers won’t switch from Google Docs to Airtable.

Has anyone used AirTable for proofing (i.e. email, print materials, graphics, etc). That would be willing to share an example of a base that works for you? We’re looking to outsource our proofing process with a different software, but if there’s a way for it to work within AirTable, that would be the best.

Hello there, In setting up grid views I noticed that when a non-account holder has access to a view, there is a “Try Airtable for free” pop-up on the right side of the view. Is there any way to not have that pop up? Also, for both account holders and non-account holders, a “Use this data” button is at the top right of the view. Is there anyway to hide or disable this? Thanks, Blake

Hello there , Is there any way to create conditional select fields in airtable? I want to change select option values for one select field on the basis of another select field dynamically. For instance I have 3 dropdowns A, B and C . A has 10 values , If I select 1 value in A select field , B field should display content related to A field and similarly C field should display the content related to B field. Is it feasible in airtable .I have tried to use views to achieve this but there are a number of options related to each field , so it will be quite troublesome to create view for each possible combination. Is there any alternative that we can make use of to achieve the end result? This functionality is implemented in google sheets with the help of google scripts but I want to use airtable to manage my data. here is the link for google sheet functionality : Loom | Free Screen & Video Recording Software

Hi, I am trying to call AirTable from inside a Lambda function using a local instance (using AWS SAM). If I just use node/js as is, it all works fine (so I know the code should work). But once I put it inside the Lambda and try to run it, I see nothing in the console. Any clues as to what is going on? This is the code I am running let response; exports.lambdaHandler = async (event, context) => { var Airtable = require('airtable'); var base = new Airtable({apiKey: 'k***************3'}).base('ap****************8jC'); base('Course Locations').select({ maxRecords: 3, view: "Myview" }).eachPage(function page(records, fetchNextPage) { records.forEach(function(record) { console.log('Retrieved');//, record.get('Name (Abbrev.)') }); }, function done(err) { if (err) { console.error(err); return; } }); try { response = { 'statusCode': 200, 'body'

Budget for this: $0; meaning I am looking for solutions that are free. Is it possible to automatically keep two tables the same when adding a field to the main table? I don’t need to sync data, but the fields themselves. Example: When I add a field to table 1, that field will also be added to table 2 in the same place. Or if I delete a field, that field will also be deleted in table 2.

Hi, I am planning to recommend Airtable to my client for the coming project. We have a few automation tasks which Airtable has been proved to be the best tool. While Airtable provides powerful automation/scripting abilities, I am wondering is it possible to access the webhook headers as well in addition to the body/payload. Thank you!

Hi all, Does anyone know how to forward emails (Gmail) to create a new record as a task in an Airtable To-Do list? Similar to the way I can forward emails to my ToDoist inbox or a receipt to my QuickBooks inbox? Thanks!

I would like to generate a unique primary key for each record of a table/database based on the following criteria: Use the first letter of the person’s first name. For example, a record with the first name of “Scott” will have the key beginning with an “S.” Followed by a four-digit sequence number starting with 0001. Example: If I was to create a new record for myself, my key is S0001. If the next entry has the first name of “Howard,” the key would be H0001. Then if I create a record for someone with the first name of Susan, the key would be S0002 because S0001 already exists. Similarly, Helen would be H0002. etc. Can this be done using Airtable? Thank you. Scott

I am hoping to find a FREE solution right now, if possible. This project I am working on is new so there is no money to spend on it. So I have a table that has an input form for measurements like so: Field 1 Name: Height Field Answer: 70cm Field 2 Name: Head circumference Field Answer: 8cm Field 3 Name: Foot length Field Answer: 6cm Is there a way to combine those fields into one after submitting the form and format them (Bullet points)? Example: Field 1 Name: Measurements Field Answer: Height: 70cm Head circumference: 8cm Foot Length: 6cm Thanks.

What my team and I are trying to accomplish. Is have external user select information from the form. Once the form is submitted have the information that is linked be filtered and show the individual the result of the information. E.G. User fills out a form and selects apples. Things that are linked/mapped to apples will show up for them.

Hello Everyone! I would like to know if there is anyway to sync collumns from differents tables in the same base, for example, I have the table “A” with collumns 1, 2,3 and another table “B” with collumns 4,5,6. I want to change fields on table B from collumns 4 and 5 and automaticly do the same on collumns 1 and 2 from table A, but dont sync the other fields at collumn 3 from table A. Any ideas? Please and TIA. :slightly_smiling_face:

Hello, I am trying to figure out Airtable and how to make it work best. At the moment, I have products that can sell individually, let’s say a rose and sunflowers, but sometimes I sell them together in a bouquet (we can refer it as a package) which can constitute of 5 roses and 3 sunflowers. I think the main issue is that I have multiple products that have the same name (ex. sunflowers) that go into different packages (ex. bouquets). This is why linked records might not work best for my model. As of right now, I have all the products and packages as single select. I want to find a way to break up my package single select (bouquet) to be divided and entered as individual flowers. Is this a possibility? Best, Ines

I am a coach with many clients who I need to record their weekly weight in check. Wondering if anyone has a base/template similar to what I need and is willing to share for me to edit and use? Thanks!

I spotted an earlier post from Feb 2020 about enforcing two-factor authentication but I see that there have been no further announcements or a response from the Airtable team? I sent a message about 3-weeks ago now and I’ve not received a reply. The main reason that this is incredibly important is because when using Airtable as your CRM, we are holding a lot of very private data that under GDPR here in the UK needs to be secure. None of my 3 other collaborators use two-factor auth and this concerns me. Please can this be prioritised? Many thanks Catherine

Hi All! I am building a tool with Airtable as database and users can access using API. Is there a way I can review log of all user requests? I am especially interested in requests that failed to analyze and add those records to my Airtable db.

I am trying to create a template base with tables columns, automations, and synched tables that people can then duplicate to use on a per project basis (these are all very different projects with different biz units and we cannot just use one base for everything). I set up a base to act as a template but when I duplicate it, the syncs are all showing as broken. it looks like I have to re-add all the synch links. Is there something I am missing or is this approach just not going to work? We have some people who have to roll this out multiple times and they will have to cut-and-paste like 12 links for each base. Thanks

Hello everyone, I would to share a specific view with my client throughout the view share link (he hasn’t an airtable account) and I would like to give him the possibility to upload files to a specific record without adding new records. Is it possibile? I tried with a form but every time I upload a file I’m creating a new record while I would like to upload the file to an existing record. Thank you very much, Alex