Ask the Community

I need to have the formula to calculate the total revenue and profit from my sales records table, which has been linked to my product inventory table. The aim of this set up is to update records automatically with every sale.

Hi my name is Jerry.  I am not at all new to Airtable but my experience is not particularly broad.  I built our Airtable base 8 or 9 years ago and haven’t done any development work on it since.  I am not a programmer.My problem:I am creating a package receiving solution for our freight forwarding business.  We receive packages, log information regarding that package and place it in the racks for future handling.  I am looking for a way to easily add a photo to the package record during the receiving process.The process: A new record is created by scanning a preprinted, barcoded label which is then applied to the package.  The scan gun is then used to scan other information from the package such as shipper and tracking number.  The customer name is selected from a linked field followed by entry dimensions, weight and comments.  Then the box is opened and a general description of contents is scanned into a field from a prepared list on the wall.  While we have the box opened we would lik

I have numbers 00001 to 00014, but have not listed the numbers from 00015 to 00200 yet because I to update photos with a watermark. However, I have records from 00200 onward updated and on the website. Is there a way to include 00015 to 00200 as empty records to maintain the sequence of autonumbering then input the record for 00201 and continue? I hope this makes sense.  thanks Linda 

Hi Dear Community how to add a column for updating the price same as ther second image Thanks         

Hi Everyone, I've started using the new interface forms and come across a few issues with loading. The latest one can be seen in the attached. When a client receives a link in an email to the form, then adds some text, they get this error when submitting 'Refresh Page to Submit Form' (Refreshing doesn't help)This works OK if I'm logged into Airtable but not from a incognito or anonymous users. The form is set to allow anyone on web to submit. Anyone else having this issue? looking for a quick fix rather that return to the previous forms Cheers       

How many rows/columns/cells can Airtable handle at its maximum limit? For example, Google Sheets can handle up to 10 million records. What’s the limit for the Airtable?

Hola, hay alguna herramienta para modificar los formularios por defecto, altura de las filas, espacios, quitar cabecera, etc.

Hi, I have about 50 task fileds that each have a status. They can be marked as Assigned, In Progress, Complete, Question for Supervisor,  Question for Administrator. Each field is a multiple select field, because sometimes there is a question for both the supervisor and the administrator. I have a view for the supervisor and a view for the administrator that are each filtered to only show tasks that have a question for them. I have a formula field for each them that pulls out which task has the question.The formula for the supervisor is as follows: (The admin has the same formula, just with ADMIN instead of SUP in the formula)CONCATENATE( IF({Task A Status}="Questions for SUP", "Task A"), IF({Task B Status}="Questions for SUP", ", Task B"), IF({Task C Status}="Questions for SUP", ", Task C"), IF({Task D Status}="Questions for SUP", ", Task D") ) This works great. My question is, what if I have a question for both the supervisor and the administrator. Right now, if both those options ar

I have 2 rollup fields in a table that are formatted to show ARRAYUNIQUE(values). I am trying to create a formula column that combines these values in an array, and only displays unique values. I was trying to use: ARRAYUNIQUE({Rollup1},{Rollup2}), but am only getting the values from Rollup1 to show up. Help?

I hope someone can help with this please  Connecting from n8n and I’ve created a personal access token and entered it into the Credential to connect with field, Below is the scopes and access permissions I’ve checked that the Base name and tables are correct  I’m not sure what I’m missing here , will be grateful if someone can assist

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!