Other Questions

Hi everyone. I am trying to calculate a due date based on a specific date minus number of days before. Example: The master Date of a trip is 10/01/2022. I have a column (DAYS BEFORE TRIP) where I enter the number of days that a specific task needs to be done before the trip. I have another Column (DUE DATE) that lists the due date based on that calculation. I need a formula that basically does this… 10/01/2022 - (DAYS BEFORE TRIP) = Due Date So let’s say I need to book airfare 30 days before the trip. In the DAYS BEFORE TRIP field I would enter 30. My formula with then would calculate and display 09/01/2022 as the due date. There are so many tasks that I don’t want to have the trip date listed every time so I want to embed the actual date in the formula. I hope this makes sense. Thanks for your help!

When creating a record, in a table such as an Opportunity, and the Company has been entered (related/lookup table), how do you display a field based on the Contacts related to the Company - in a drop-down menu - to pick a single or multi value

Hi, Just wondering if there is anything available that allows users to search for a specific form using all of the fields within the database? Similar to the filter function but I don’t believe that will be user friendly for most people. The standard search plugin isn’t good enough for what I am trying to achieve. Is there anything on the website that I have missed that allows for this? It’s like form functionality but instead of adding to the database it will return results that match. Cheers

I have a table with dates of vacant shifts (let’s call it “Vacancies”). I have a second table to collect form responses for folks who sign up to fill vacant shifts (“Sign-ups”). T he dates in the Vacancies table are set to the Friendly date format. In the Sign-ups table, there is a linked field to the Vacancies, so when a user completes a form, they can see the vacant shifts and select shifts to cover for… Now here’s the problem: when a user selects the drop-down of available dates, they are in this horrid format and I don’t see anywhere I can change it… Does anyone know how I can get the form to display the friendly date format or a form user? It feels silly that I haven’t found how to change it and, if I can’t, then this form isn’t going to work out to fulfill the function I need it for :frowning:

For example table 1 has columns: Email, FB, LI. (which we can refer as Contact Channels) Applicant 1 has only Email and FB accounts Applicant 2 has Email, FB, and LI accounts In table 2 I wanted to create a contact channel dropdown list. Is it possible to have the list depending only on what’s inputted in table 1? For example, applicant one should only have 2 choices in the dropdown while applicant 2 should have 3. Or is there any way that it will automatically list down the channels instead of the dropdown list once the applicant added fields in Table 1 columns?

