Other Questions

Does anyone have a template suggestion or a template they use to keep up with employee vacations, PTO, injuries (workers comp), start date, status of employment etc. Thank you.

How do I disable the “Getting Started” pop up from showing up?

Hi everyone, Wanted to ask if this was possible (whether through an extension or formula or automation): We have excel files that are uploaded onto Airtable as attachments (Table 1) We currently download these files manually and copy-paste the values onto another table (Table 2) in Airtable Is there a way to automatically extract the values from the excel file in Table 1 and update/create records of those extracted values in Table 2? Thank you in advance.

Hello. I hope someone can solve this problem. Split text content by commas (or other symbols) Put each split text into multiple fields How do I enter the function to make this possible?

I have a list of records in grid view and gallery view - gallery view is much more preferred for my use. However, when I manually rearrange the columns in grid view, they don’t automatically update the order for the gallery view as well. Is this possible to do? It seems like there may be a simple way to do this, but I’m not really sure.

Hi all, Got a real brain teaser here (or at least one my brain can’t handle lol). I’m trying to calculate the ACTUAL DURATION - EXPECTED DURATION of ticket processing time for our team. The EXPECTED DURATION field is calculated: NO OF TICKETS(integer)*5.5(mins)/2(agents)+30(mins) Notes: -5.5mins is our average handle time for 1 ticket -we have 2 agents on our team -each agent receives a 30min break per day This formula currently returns a decimal value (I have tried to set this as a duration but it’s giving incorrect results). The ACTUAL DURATION field is calculated: TIME START - TIME FINISH This formula returns a duration value I am wondering if there is a way to produce this master formula to let me know when our team goes over expected time to resolve tickets and vise-versa so I don’t physically have to do the calculation every day. Please help!

Evening all, As part of the warehouse inventory base i’m building, i’m also looking at the spend, profit and ROI of each record, with the intentions of displaying these on an interface for users to see. Above is how i’ve got my current table set up. The Spend and Profit values are added in manually, and then a formula (profit / spend) is used for the ROI field. This works perfectly for each individual record, however i came across an issue when looking at the totals. In my interface, i’m showing the total spend, and total profits using the Number element as a field summary. Unfortunately with ROI i cannot simply add up the percentages as this wouldn’t work. I need to be able to do Total Profit / Total Spend in order to get the correct value. Unfortunately i’m struggling to find a way to do this, as i cannot apply formulas to a Number element in the interfac

I’m creating a social media calendar. When a date has passed OR an item is marked as ‘posted’, I would like to turn that row grey. How do I achieve this?

Hi! Below is the formula I’m using DATEADD({Fast Action $7K Paid},30,‘days’) I want to prevent the “#ERROR!” message from appearing when the “Fast Action $7K Paid” box is left empty. This field won’t always be used and the error message constantly showing is a tad frustrating. What do I need to add to the above formula to ensure that when nothing is put in the “Fast Action $7K Paid” then the error message won’t show in the next box? Thank you for any and all help!

Hi all! I work at an university and I’m trying to figure out how to change Airtable Forms’ font so it can align with our branding policies. Right now we can only use it internally because the font is out of compliance. Please help and cheers to Airtable! Best, Marisol

Hello! I am currently editing my base and trying to create different grids within one section. However, whenever I create a new grid, it copies the data and information from the first grid in the section. How do I prevent this? ETA: this is happening in multiple bases. All new grid views are populating with the same data across all bases.

I need help figuring out an issue I’m having when filtering a view using a lookup field. I have a project tab and a task tab set up. For the tasks, I have task owners set up. The tasks work in a chronological order. The first task needs to be completed before task 2 can start, and so on. For the projects, I have a formula set up that automatically updates the project status when someone completes their task using a checkbox. I want to have a view for each person in the task tab – where they can see all tasks they have to do, but I want them to ONLY be able to see the tasks where they are up to complete the task (aka the task(s) before them are all completed and the status of the project aligns with their task). I have it set up where it currently filters for the task owner, the project status (through a lookup field from the project tab), and if the task has been marked complete through the checkbox.

This just started as of 5 mins ago. I can no longer make edits to a Text field in a table in a base. The Chrome browser just errors out completely. When I open Developer Tools, I see that the updatePrimitiveCell call is failing with 503 errors. Is anyone else experiencing the same issue?

This seems simple but I am not sure how to accomplish this. I have my educators complete a form that requires them to enter their course start dates in ISO. This format is important for some concatenate fields and dropdown menus in other tables and forms, and thus I cannot change the format when the forms are completed. Currently, I am asking my instructors to enter the date twice: Once as ISO and once as friendly. In order to avoid entry mistakes and disgruntlement amongst the ranks, I would love to be able to do this with a formula. In short, I would my like instructors to enter the date as ISO and then in a second field the friendly date format populates magically. This: 2021-06-11 becomes June 6, 2021 in a second field. Thank you for your help.

Hey! I recently added the Maps extension and connected the Google API, however, when it comes to the next steps I’m stumped at what to do. For context, we are a small non-profit that offers two programs, and this one specifically provides diapers, wipes, and formula. When our mamas submit request forms with their full address, we want to capture the distance between their home and our Diaper Bank. If they’ve selected ‘contactless drop-off’ and their home address is outside of the GA perimeter (xx radius) then their status will change to ‘office pick-up’ and send an automated message. Is this possible? And if so, what do I need to do or what resources are available for me to attempt the setup? Thanks for the help!

Hi, When trying to filter conditions in my grid view I select WHERE (Facility). Then I need to select an OPTION (which facility). The problem is that not all options are coming up (facilities) This problem exists only in the shared view link. If someone can get back to me asap I will be extremely grateful Thank You so much and have a wonderful day!

Hi all, I’m new to airtable. My students complete a form that captures their goals for the year. Is it possible to have another form that will populate the goals after I choose the student’s name? I’d like to use the second form to create notes on goal progress. Thanks!

I’m not clear how to setup an order form - The customer (input) experience should be to lookup product 1 add product and quantity (or variants) to order lookup product 2 add product and quantity (or variants) to order (customer see’s product total’s summary as we can see in Grouped views submit order request

Hello all, I’m working through the parent-child relationships of a self-linked table. I need to build a hierarchy or path which traverses a multi-level hierarchy using a “child” relationship. Some other solutions in these forums are focused on a “parent” relationship column, such as the excellent solution by @Justin_Barrett here: https://community.airtable.com/t/parent-child-tree-hierarchy/44094 Using the above solution as an example, I would like to build the following hierarchy: I’m open to other feedback on how construct this, even if it isn’t a scripting solution. I’ve just used the above example as a starting point. I’m also aware of the parent vs child tradeoffs of self-linking tables. I’ve gone through m

Hello! I have two large tables with different data for members of my union. Individual members in both tables share the same ID # in a field in both tables. I’d like to link the tables in such a way that data from field from Table A will automatically copy to a linked field from Table B, based on the common ID# field that the two entries/rows share. How would I go about doing this? Most beginner field-linking demos show me how to link fields, but then I have to select which record to link to manually by expanding the cell and selecting the record. But Table A and B both have hundreds of records and I would like to automate this process so that anytime there is a value in the linked field from Table A, it gets automatically added to the linked field in Table B, organized around their shared ID # field. I can do some scripting but am not an expert. Thank you! Jacob

Hello Can someone give me an advice? Sorry, but my english is not great to explain everything as I want. For a restaurant, I have recipes, with ingredients, and they came for vendors. What is best? 3 bases linked, or just 1 base with everyting? The 3 bases, that look logical to me, are: recipes, inventory, and vendors. recipes, with photo and calcs to estimate costs inventory, to track ingredients costs from different vendors, quantities in stock, and reorders vendors, where I can see their ingredients, with their contacts, and track the payments Ingredients is the only thing that must equal in all the 3 bases. But I never did any base, so maybe I’m thinking wrong. Thanks in advance

Plese help! Since 2 hours ago I can’t upload files in attachment fields.

Hello, I have a problem with data manipulation when grouping records on a date range. Each record has a date and a time, (they are cash receipts linked to a cash register). Of course I have multiple records per day. I want to group these records by day and verify the data via another table (the cash register verification table). To group my records on a date range I have no problem (I used formulas of type DATETIME_FORMAT(Date, "DD/MM/YYYY ")). On the other hand I want to use the sum of each day and link this sum in another table of my database and I can’t do it with the rollup because it considers the records unique and not grouped. In short, on the one hand I have customers who buy, and on the other hand I want to do a data validation on the totals of several columns per day and this without having to link via a rollup each record of each customer. Thanks for your help.

Hello, anyone get this error and message when pasting data? → Sorry, your request conflicted with another change I’m getting this on the web and desktop version, with any kind of file, even just created ones. Thanks.

I’m having a bit of trouble managing complex bases that heavily rely on linked records across tables. I’m finding that, as I develop a project or a record keeping methodology I tend to change field names to help myself and my teams keep information conceptually well defined. This becomes problematic when a renamed field is a linked-record field type. Because the newly edited field names from one table do not update the linked-record field name in the related record/table, that other table can quickly become very confusing and difficult to relate to. Of course this can be corrected by carefully managing names across tables manually - when one field name is changed, the editor carefully changes all linked-record references to it across the base - but it is starting to become a whack-a-mole problem for me. Can anyone relate to this problem and/or provide insights on how to get past it? Would it be a reasonable feature request that the names of lin