Other Questions

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 interface design. Any help on this would be much appreciated.

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. However, for some reason it is not filtering correctly and is showing all of the task

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 multiple iterations of this project already, trying both approaches. Thanks for the help!

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 linked-record fields are inextricably lin

Hi! I Created a Date field and used a formula field to output the day of the week because I’m hoping to get an output that reads something like, “Saturday, August 20, 2022” – When I use the concatenate function, the date formula changes from Friendly to ISO with time added. Time was not enabled on the date field. Is there some other workaround to get what I’m looking for? Thanks in advance!

Hello! I am interested in creating a Master Calendar that will allow individual freelance staff to access the calendar and input their availability dates. Each person can only be able to see their information, not the information another freelance individual has entered. I then want to be able to see all entries in my Master Calendar. Does anyone know how to do this? This will need to be a calendar they can access at any time to input or update their personal information. What is the best way for them to access it and for me to remind them to update on say a weekly basis? Thank you! I cannot seem to find specifics on this.

My goal is to detect overlapping usage of a resource on the same date and provide information of the respective overlapping record. For example: 2022-08-04-Resource1 User1 → Show User2 2022-08-04-Resource1 User2 → Show User1 I’m using an adapted version of the mark duplicate script to link records that share a matching string with each other and look/roll up information from the respective other. That worked fine until the growing dataset started causing script timeout issues (60s). Recently @Justin_Barrett taught me how to use REGEX extract. I thought to instead create a roll-up on the resouce and REGEX extract the records string out of it. Unfortunately, it will only match the first string (and seems not easy to exclude itself). I wondered whether there’s another way to achieve this?

Hi! I’m using the Pivot Table extension to summarize my expenses per category/month. It works a treat: Better yet, when I click on the values on my table it shows me the records related to that specific value (the expenses related to that category/month). Almost perfect, but the information shown on the right side is not really helpful. I’d love to be able to see custom information like the Amount and Payee (both are columns on my table) in the summary of each record. I understand Airtable is choosing the info that gets displayed because they are the values used on the pivot table, but they are repeated and not very helpful. Is there a way to choose what gets shown there? Thank you!

Hello! Looking for help or to find out if this is actually possible. I am looking to pull numbers from a row in table A and paste it in table B in one current field. So in other words I want to transpose a row from table A into table B, If that is possible. Thank you in Advance