Hello, I have a company review database. On Table 1 is the Companies. Table 2 has the Reviews of those companies, with links to those individual entries. Each company has multiple reviews submitted by various people. I have linked Companies to Reviews, done a lookup for the url + title I want (from Reviews). The script I have transforms those into hyperlinks successfully., but ONLY if there is only 1 url and 1 title in those fields. Because each company has multiple reviews submitted by different people, each field has multiple entries (both url and title), and my script is resulting in one run-on link that shoved all the titles together. Any ideas how to edit this script to separate each of these out? I used: let tb2 = base.getTable("Companies"); let query2 = await tb2.selectRecordsAsync(); for (let record of query2.records) { let url = record.getCellValue("Individual Rating links (from Reviews)"); let text = record.getCellValue("Job Title (from Reviews)"); if(url) {

I am trying to do the following in Airtable: If Person A receives a warning for “Being Late”, the record is marked as “1” or “First”. If the same warning occurs again, it’s marked as “2” or “Second” If Person A Receives additional warnings for, let’s say “Stealing” or “Damaging Property”, it will mark each of these instances as “1” or “First” If the Record was to expire: e.g. Person A: Being Late “First” Expires Person A: Being Late “Second” Active, Then the Record that is “Second” becomes “First” Is something like this possible in Airtable? Maybe I am just missing something or my creative juices have just run dry.

let old = query[i].field_data; let new = old.SUBSTITUTE(’\n’,’ \n’); Results in “SUBSTITUTE is not a function”

I have a base with about 40,000 records spread over 20 tables. Base has been around for over a year. About 1-2 months ago I noticed that some of the table names reverted to names from months ago. Keep in mind this is not the default “Table 1” names but table names I had provided, but long since changed. One out of 5 times when I reload the page, I see the correct names. The other 4 times I see the old names. I have tried changing the table names using incognito browsers but as soon as I reload the page, the names are back to the old names. Has anyone else seen this sort of breakdown in their bases? Customer support hasn’t been able to solve this problem despite working on it for over a month with their engineers, so I’m hoping someone from the community might be able to give me more ideas.

Hello all! I hope to get some help on Frankensteining my own version of Stylebook and Pureple that creates outfits BUT is based user preferences instead of random chance, and doesn’t require the torture of photographing clothes. My Method So Far: I created a database of my wardrobe across three tables so far based on garment category: Tops Bottoms Outer Layer Each table has columns that describe a garment’s color, fit, fabric, length, collar/neckline, embellishments, closures, etc. Then I: Created views in each table based on Outfit Proportion. Copy+pasted those individual lists into a combination generator to create outfits Manually weeded out outfits that didn’t look good based on mismatches (eg denim on denim, black and red, etc.). What I’d like to happen: Outfits table that takes records from the garment tables & views to populate individual records Go through those Outfit records to find something I’d like to wear. I’ve tried the Junction app but that only combines table

Hello, I am tracking productivity: And I’d like to track the number of days that the productivity was above (let’s say) 75%, but happening in an uninterrupted sequence of days In the image above, the number would be 0 (or 1) In this example it would be 3 What formula would be used for this? And secondly, where should I write the formula? In contrast to excel, I understand that I can’t pick any random cell to calculate this because each row is connect to that record? Thanks!

Any plans for this? I have parts of one AT I would like to sync to another but don’t want to merge both ATs and end up with an insane number of tables to manage in one AT.

Hello all Is there a way to be notified when someone deletes a record? I mean… not just included in Airtable. I’m ok also with using zapier or other solutions… is there a way ANYWHERE to receive a mail when someone deletes a record? Thanks in advance Ivan

I am in Sydney/Austrtalia. Even when my base is showing a due date for today it does not appear in my today filter. Whats the story?

Hello people! Maybe someone of you can help me to “sort” this out :nerd_face: I have a table where the records are sorted automatically when grouped. when I link all the records into another table and group by the same field, the groups are not sorted correctly. I also tried to use the convenient “sort” command, but no luck… Any idea how to get the groups sorted using the linked field? Thanks!

Hi all, First time poster! I was wondering if there is anyway of displaying comments that have been made on different records but in one place?

I have a single select field named “STATUS” and I want to configure a button that would copy a record with all the following attributes and then make that new duplicate record’s STATUS set to “Voucher Re-Issued”. Below is the script I use to duplicate the record, I just not sure where or how to configure the STATUS to “Voucher Re-Issued” let table = base.getTable("Relocation") let query = await table.selectRecordsAsync() let records = query.records let fields = table.fields let exclude = ["UNIT ADDRESS [FULL]", "BR", "UNIT FAILED OUTCOME", "Voucher Expiration Date", "STATUS", "UNIT QUALITIES", "PENDING PO DOCS", "LEASE-UP SELECT", "PENDING DOC/VERIFICATION (TENANT)", "STREET ADDRESS", "CITY", "ZIP CODE", "YEAR", "W9", "Owner Name", "UNIT #", "Lease Up", "Data Entry Complete"] let filteredFields = fields.filter(x => !exclude.includes(x.name) && x.isComputed == false) let original = await input.recordAsync("Original Record", table) let obj = {} filteredFields.map(x =>

Similar to another user I’m having the following issue: "I am trying to import a Google Sheet containing ~500 rows of data into Airtable. Airtable successfully detects the data, including the column labels, but after I confirm and press the “Import” button, it always throws this error “says conflicting with another change.Refersh page” I’ve tried downloading the table into csv and reuploading and it does the same thing. The only way it works is to copy and paste data in but all the clicks for what i need to import is brutal on my wrists as I’m disabled. I need to be able to just import. The table is full of contact info for organizations so not really numbers or formulas or anything linked at all. . How can I fix this?

Hi, I have a question about the Lookup function. I have a base whose structure is like the following images. I have three tables containg different master data respectively and one “main” table. Now, I’d like to assign people to the “Assignees” column in the “main” table. The assignees are expected to be automatically selected from the “Assignees” table soon after a new record is created with the “Company” and “Category” columns being filled in in the “main” table. How can I do that? Thank you.

Is there a way to default all views created by Editors to be Personal Views? It’s possible that this is the default but I’m unable to test properly with only a couple logins. Thanks!

Good Day I am very new to Airtable and loving it. I am creating a data base from a csv file. Some of the information is missing, it’s a customer list with lots of personal information. I would like to email it to the customer and get them to check the information and update it or correct it. Please can you explain how I go about this? Many thanks

Hey everybody, i am looking for an app, that can show me availability of dates in a given timeframe and so far i couldn’t find anything, that seemed to fit my needs. This is the usecase: We store only records with dates and time as we’re managing a venue, that is booked for events. We’re getting asked about free dates in a specific timeframe. This is what i want to achieve: I would like to put in a range between two dates (lets say 01. October till 31. November) and a time, after which should be no records or if there are, i want to be shown those. Context: We have certain times, where events would regularly start (lets say 4pm) - if there is a booking before that time, that would be fine, if after, that would usually not work. I want to get an output that tells me, on which dates in this timeframe this filter fits. So basically it’s: Show me all days that don’t have a record starting after 4pm (we have such field, let’s just call it ‘EVENT START’) in a given timeframe. I’m sure th

Hi, I have a ‘Number’ field with a precision of 1.00. When i enter a value in the ‘Form’ view of this field, it’s rounding it automatically. 0.75 become 0.8 etc. Do you have any idea of how can i fix it please ?

How to maintain stock count daily by linking too many field ? Example , I have a tracking list that dial by my co workers . What they do is to fill in all the sale out daily , how can i link it to a database if its out of order by not filtering it

I’ve been updating several workspaces to the newer plan over the past few months. I updated one lingering workspace today, and was surprised to see the GUI of the app completely change. Screenshots attached. The annoying part was if I scrolled down, I couldn’t see all my bases in one screen, only each workspace. And “Recently opened bases” is gone. Plus when I open a base in my Mac app, a web browser window would open instead of the app. This is a downgrade. What’s going on here?