Solved

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.

Hello community, Hope that you may help me with this one. I am trying to build a system that will help my with inventory tracking. So far so good, and there are many great templates and tutorials out there. HOWEVER, I haven’t figure out yet how to solve my issue: From time to time, employees take equipment from our warehouse for a specific project, and I want to keep track of everything. I thought about making a table for each time someone takes something, and then finding a way to reduce the amount of available items from the amount of items that went out from our warehouse. but - I have no idea how to do that. Making a row for each project is not ideal as well, because each project uses several items with different quantitates. Any suggestions or tips? THANK YOU!!!

Hey all, I have two tables that I need to link. Table 1 is a table which gets daily new info. In one column, I have to concatenate. This changes daily with the new information and therefore needs to stay as a formula. In Table 2, I have a sort of database of possible concatenation options with responding values. These two values need to be selected according to the newly created cell in Table 1. In Excel, this could be quickly done via a Vlookup, but I struggle to do this in Airtable. Has anyone had a similar problem and can offer a solution? If you need more info, please tell me. Thank you

What would be the correct way to have the duration / age of a ticket in Airtable being any status that isn’t “Complete”? In the “Days Open” field I currently have got to this formula : IF(LAST_MODIFIED_TIME(Status), WORKDAY_DIFF( TODAY(), LAST_MODIFIED_TIME({Status}) ) ) What’s the best way to stop it counting once the ticket is completed?

When I delete the actual lookup field AFAIK the linked field by itself is doing what I need. My question is why am I generating this lookup field to begin with and can you delete/not generate it into the table to begin with?

Hello, I have a question regard to billing. Is it possible to set the owner in PRO account while other billing collaborators under PLUS account? Sincerely, Michael

I have 6 air table bases that are duplicated. I added a section to the base the 1st base with several new rows. Now I’d like to copy and paste the rows into the other 5 bases for our company classes. Can you tell me how to do this or point me towards a tutorial? thank you in advance