Solved

I have data in a pipeline and I am using lookup to pull it into my base. They are connected by the Company name field which is linked. The problem is that we have multiple customers with the same name. (They are churches). Each record is unique but when the lookup runs it pulls in multiples. The example below shows Trinity UMC. This is one specific record but the lookup pulled data from every Trinity UMC we have. How can I get it to look at each instance of Trinity UMC as a unique record? Do I need to connect the two with a different field such as ID#? That would be unique on all 22000 records.

Hello, Is there any body facing the same issue as me? Since June all my tables automatically shows “all views” column as long as I open one and it’s annoying. Might have set up something by accident but didn’t know how to fix it.

Record history is good - but I need it to display the actual dates that events have occurred for each recond. My history column for an expanded record shows things like ‘3 mo’ to indicate that a record update or change was made about 3 months ago. I need the actual date. How can I see that?

I am new to Airtable and am sure I am missing something very basic here. I have a base with a table of clients. I am trying to work with and better understand how to sort my table, but am clearly missing something. I have reviewed the posts I’ve found related to this topic and have not yet resolved my issue. Following the API docs, I have modified my codes as follows. let table = base.getTable(‘Client Appointments’); let result = await table.selectRecordsAsync({ sorts: [ {field: “Client Name”, direction: “desc”}, ] }) All I am trying to do is simply sort my client table by the name column in des order, but the table never changes. If I update my code to include output.table(result.records), then the output displayed following script execution in shows the outputted table with the sort order as defined in my code. However, the actual table remains unchanged. What am I missing that is resulting in the table not sorting as expected? Any help would be greatly appreciated. Thank you! Bo

Hi, hopefully I can explain what I am looking for. I have several tables - “In the News”; “Events” and “Projects”. Each of those tables has detailed information (date, description, etc.) on each individual event / project / news item. I also have a field in each of those tables that links to a “Topics” table, so I can tag specific topics (e.g. coworking, consulting, affordable housing, etc.) that each news article, event or project could relate to. The problem that I am having is that I want to be able to see the detailed view of Events, sorted by topic. If I sort in the Events table by grouping topics, then events with multiple topics get put in their own separate category (ie if an Event is tagged “coworking” and “consulting” it will show up as its own category, rather than showing twice, once in the “coworking” category and once in the “consulting” category which is what I want). If I go to the topics table and group by topic, I have to click into each linked record to read about ev

I have only 2 numbers 15% 161.80 I have to get after the deal is done $161.80 and the the other guy have to get 15% of the deal. So the total deal will be $190.35 - (161.8 is a 15% decrease of 190.35.) How can I get to this number ($190.35) in Airtable, when I have only the 2 other numbers (1. 15% 2. 161.80) In Excel I will make this as follows =161.8 / (1-15%) but I can not make this work in Airtable Thanks in Advance

I have a base of events where I am tracking event updates. I am trying to write a conditional formula that will display up to 3 different possible date fields based on 11 outcomes using data from fields already existing in each record. I have tried nested IF formulas using IF( AND( as well as IF( OR( and have not been able to correctly solve the problem. I am either getting a formula that produces a date that is not 100% reflective of all criteria or an error message. I looked into SWITCH formulas but got lost… Fields within this base include: Field Type | Field Content Date Field | Original Event Date Single Select Field | Update to the event (cancel, postpone, reschedule) Date Field | Announcement of Update Date Field | Rescheduled event date Single Select Field | 2nd Update to the event (cancel, postpone, reschedule) Date Field | Announcement of 2nd Update Date Field | 2nd Rescheduled Date I want to display the appropriate date for each record based on the following criteria: Return

Hello–I have a simple question that I am struggling to solve. I am trying to calculate the difference between two dates but I need it to count full days. For example in the first record Start date of 1/2 and end date of 1/3 needs to equal 2 and not 1. The same with the 3 record–I need a formula that will calculate this to be 5 and not 4. Thanks in advance.

Hi all. i have some issues to connect airtable and google calendar wit Zapier. it seems that there is always an issue when zapier tries to get the datetime from airtable. Do you know which field i should use on airtable so Zapier recognises it properly? "im lost and a newbie :frowning: Big thanks for the support

I’ve been incredibly focused without achieving what a simple VLOOKUP in Excel allows me to do. What i am missing This seems rather simple a priori this table is created by a form, fairly simple Then another table from another form. I just want to have a Y/N in the column “exists on enrol table” I’m ready to use integromat if needed, i just need some guidance for this The only matching key is email and cannot be exposed in the 2nd form for privacy reasons

Hello, I am the Office Manager of an apartment building with 100+ suites. I have been moving the company into the 21st Century with Airtable and eliminating some paper that is being used. However, I have multiple bases and some items are becoming redundant. I am wondering if it is possible to have one base that not only shows tenant information (phone number, name, suite number, parking, storage locker etc.) but also the condition of each unit and the renos that are being completed. In other words, I want to see a “portrait” view (big picture of everything) of the suites as well as a snap shot (brief glance of what suites have new flooring, which need complete renos when vacant, when was paint done, new installations of sinks / taps / tubs / toilets). My one base contains the tables for tenants and the snap shot, and I have another base (Facilities Management) for the big picture with maintenance and facilities tables. The facilities manager is great, especially for recording move

It appears that the DATETIME_DIFF() function rounds down to a whole integer when specifying hours regardless of it decimal is specified to two places.

Hey guys, this is prolly a pretty dumb question but hopefully y’all can help me out with it. I have a Airtable I want to split the views on where something is in the process- I.E. I have Video’s---- They are out for Transcribing,So I want all the Videos that are out for Transcribing to be in a block vs a list. I have attached some photos. of how I want it t o look like.

Hi - I’m (somewhat) new to Airtable, I’m trying to figure out how the heck to get a Gantt chart view INTO the calendar view. It seems that this would be incredibly simple, and yet nothing allows me to move or enable that view in the calendar. The system just keeps asking me if I’d like to enable Gantt chart visualization - which I DID download, but it’s just sitting there in the dashboard on the side. Any advice as to how to make this work? Thank you.

I’m noticing that when using Lookup fields to gather all the text from various related text fields, the output in the lookup field separates each of the resulting contents with a comma automatically. Here’s the situation: 1 - Contacts table contains a link to Interactions table. 2 - Each Interaction contains text meeting notes, which are concatenated in a separate field with the date of the meeting and a line break at the end. 3 - The Contacts table in turn has a lookup field which brings back all of those concatenated results, so that I can pull up a contact in gallery view and see something like this in their notes field: 2-22-2015: Met for first time at her office, talked about our basic services. , 4-18-2017: Met with her whole team to set up launch. So that comma in front of the 4 isn’t a type-o in this message; rather it’s the output I’m getting. Can I get that to go away?

Hello - I am just getting set up with AirTable to manage my supply chain. One of our partners requires advanced notice of any in-bound shipments, to include multiple attachments. I’ve created a Shipment Log table to accomplish this, where I can just click “send record”, enter their email, and they receive all of the pertinent info. HOWEVER, the AirTable-generated email they receive has a “View in AirTable” link at the bottom. When anyone clicks this, it shows my entire base, which does include sensitive information such as pricing, other partners, internal comms, etc. How can I send individual records to external partners without giving the option to view anymore than the specific record sent?

Hi everyone! I am writing on behalf of my organization. We have qualified for the charity discount, but I am struggling with the best way to set up our team. I am aware that if we upgrade this would be for 1 workspace, correct? And then this workspace’s bases would be part of the paid plan. So im thinking that I would invite all my colleagues as collaborators (users) so that workspace. So my first question is: if I invite my colleagues to the workspace, do they see all the bases that I have created? Or only the bases that are shared with me? And vice versa? I am also wondering, if I am a ‘user’ on a paid account, can I then create another workspace that will have access to the paid base features? Or would that workspace not have the paid features because its a free workspace? Thanks in advance!

Hi, I am trying to build a SPA and having an issue with pagination. From client side, it is calling back-end function to fetch image url of records and pageSize is 16. What I am hoping to achieve is to fetch every 16 records whenever user clicks ‘show more photos’ and it will fetch another batch of 16 and so on… but my question is how can I call fetchNextPage() after it fetches the first batch of records and function’s finished. I have little knowledge of callback function and how it works but if you could help me with this, I’d appreciate it. Here is part of my cloud function exports = module.exports = functions.https.onRequest(async (req, res) => { const nextPage= (records, fetchNextPage)=>{ fetchNextPage() } const processRecords = (err) => { console.log('done :>> '); if (err) { console.error(err) return } } _base(tableName).select({ filterByFormula, fields, pageSize: 16 }).eachPage(processRecords, nextPage) });

I setup Integromat to watch an Airtable base for a new record and then send me an email notification. It scans the Airtable one per day and keeps on sending me notification daily for records that it already notified me about. Is there anyway to set Integromat to ignore records that it already notified me about?

Hi, I need to provide my management with quarterly and yearly roadmaps with months in column and projects in rows I usually do it in powerpoint but need and automated generation. Can Airtable do that ? Thanks in advance !

I’m just getting started creating linked Tables and tried using the Sales CRM example on the support page, but am unable to create a similar Table of linked fields. Here are two problems: The rows of names in the Primary field column are duplicated in the second column even as its header is correct. Instead of all of the corresponding rows from the linked Table grouped by the names in the Primary field, only a single row of linked cells is displayed.

hello Airtable Community, First sorry for bad English, hope you can understand me. For my hotel I need to create an automation between Airtable (our CRM) and Google Agenda, where every record (room booking, with important informations about customers) create an event in our Google Agenda. I have already created an automation with Zapier which create an event in Google Agenda every time I create a new record in my CRM. But, when I change a field (exemple : after create the record, I have to change the phone number of a customer in a field), it do not change the phone number in my event on Google Agenda. It’s a trouble for me because if me or a coworker insert a wrong phone number in a new record, the correction do not put the correction on google events, which is our main booking interface. Thanks for reading and helping me.

Hello, I am trying to create a formula to track of the aging of a record. I am using date fields for this formula, the Booked date and the Funded date. I was able to come up with a formula that calculated the age, but it only calculated the age once the funded date was updated. I need to be able to keep track of the ongoing aging of each record from the date it was booked all the way to the date the record is funded. I also need the formula to stop keeping track of the aging once its been funded. for example, if a record was booked on June 1st and today is June 17th,and the record has not been funded I need to see that the record is 17 days old. However if the record was booked on June 1st and funded on June 16th, then even though today is the 17th, the formula should still show that the record is 16 days old.

I’m building a block which (should) allow users to select multiple records in Table A. I would like to get a set of each selected record’s linked Table B records. The problem I’m running in to I believe relates to using a hook within a loop. Right now I’m using selectedRecords.map(record => {...} ).flat() to loop through each selected record. Within the loop, I’m using useRecords(record.selectLinkedRecordsFromCell(fieldName)) to get the linked records into a single array. This works but only if the user selects the same number of records each time, or cancels the current selection and starts over. Meaning if someone selects one record it works, if someone selects all records it works, but if someone changes the number of selected records by clicking and dragging or by using the selection boxes at the far left, React throws an error: Error: Rendered more/fewer hooks than during the previous render. I think I could possible get around this if I could combine/collapse multiple record q

Hi! Can someone tell me why my formula is not working? IF({Rating}=1, ” :star: ”, IF({Rating}=2, ” :star: :star: ”, IF({Rating}=3, ” :star: :star: :star: ”, IF({Rating}=4, ” :star: :star: :star: :star: ”, IF({Rating}=5, ” :star: :star: :star: :star: :star: ”, ))))) Basically, I want to convert a lookup value of integers into an emoji. Many thanks.