Solved

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

Hi I am a complete newbie. I was so pleased when I got by base looking and working exactly as I wanted. I started the base with a csv import from my website which shows the date as June 7 2020 as a single line text. I changed it to the friendly date 7 June 2020 and completely forgot about it. I carried on and created order renewal dates etc and was very pleased with the results. I then updated the table with another CSV from my website orders. It added the orders perfectly but has now knocked everything out of may date field and calendar completely. The problem, I am assuming is with the slight difference in the datetime format, I can’t undo the import and can’t change the date format to match. Please HELP!!! TIA Andy

Hi! I am building a CRM base (This is my first one!) One of the fields is “due date”. is it possible to mark a record that is overdue for 3 days? Daniel.

Hi all, I have tried for over 2 hours to get this to work, but can’t seem to. I am trying to update a barcode primary key field. but the closest I got was this error message: Type ‘string’ is not assignable to type ‘{ text: string; type?: string; }’.(2322)

Is there any way of moving completed records to a different table so that I can remove finished jobs but still be able to access them for invoicing reasons? A previous recommendation was to filter to exclude certain records but I can’t for the life of me see how to do this! TIA

HI, I have a crowdfunding campaign that just started. I need to track what’s happening with rewards—who gets one, did I send it, did I tell someone else to send it, what date sent. That part is easy to set up. The part that has me puzzled… The platform will allow me to download into an excel file each donation’s entire record, with 32 fields - many of them blank. Because I will be adding to the table every day, I don’t want to mess with that format, so I can easily cut and paste. So far I have called that table “Raw Data”. The primary column is “Time Pledged.” I’m unclear about how I get to having my rewards info in a useful way for me. Create another table and use a lookup to collect info about rewards from the Raw Data? Would I use “Time Pledged” as my primary column? Can I pull the info I want from the Raw Data using formulas? Or is it as simple as adding columns to Raw data for the info I want to track and build a view that lets me see only the data I need? Is that clear? Am I mi

Hi Everyone, There are infnite examples of being able to post updates to the table into slack, but I was wondering if there were any date-driven event notifiers that are possible. For example, if I had a field of important dates, is there any way to have some sort of scripting block/zapier/iftts integration that will push a notification on that date to slack without the need of a server accessing the record everyday. Thanks in advance!

Hello! I am having trouble creating a formula to calculate my service fee. Our fee is 10% of the order total (min fee $10, max $25.) We charge and extra $20 IF the order is for delivery. Please Help!!

Hi ! I supposed it might be a Google Drive support question too but I wished to give it a try here first. I followed this example : https://www.onlinedatabase.expert/post/creating-qr---bar-codes-in-airtable-with-integromat in order to create QR codes, store them to Google Drive and upgrade attachment fields in my Airtable database. Everything is working fine except in Airtable where the attachment are not visible. The png file is correctly generated and stored in Google Drive. Here’s a screenshot of what I get in Airtable: Surprisingly, the download is working fine in Airtable. So there’s a link. For information, with the Google Drive API, I use Web Content Link as the URL to the image. Because the key in use in the tutorial doesn’t appear on my integration. Thanks for any help !

Is it possible in Airtable to create some kind of company hierarchy such as: Company 1 (parent) Company A (child) Company B (child) Company C (child) Company 2 (parent) Company A (child) Company B (child) Company C (child) To try and help you understand what I have and what I want to achieve, I have simplified my base as follows: I have an Accounts table: I have a Projects table: I have a Tasks table: What would I need to do to find out (link) which projects/tasks Company 1 (parent company) are working on? As a start, in the Accounts table, I created a ‘Parent Company’ field that is linked to the Accounts table (I’m not sure if this is right or not) but I can’t figure out the next steps. Can anyone help?

In the Project Tracker template is a field Subtasks. with a list of items and checkboxes. I’d like to create a subtask field from scratch. Unfortunately, it’s not clear, at least not to me, how to do that? Tia

Hi, I have issues with a checkbox that doesn’t work proper with my IF AND formula. Or more correctly, when checkbox =“1” formula works fine, but when checkbox =“0” it doesn’t. As far as I can tell, an empty checkbox is supposed to be =“0”, right? Formula looks like this: IF(AND({Win}=‘Yes’, {EW}=“1”), (({Stake} / 2) * {Odds}) + (({Stake} / 2) * {EW Odds}), IF(AND({Win}=‘Yes’, {EW}=“0”), {Stake} * {Odds}, IF(AND({Win}=‘EP’, {EW}=“1”), {Stake} / 2 * {EW Odds}, {Stake} * 0))) Works like a charm as long as the checkbox is marked, but when it’s not the 2nd Row of the formula is not working and instead the ELSE thing at the end of Row 3 kicks in. I’m a total beginner at this so my apologies for novice language or stupid question. Many thanks! Best regards, Marcus Sjöberg

It would be great to be able to select the deliminator type for single and multiple select fields. For example if I’m pasting in a list of items that I want to be options and some contain commas it currently breaks those into separate listings. Whereas if I could set the deliminator type to only new lines or semicolons it would maintain the list items as I would like to use them.

Is it possible to get the last 2 digits of the creation date (year) e.g. 20 for 2020 19 for 2019. This is to use in a unique reference field (first 2 letters of name + “-” + last two letters of creation year + “-” + Auto ref number) I currently have: UPPER( LEFT(Created By,2)) & “-” & ( YEAR(CREATED_TIME()) & “-” & {Project Ref} Which gives me: E.g. AA-2020-101 Where do I insert the RIGHT(XX,2)? I’ve tried the following but with a returned #error!: UPPER( LEFT(Created By,2)) & “-” & RIGHT( ( YEAR(CREATED_TIME()),2) & “-” & {Project Ref}

Hello! I work in higher ed, and am trying to set up a highly automated CRM base. We’ve used Zapier for ages to create and update records in Google Sheets, and are shifting our process over to Airtable to allow more users access to the data. The primary challenge I’m encountering is in logging interactions. I have a Contacts table (with Email as the unique identifier), and an Interactions table (with things like General Web Form, Event Registration, etc.). So if a candidate fills out the General Web Form, I can have a unique Zap with the text ‘General Web Form’ dropping into the linked records --> Interactions field and it works like a charm. The challenge is at the second point of conversion: let’s say Event Registration. Zapier can locate the record, and then updated it – but If I use the same trick, the integration will overwrite the existing data in the linked records field, so I lose the General Web Form conversion. Ideally, those conversions would stack up in the same field (li

I have the following formula which returns the correct amounts, except when engineer report is selected. In this case it comes up blank. All the other selections produce the expected numbers. IF(Type=“Inspection”,“300”,IF(Type=“Estimate”,“30”,IF(Type=“Engineer Report”,50,IF(Type=“Photo Report”,“20”)))) Thanks

Hello, I would to get the position of the column for the integration in my block : today I can see the name and id of the field : is it a way to have his position in the table ? If yes, how can we get it ? Thank you :winking_face: Viken