Ask the Community

I have a decent sized based we’re using as a CRM. Every entry is tagged with a representative’s name in a single select field. Over time, some reps have come and gone, and I don’t want to have their names available to select for new enteries, but I don’t want to lose the data of who made previous entries. What I really wish I could do is toggle certain single select options on and off, but I don’t believe I can do that without losing the formatting that we have now, which is helpful. Anyone know a way around this? Screen shot below of what I’m trying to achieve. I do not want to use an interface to resolve this problem, as my team typically does not use interfaces that are built for them! Thanks for any advice you all might have! 

Hi! I am using Airtable to create an inventory of items in a museum of education related items. The vast majority of the items in our collection only have a year attributed to the item (i.e. class of '89, picture taken 1976, Spring 1935, etc). I am wanting to create a timeline view to show a history of certain schools, subjects, and other grouping criteria. Is there a way to have just a year (YYYY) be read as a date for timeline and gantt purposes? 

Hello,I am new here and am trying to find a way to create a new record (and auto-populate some data into this new record) when the user pushes a button on a different table.Example:I have table A and table B. I want to find a way whereby if the '2024 Definate Grow out' box is checked on a given record in table A, a new record is automatically inserted into table B, which copies over some of the data from the relevant record in table A into this new record in table B. I have managed to create an automation which inserts a new record in Table B every time I push the button on a record in Table A, but do not know how to copy across the data into the new record on Table B or if this is even possible.  Thank you!  Z

Hello guys,  I would appreciate it if I could get some help on this. So the context is that I have two tables. 1 table is for quotation (Tbl_RFQ) and another table is for when quotation is confirmed (Tbl_Confirmed). For example, an item in Tbl_RFQ may invite 3 bids (i.e., 3 records). However, only 1 bid will be selected for each item. When the winning bid is selected, new record will be created in Tbl_Confirmed. This requires an automation which I managed to do.  Automation to create records in anther tableThe problem is that, most of the times, some details are not yet filled in Tbl_RFQ so it means that when new records are created in Tbl_Confirmed, some fields are missing. What I am trying to do is to link the created records in Tbl_RFQ and Tbl_Confirmed together so that if the fields in a record in Tbl_RFQ is updated then the same field in the same record will be updated as well.A simple solution may be to just create a lookup field in Tbl_Confirmed that links the two tables togethe

Hello Airtable Community,I am hoping that someone can help me out with an automation that I am trying to build.  I am new to Airtable and am figuring things out as I go.  Well, trying to at least.We are a small behavior services company that works with adults with intellectual disabilities.  Since our inception, I have been tracking how many hours we provided to each of our clients in Excel but it was too clunky so I have started using Airtable instead.  So far I am impressed but I am having some challenges getting all the things I have pictured into my head to become reality in Airtable.So far I have built a base that has a couple of important tables.  One that has the necessary information that I need to track for our clients including what services they qualify for, a weekly tracking sheet that captures each clients hours delivered for that week and a rate sheet which then can tell me what those hours translate to in terms of billing payments.  I also figured out how to build a form

Hello all, We have recently implemented Airtable on our team to account for hours worked by employees. To gather the information, I created a form in which they answer at the end of every work-day to take into account the actual hours worked. These answers feed a database that groups every reply by week/employee. In the database, I created a column of “Work-day” which is the employee’s weekly hours divided by 5 business days. This way, when they answer the form, I would have the daily overtime and then it would be grouped weekly and it would give me the weekly overtime.However, the team is mainly composed by part-time workers and that’s where it becomes tricky. We don’t really enforce a fixed start/finish hour, so a person who has a contract of 18 hours/week, may work only 2 days one week and then 5 days the next week, picture below.  What I would like for it to do, and that I wasn’t able to, is to calculate how much overtime (or time they didn’t work) they are doing per week, based of

Good Day I would Like to Attach a pdf document to a email when sending it from an automation. How do I do this?

Hi there,In order for me to create a junction table. How can I get certain data from one table to another? I am looking to get all submissions, team, month, points awarded.   I would like it to move over these fields and when a new recorded is added for it to add those as well Is this possible?

I have started a blank canvas instead of using a template to show various data.  Is there a way to use a pivot table within a blank canvas?  I want to show points given by each team as the column and each row would be the team then across the top would be each month and then within each would be the number of points given. I would then want to replicate this with the amount of submissions example is below using the template   

Hello,Am wondering if there is any way to have a table in page designer be dynamic in size?  We would like to use page designer to generate invoices, but some clients have only a couple of lines while others have 15-20.  The biggest current issue are the large invoices that have too many rows to fit into a one-page table.  Right now, it just gets cut off. Is there a way to extend the table to a second page?In an ideal world, my total price, etc. fields would be at the bottom of a table that only is as tall as the number of rows in it, whether it is 3 rows or 30.  Thoughts?Thanks,Alex

Hello,I am trying to figure out how to create this base without over complicating it. I have customers who need to request licenses for three different softwares. This needs to be in the same form. They need to specify length and quantity of those softwares.  In the from I'm also asking for basic customer information. I've currently set it up so the customer picks the software from a linked table, with conditioning then asking for 'Length' and 'Quantity' for each selected software. https://airtable.com/shrw2mPLjYm203vkk My problem is, that in my base, I'd like separate records for each software picked by the customer, but I'd like it to happen in one form submission, so the customer doesn't have to do it more than once:  Customer 1: Software ACustomer 1: Software CCustomer 2: Software BCustomer 2: Software C Is there an automation I can run for this? Or just a smarter way of setting it up?

I have an interface that has linked table of images.I need the user to be able to rearrange these records by hand (drag and drop) so they print nicely and the right order. This works if I do it in a view. However the user should only be in the interface. I seem to be able to find anyway to rearrange these in an interface using either a gallery or cards. Is it me who a missing a check box to allow this?

I need help creating a formula that will create a link that will show property details, access codes, checklists, photo uploads (for a cleaning business) thank you in advance!

How can I default to opening bases from the icons as it used to be instead of it opening interfaces always when clicking on an app? Very inconvenient for many of my users.

Hello, I have a primary table of records and a secondary table to request updates to the primary table. I want a column in the secondary table that lists all of the columns in the primary table that someone could select to update. Preferably, this would be a list that is linked to the actual column names in the primary table so that the list updates if I update a column name in the primary table. Is this something that AirTable can do?  TIA!

I WANT THE DETAILS OF THE SUBMITTED FORM TO APPEAR ON GOOGLE SHEETS… I KEEP ON TESTING THE AUTOMATION AND IT POPULATES IN GOOGLE SHEETS BUT WHEN I TURN IT ON TO WORK AUTOMATICALLY NOTHING HAPPENS… WHAT AM I DOING WRONG?   

I am trying to use Airtable and Softr to create a page with fund applications for individuals so that I can track which year a fund was applied for and what its status is (ongoing, granted or rejected). It is important that each fund is presented on individual lines through Softr. If you look at the picture, that is how I want it and managed to do it with Google Sheets and Softer. But I am having problems with Airtable. Does anyone have an idea how I can do it?  

Is this base design possible? See image. I need to schedule a variety of sessions categories (29) across a variety of times. Each of the session categories has a varied quantity of allocations. In the photo attached, at the top you can see the session times and the rooms. In each cell is a pull-down list of the allocation type. At the bottom left in the image, you can see the allocation type and the quantity. The table at the bottom sums up the amount of time session allocation abbreviation is entered in the top table and then allows for a horizontal sum calculation.The top table would be very easy to construct. What I’m wondering is if we can make the bottom table a visible entity on the same table? It will be important to see totals as the sessions are allocated. 

Hi community  I'm stacking with how to put 2 or 3 on the same page in the interface  

Hi Dear community  I'm building an application for restaurant management And I need to implement roles and permission As the following Chefs can create recipe subrecipes and  menu creation menu engineering Store keeper can handle purchase orders receiving and invoices , inventory Manager or owner access to the dashboard to see reports and statistics  Thank you for helping and guiding me Warm wishes Chef Tarik 

Hi, my staff are grouped in 3 areas. Central, West and East. Each team has a deputy manager (DMs) and a manager (Ms). It's important that DMs and Ms can not see records of staff that are not in their area. Does airtable allow you to set up granular permissions?Also how can you stop deputy managers seeing the managers or ceo records?Thank you

Some field types including single selects, multiple selects, linked records, and collaborator fields will show “List” or “Record” instead of the values you may be used to seeing in the Airtable grid view. This is consistent with how the Airtable Web API returns information.

Hi all! I have a problem that I feel should have an obvious solution: I’d like to set up an Automation that normalizes a string value after input by base collaborators. However, the Automation appears to run too early, catching only parts of the input string. (This behavior is not consistent, though: From time to time the Automation will catch the whole string.) I selected When record updated as trigger and configured it to watch only for changes in a specific field (in my case: Keyword). Example from the screenshot: The entered text is “Aldi Angebote”, but the Automations appears to run already after the first letters are typed in, so only “Ald” is used as Automation input. What’s the best way to solve this problem? Is there a better trigger for this use case that I am missing?

Hello,I need help understanding who can comment to each other in the Interface Portal feature. I set up an interface with multiple pages, each shared with different external guests who have "Editor" access to the interface, but not the underlying data. For example, page 1 is shared with all guests, page 2 with guest A, page 3 with guest B, and page 4 with guest C.Guests can only comment to me, the base creator, and when using "@" they only see themselves and me. Even if multiple guests have "Editor" access to page 1 (which all guests have access to), they cannot comment to each other. Here are some screenshots: Screenshot 1:   Does anyone know what's going on with commenting in Interface Portals? I've looked at help articles (like here, here, and here), but none really answer specifically about Interface Portals commenting.Thank you!

Let me first preface these questions with I’m a vet tech not a computer programer/data person, and I’m only doing this for my hobby. I have these two PDF files that I would like to add to my air table to help me classify my model horse show string. I would like to put conditions on the drop down list so If I select one general breed or specific breed or class only a certain list comes up,  Is this possible? What is the best way to do this?  Thank you for your help- Sirena Breed Cross refBreed/show class reference