Other Questions

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?

I signed into a collaborator’s account today and noticed that my personal views can be seen. This is not normal, right? See photo below. I checked my account to see if I could see the collaborator’s personal views on my account and I cannot. Hope this issue can be resolved quickly. Airtable Support Personal views Personal views are a special view configuration type that allows collaborators with creator, editor, or commenter permissions to create views that can only be customized by the view's current owner...

Im trying to use a form to add names to a field and have the following fields setup with single select choices that will randomly be chosen when the record is created. im looking to make a NPC generator that fills in the choices for me after i put in a name

Guys, quick question, Is there any way to create a form with sections as you can do with Google Forms? I will give you an example, to make you understand better what I want to do, maybe there are other solutions as well. Title: Event application form First question: How many people would you like to register? Single choose: a. 1 person, b. 2 persons, c. 3 persons etc. If they choose to register 1 person, they will have the second question: “Please fill your full name” If they choose to register 2 or more people, they will have to complete: “Please fill the full name of each people” In conclusion, is there any chance to create 1 form, with multiple sections in order to avoid creating one form for each number of people from a group who can apply for a conference? And unfortunately, we cannot ask each one of them to apply due to some future questions.

I’m wondering how I should get values from fields based on record IDs? I have a table called customers with a record created by record_id() formula. How can I get the value of say an email address or billing address if I know the records ID in a different table? Or am I thinking about this wrong somehow?

Hello, I’m running out of idea to make my automation work. Here is what I’m trying to do : take the count of this ( synch from google drive ) put it in an other tab : please help me :slightly_smiling_face: