Ask the Community

I've been using airtable in its most basic functionalities for a year or so now, though hoping to dive into it a little more deeply this winter. There's a specific tool I wish to build and have a roadblock that I think shows my novice status. The vision of the tool is that it'd function for capturing and organizing ideas and information I get in my day to day between the different life focuses (categories) and I'm not sure how to structure the tables or links/relationships. Essentially I currently take down my ideas and useful information in a notepad. Every once and a while I go through and sort it into some documents with sections. However, I figured why not create a form I can put the ideas into that categorizes them upon entry?For example, I'd have some main categories and each would have subcategories so I could have a field for inputting the idea, then choose the category it belongs to and subcategories and it'd organize it upon entry. For example

Hi all, i need help form you 🙂i have 2 tables : - VariantTable -CostTableThe key is the SKU, this field is in the 2 Tables.I would like to add colunn in VarianTable with the CostPrice.How to create field with Automaticaly put the CostPrice when SKU is same.  Thanks for you help

Fairly new here…so…I’ve created a form but the recipient needs to fill in the form over the course of a year (Growing vegetables for us & includes info/observations for the whole growing year)…is it possible for the recipient to save the form and add to it and then submit when all the data is complete? Or would it be better for me to create an app that they can fill in? Thanks for any advice, much appreciated.

We have a very lengthy form that requires the employee to go back and forth between apps and input information. Is there an option to save the form and go back to complete later? If this isn’t available in Airtable does anyone have any suggestions on creating a fillable (mobile) form to collect data while out in the field?

Hello everyone!Im trying to automate a LinkedIn Image Post using Make. But i have some problems:Even tho my scenario runs successfully, the post dosnt get posted to LinkedIn, the problem is the image.I dont know how to get the image from Google Sheet/Airtable to the LinkedIn module, even tho i use a HTTPmodule, which is weird.Here is the scenario:This is in the output from the LinkedIn module:The image URL is public, so Make can find it.Do you guys have any tips?

Using the insert Grid/List of Records into Automation email how can I include more than the Name field of the record,? Similar to what you can do with a Grid in the Page Layout designer? So the result in the email would look like:Name 1 Date StatusName 2 Date StatusName 3 Date Status Again this is a field in the main record that looks up related records that I want a Grid of, but with more details.

If I add an attachment of an Image via DropBox, is there any way to see, use a formula, or API, to pull the actual DropBox URL instead of the Airtable URL which of course expires?

Hi Community,I have a team annual plan. I have a base with 8 editors. How do I read this bill?Thanks!

I have a table of grants data for 20+ foundations, many of whom have overlapping grantees. I'd like to create a linked record that will pull the name of all the foundation that support a common grantee but cant figure out how to do it. Grateful for any tips/advice. Thanks!

Hey All, I’m looking to have a field that stores a hyperlink version of said URL field that is generated from a formula. I’d like to create this text(hyperlink) either via a formula, or more what I’m thinking an automation? Anyone aware of an ability to update a field with a hyperlink? Thanks

Is it possible to query my Airtable bases, add and modify records, etc. using chatGPT-like interfaces. Anyone encountered such a tool?I mean if you can ask human language questions, like "how many records created today?" just for example. 

I have an automation attached to a button, and I want to insert the user who is logged in to a field. I can’t seem to figure this out. Is there a current_user() formula?

I have several single select columns with "yes/no" selection answers. I want to make a sort of if/than formula to combine the information from those yes/no columns. For example, in the photo below, there are columns a, b, c ,d, e. We will call those each "foods" for the purpose of the example. If someone says "Yes" to foods a, d, e but they say No to foods b and c, can I make a column that combines the yes data? I would like a formula field to show that the person has chosen foods a, d, e, just like how a multi select field looks. I have thought about using If statements, but I'm not sure if that will allow multiple answers into 1 column. I'm not even 100% sure a formula can give me the information I need. Does anyone have any input on this? 

