Other Questions

I’m new to Airtable. I’m creating a spreadsheet base of experts and their contact information. Each expert has expertise on certain public companies in the technology sector. Each public company has a ticker symbol (as in, the stock ticker symbol). For example, Dynatrace is DT. Some experts are experts on as many as 15 public companies (so 15 different tickers). What would be the best way to set up this base of expert contacts so that it is highly searchable and sortable by ticker? Let’s say you have 1000 contacts and you want to search for contacts who have expertise on “DT”, the question is how should I go about setting up the columns so that this search functionality works best? Also, in Excel, Excel auto-suggest words that it remembers when you type something in a cell that’s also been typed higher up in that same column. How do I get Airtable to do this? I would ideally want Airtable to suggest “Dynatrace” if I begin typing that word in a cell because it recognizes it from cell hi

Presentación del primer capítulo del Taller en Español Interesados en participar, inscribanse aquí. Todos son bienvenidos, especialmente los usuarios de Airtable hispanohablantes. Meetup SEGUNDA SESIÓN DEL TALLER DE AIRTABLE® EN ESPAÑOL mar., 22 sept. 2020 18:30: El taller será presentado por Luis Cuezzo, consultor especialista en herramientas de LowCode y cuenta con el auspicio de :Digital GlueDesarrollo de aplicaciones de tipo LowC

How to share the dashboard with grid view and map app as a website?

Is there a keyboard shortcut to trigger opening the Search App? Currently if you use the standard search shortcut (Cmd+F / Cmd+G) you get the standard search bar:

Looking for some insight here. Tried searching all around, but I can’t figure this out. In my base I have a table where I enter products as they are being produced, recording the widget, the quantity produced, and the day it was produced. These widgets are grouped into categories which are linked to a “category” table. On the other side of things, I have another table where I’m recording the raw inputs as I’m using them, linked to the same categories table as the widgets. Every day, we tie out the inputs with the outputs to make sure that everything lines up. I would like to have a permanent record tieing out these numbers in my base. I know that I can do rollups based on dates but it’s always something that has to be static, ie sum everything from yesterday. I would like to pick a date in a date field and then sum up all the widgets produced and raw materials used on that date. Is there a way to do this? Hopefully, this makes sense. Please let me know if I can clarify in any way.

Greetings Airtable peeps - I’m cleaning up my client’s contact database and looking to enhance address data with Integromat and Google Maps. So far I can get a formatted address back (yeah!) and I can see a big array of address components in the Maps module, but I don’t see how to access those components visually in the followon Airtable module. Anyone have experience mapping to Google Maps address array components? Edit - I figured out how to select different components but realize that I need to collect and extract the specific component. Unfortunately Integromat’s example on JSON collection and extraction no longer seems to have those modules available… or I can’t find the new names. Any guidance here?

Working with a healthcare related database where items are used across several departments. I need to identify where the price charged is different from other departments. Ideally, I would be able to have a check box or notate them in some where where I could then filter/group. Example: Item Department Price 123 ER $50 123 Clinic $50 123 Radiology $100 How could I flag Item numbers there is at least 1 with a different price? Hope this makes sense.

I tried installing one of the apps from the Airtable Block Contest but ran into problems. Here is the error page: Are there any videos that shows what it should look like step by step installing? Any suggestions as to why I get this error?

how can i do dedupe on multiple Tables ?

Hi Airtable community, I work for a nonprofit that works with at-risk youth. We are looking to transition to Airtable, but need the expertise of a consultant to do so. Would any consultants be open to an introductory call to discuss our needs? (Need for a dashboard, track progress over time, etc.) And, then to discuss rates? Thanks in advance! Kendra

Is the WEBSITE DOWN now ?

For example the status column has 5 options, so i want to use the same column in second table and see the changes i.e if i add more column / status options they should be reflected in other tables as well. Is it possbile ?

Hi All! I’m trying to use apps to create dashboards to support my team in managing their workflow. I’ve made a dashboard that pulls from several different grid views for each possible status a member could be in. When you click on the bar in the chart, a list of records shows up, then when you click on a specific record it opens up like a card view. I was hoping to be able to customize that view by editing the grid view it’s pulling from, but that doesn’t seem to work. Anyone have any tips? Thanks! Pam

