Other Questions

I’ve embedded a number of tables as scripts in a webpage. They all run at once and slow down the rendering. Is there a way to force them to run only when they come into view? Thanks.

Hey everyone! I’m trying to pull the data from each of these columns into another table. I need them to be transferred as they are currently sorted and separated by a comma. Example: Week 1 should be first 24, 67, 45, 68, 599, 3358, etc. etc. Any idea how to do this?

Hi - I would like to use Kanban view but don’t want duplicate records to pop up until they are sorted. For example let’s use a persons name. Derek Jeter. I want to have 10 Derek Jeters. Once the first Derek Jeter is assigned to a team ( say the Yankees) a second record will appear that can be eligible to be placed on another team Kanban. Understand?

Hi again! im trying to add opening and closing times to each record - so they sync with softr… i figured the best way is to create a field for each day of the week and have a drop menu for every hour and assign to each record. However this info doesnt migrate over to softr very well. Is there a different way the information could be organized so it looks like this when its in softr: Thanks!

I know I can use count to count the number of links that occur, but does anyone have a solution for counting the number of times the main column occurs in a link. So for this example here I’d like to have a column that tells be how many times a “Name” is used in the “Linked Skills” so it would be 0,1,1,0,3 for the cases shown here.

I have a long text field with rich text formatting. I have filled in hundreds of entries in this field that will be pulled from Airtable to populate a webpage. I was asked if I could go back and make the text bold going forward. Therefore, I have two questions: Can I somehow go back and format all the text as bold in AT similar to how it could be done in Excel/Sheets? I have tried the following: creating an automation and filling the field with the current contents surrounded by two asterisks, exporting the data as a CSV file and formatting the text as bold and reimporting. Going forward, will there be functionality where I can edit the field type where by default, all entries will be bolded? The only thing I can think of now would be a script, which I am not equipped to do. Thank you in advance for any advice! Gavin

Is it possible to limit a Lookup field to the latest entry? I have a Notes table with a date field which is related to the Companies table. I want to show the date of the last note record related to that company. That way I know when I last spoke to that company and filter the table accordingly. Any thoughts?

Hello, I’d like to know if it’s possible, in one table, to combine both records added manually and records added/updated using synchonization with other tables ? Thanks in advance for your help, Regards. Nicolas Caplat

I have the following structure: Base 1 - Table 1 Base 2 - Table 2 Base 3 - Table 3 In Table 1 I want to add a field that pulls information automatically from Base 2 - Table 2 and from Base 3 - Table 3. This should be a single select field. Let’s say that I have 10 records in Table 2 and 10 records in Table 3. In Table 1, I want to be able to select a single value from the 20 records pulled from the other 2 tables. And these values (in the field of Table 1) should be updated automatically if I add or remove records from Table 2 and Table 3. Is that something that can be done with Airtable? P.S. I’m pretty new to Airtable

Hi, im trying to build a website with the help of Airbase (using softr.io). I have a list of companies in my table. How would i format the data so that: i can display opening days i can display specific events that business have on… for example - a business may offer a drinks promotion on mondays, wednesday and sundays. They may also offer a DIFFERENT drinks promotion on tuesday and thursday. How do i collate the data so that when i use these values within the website it filters the information for the users? Sorry if this is poorly explained - im not very tech savvy! Thanks!

Hi I have two tables Products (name, creation start date, creation end date) Resource(name, availability start date, availability end date) For each product creation there are different resources required and the resource availability may or may not match the attached product delivery time line. Based on different products and attached resources, need to identify which is the best bet and proceed with that product delivery planning. The diagram looks like some thing and based on view output one can easily understand that Product A is better option to proceed though Resource 5 is not fully aligned. I tried to get this but facing some issues. Please let me know how this can be achieved in timeline view. Thanks Henry

Hi good day. I’m trying to create a graph to show students’ progress for each subject over the year. But i am not sure how to format the data to be able to automatically generate a report for each child’s graph.

Hi, I am using a webhook triggered script to copy incoming data into 2 tables. None of the updated columns are links. let uwTable = base.getTable("ATDS data"); let crTable = base.getTable("Combined repository 2") let inputData = input.config() console.log(inputData) let validateRecord = async (newApplicationNumber) => { if(!newApplicationNumber || newApplicationNumber === "") { return true } else { let exisitingCases = await uwTable.selectRecordsAsync({fields:["Application No."]}); let existingApplicationNumbers = exisitingCases.records.map(r => r.getCellValueAsString("Application No.")); console.log(exisitingCases.records.map(r => r.getCellValueAsString("Application No."))); console.log(newApplicationNumber) return existingApplicationNumbers.includes(newApplicationNumber) ? false : true; } } let isValid = await validateRecord(inputData.application_number); //adding case to Combined repository 2 w/o validation await crTable.createRecordAsync({

hi is anyone here using Resource Planning - Airtable Universe this one as a base? I am playing around with it. how is Planning (Globals) tab used? I am trying to see how much are certain resources available in given week - how do I do that? How can i assign resource to a project but for a partly duration? i.e. if the project is 1 months but one resource only needs to be assigned for 2 weeks? *Is there a less manual way to add individual allocations for the same project (in the allocation tab) rather than duplicating the row and changing the personnel one by one? Thank you for your help!

Hi everyone, i am trying to build a performance dashboard. I would like to count how many times the workers postpone their work’s deadline. Is it possible to do ? Can you g’ve me a hint? Thanks.

Hi, probably it’s a stupid question, but can we run the script in a different language such as Python, HTML, R, etc? I was thinking like in python, we can import a library to write codes in java language, can we do the same here? I’m new to Javascript. Thank you!

Hi Airtable Community! I wanted to know what the latest update is for images added to the Attachment field. A while ago there were big discussions about the change that Airtable has wanted to make. It was supposed to come into effect this month (November).

Hi, I’m trying to create an interface that shows only the status “To send” and not other status. As you can see in “Status 2( from Report)” there is also the status “Done”, I would like to filter the data. I tried to filter the interface in this way: But it didn’t solve my problem. This is my dataset: is someone know why “Done” is still there? and how can I solve this issue? Thank you very much!

Hello, I’m trying to find out if and how I can continue a free version of Airtable as I’m currently using only a small fraction of the app. Just this morning I got an email saying that the “free trial” is ending tomorrow. I was under the impression I was using a “Free” or “light” version. It would be helpful to find out if the limited number of features I’m using allows me to keep doing a free trial. Or… what membership tier I would qualify for. Please help as this puts me in an awkward position today with a deadline and my data in jeopardy. Thank you.

My company’s base experienced a SNAFU, and the fields in several hundred records were confused with each other. Our solution was to restore a version of the base from a point in time before the issues occurred. However, before everyone was notified to switch over to the restored base, many tens of updates were made in the corrupted base. These updates now need to be transferred to the new base. Since doing this manually would be tedious and time-consuming, I am wishing for a way to do this from a spreadsheet (using a script?). Please tell me if I am making sense and if there is a way to do this. Thanks in advance!

Hello. I am having some trouble updating a field in my record with a linked field from another table. Here is what I have so far: Lets say the creative record exist its just not linked if (creativeRecord) { return creativeRecord.id; } I put the return of this function above ^ in the variable creativeRecordID that I use below. The value of creativeRecordID is a string “RecordQueryResult.1234” table.updateRecordAsync(record, { Creative: [{ id: creativeRecordID }], }); This is returning the error: Can’t set cell values: invalid cell value for field ‘Creative’. Cell value has invalid format: .0.0.id must be an objectId. Any suggestions / solutions appreciated, Thanks!

I am relatively new to Airtable and have a specific Search/Filter issue that my colleagues and I have been attempting to solve for a while now. We are a small travel company that provides tours to our clients. Each tour has a unique route that it travels (with stops along that route). The tour itself can run on multiple days following the same route. I have set up our tables in a similar fashion to this screenshot: We need to be able to create a Search that will return which Trip Name is in a City on a specific date or range of dates. For example: we search Djibouti from 10/11/22 - 13/11/22, it would return BC, BB, BD, after which we could view individual records that BC, BB or BD are within. Is this within the realms of possibility with Airtable?

I am looking for a way to log all the emails I send to my contacts automatically to my Interactions table. I thought I could accomplish that by using the Zapier integration with Email Parser. I set the contacts involved field to equal the recipient and bcced the parser email. However the zap is pulling in the bcc field instead of the to field. I am using outlook email client. Any ideas how to fix this or is there perhaps another way to accomplish the same task?

Hi, I’m trying to think of the best way to replicate our billing schedule payment profiles where we have % of an annual fee to invoice each month. The below show how we capture this in excel: At this stage, I’m just looking for ideas on how to structure this. However, ultimately it would be nice to link opportunities to a payment profile and have each payment date shown in a calendar view. Thanks!

First ever question for the community! I have a table with a single select column that contains the names of different documents and articles used while conducting secondary research. I would like to create a new table that adds each unique document to a single row. Suggestions?