I'm building a system for our staff where I need to be able to find colleagues of a given person for a given project in a particular building.Our structure in airtable is like this:We have four tables:BuildingsProjectsPositionsStaffThe buildings table simply serves to tie them together, being linked to from the projects table as a location.The project table serves to explain the project itself and gets linked to for the positions in that project, from the positions table. The positions table helps organize certain positions, like designer, or electrician, that may be organized before the staff for that particular position is chosen - which, of course, is then taken from the Staff table, holding all of the staff details.What I'm trying to achieve, is by a button press from the staff's profile in our interface, set a filter over a list element that matches that specific staffer's dates of starting and ending on th

I have a client base with tables for sales, onboarding, offboarding, interactions and I want to create a table for course completion.What would be the best practice for this table? I have 250 clients and I can't export the data from my course platform host so our VA will be manually entering the % completed for each client on a monthly basis. Would my primary file be the client and then I create a new record for each client each month and add the % of course completed as a number field?Is there a way to make creating new records super quick? 

Hi,I have set up a very simple automation. I've created a folder called "Leads Sent" and want any email that is placed there to trigger the creation of a record in my base called "Leads". It works a charm when i test it, both allowing AT to choose the data, and when I manually choose the data. When I turn on the automation and copy any email into the folder, nothing happens. The emails I put in there are a few months old, does that matter, and if so, can I tell the automation to pick any email, irrespective of date, that is new in that folder? Or is there another kink in the system that I am unaware of?I do not want to run this through a 3rd party integration, I want to use AT's own automation, so please stick with suggestions that will help solve that relationship, thanks. Thank you./Christopher 

When I use to copy a base via public share link, automations copied over as well. They were just turned off.Now when I do it, automations aren't copied. They're all gone.Am I doing something wrong? Was this removed?

The interface designer has an update button and delete record button. I wanted to create a button to duplicate record so some of the data need not be reentered. Any way to do it through the automation. I could not seem to get the automation to recognise the current field

Hello all! Would anyone know if it's possible to create a Slack > Airtable automation? I am looking to get data on how many times and when a client creates a message in Slack. 

Hi there, I have a repetitive formula field that I need to turn into a lookup / roll-up field in another table.Here is the formula field for reference. What are the steps I need to take to allow for this formula field to be a lookup field on another table?IF(AND(WEEKDAY({Go Live Date / Event Start Date (from Program Name)})=1, {Email Week}='Week 1'),DATEADD({Go Live Date / Event Start Date (from Program Name)},-25,'Days'),IF(AND(WEEKDAY({Go Live Date / Event Start Date (from Program Name)})=1, {Email Week}='Week 2'),DATEADD({Go Live Date / Event Start Date (from Program Name)},-18,'Days'),IF(AND(WEEKDAY({Go Live Date / Event Start

Hi!  Background info.... I have a number of clients whose information I have stored in an Airtable base.  This information pertains to their upcoming meetings and information for them to prepare for those meetings. Currently, I'm providing them with a 'share' link from specific views in the base so they can view their upcoming meetings on their computer and/or mobile device. While the information translates fairly well to mobile, I'd like for it to be a little easier to view.  Has anybody done this?  Does Airtable have any 'mobile app' capabilities? Hopefully that all makes sense!  TIA!

Hello Airtable community,I've been working on a project where users input data through a form, and the results are recorded in the base. I have set up a rollup field for each question to calculate the average of the results per field. Now, I want to create a graph in Interface Designer that displays all the columns along with their averages in a single graph and sorts them from highest to lowest average.I'm currently having a hard time achieving this, and I'm wondering if I'm approaching it the wrong way. Could anyone provide guidance or suggest a more effective approach to visualize this data in the Interface Designer?Thank you in advance for your assistance!https://airtable.com/appbYmoC5vgmEZJPx/shrZ7wAcVoE0AcfIA

Hello everyone, i'm creating an new Kanban record from a sync table of other base, the sync is ok and also the automation to create is ok, but it only works fine when the whole line is fullfiled at the time, if someone fullfill one cell each time it will create one record for each cell. The issue is that always return that the record does not exist. 

Is it possible to create a custom view type based on an existing view type but modified?I would like to add columns with labels to the calendar single day view.  Is this possible?  

Hello,how can I calculate the weighted average? Example:[-4, 0, 2, 0] -> I get this values via a roolupI want the result to be -2 i.g.. Correct me please if I am wrong.I'm open to use multiple formulas. Best regardsJohannes