Hi everyone, I was wondering if it is possible to not only embed views/forms, but also apps. We are working a lot with the Charts tool and would like to embed it on our website. Thanks! Andre @Legalnaut

Hi, Did anybody hear about this before / try it? Integromat Airtable Integrations Integromat gives you the ability to integrate Airtable with many other services.

My boss sent me an Airtable invitation to my email so that I could make edits in our company’s workspace. I created an account with the email the invitation was sent to so I could accept the invitation, but every time I click the invitation link it brings me back to my blank default workspace. How do I add my company’s workspace to my account if not through the invitation link? Is this something I can do from my end, or does my boss need to do something?

HI, I am having troubling sharing access to people and allowing permission to edit their part of the data in the sheet. eg. There is a row that mentions five relationship managers with their client details. They should be able to view, edit and only their details to the sheet. Other RM details should not be visible. Please advice what should be done in this case. Thank you. Regards, Afreen

Hi, I have a view that displays some calculated values on a given order. The problem I have is that some of the calculated data is dependent on information that is outside the scope of the table. For example, one of the columns gives an estimated commission for an order. The commission, however, is dependent on each individual sales representative. What I would like is the ability to have an end-user using a view be able to fill in some “variables” that would control the calculated values in the field. Using the above example, a sales representative can enter their sales commission percentage value (unique to each person) and then have the view automatically updated the records using that value. In a typical spreadsheet application, I would just have a separate set of cells where the user could specify these variable values and then the sheet would automatically update as they changed. Is this possible within AirTable?

Hi All, Do you know if it’s possible to have a static image inserted into a form so the user can view the image? Probably something very simple that I am overlooking. Thank you

¿How can I hide comments from a record for “read-only” users? Gracias por la ayuda :slightly_smiling_face:

I am trying to set up a database to keep track of staff clearances. I have fields for each clearance with the date the staff got the clearance. Is there a way to get notifications when a staff’s clearance is going to expire? For example, the FBI clearance is valid for 2 years from the date it is run. How would I get a notification when 2 years is up and they would need to renew the clearance? Any help would be appreciated!

Hello, I am trying to set-up an email automation that uses information from Lookup fields, but when I try to use that information it says “This Property Cannot be Used Right Now”. My workaround is to create another field and concatenate the information from the Lookup field but that leads me to create duplicate columns. In Zapier, which the email automation seems to mimic, I am able to pull in the text from the Lookup fields no problem. Does anyone have a workaround they can offer? Thank you!

I am new to Airtable so I need help thinking this through as well as how to execute some of the steps. Data - I have 2 tables of records: Nominees and Committee Members. Objective - Each of the committee members needs to score each of the nominees. Those results will be averaged and displayed along side a list of each nominee. Scoring - I would like to send an email to each of the committee members with a link or form embedded in the email. That form needs to display each nominee, their website and a few other bits of info, then the committee members need to be able to score each nominee on a scale of 1-5. So the score is the only field that the committee member is asked to enter. Tabulate the Results - Do I need a separate table to tabulate the results? The scores will be averaged and the average score will be displayed in each nominee’s record in the nominee table. Display the Results - Create a view that lists all of the nominees, their websites and their averaged score.

I see in one of the Airtable base templates the Group By feature next to the filter feature but I have no group by feature. Is there a way to add this?

Hey Guys, I am not a developer but I use Airtable for my startup. I am able to copy a lot of scripts that are useful but I can’t seem to solve this one, I would be grateful if someone can give me a code for it. I need to be able to do a sum of a field that has many clients. My problem with the roll-up formula is that the first field in my main active database is dates and not clients. Meaning, in order to use the roll-up option, I must enter manually on a linked field all the dates that each client has orders and I have a very large database, it just can’t be done. Either I need a code that automatically populates all the dates linked to this client in the linked field and then I can use the roll-up or I need a script that allows me to calculate the sum of a field based on each client (ideally the second solution looks better). Thank you