Solved

I have searched both Google and the Forums here for the past 20 minutes and cannot find any reference to this at all, so my apologies if this has already been covered somewhere else. So, really simple, I hope, I have a need to store the date of birth of clients and, having chosen the date field for this, it appears that I can only scroll backwards month by month. If, as is the case today, one of my clients is 72 years old, this is going to take a VERY long time. I am sure that I am missing something altogether obvious, however, I am indeed missing it! How can I “zoom-out” in the date picker to change the year first, thus reducing the amount of time it would take to perform this simple task? Thank you in advance of your help :slightly_smiling_face:

I have two tables. Table 1: Client Table 2: Appointments Each appointment is tied to a client. I’m looking to see how many days from the client’s last appointment. E.g. the client’s has 3 appointments however his last appointment was 1/1/2020 then the cell would display ‘14’ since that was 14 days ago. Any ideas?

I have a field with the project name. and I want to use that name in a URL to individualize the path. So column 1 is field type NAME. with the contents Row 1 is fred Row 2 is barney Column 2 today is field type URL Row 1 http://basepath/fred/commonpath Row 2 http://basepath/barney/commonpath What I want is Column 2 to have field type URL and effectively auto look up the NAME Row 1 http://basepath/{NAME}/commonpath (look up NAME for row1) Row 2 http://basepath/{NAME}/commonpath (Lookup NAME for row 2) That way I can just copy the formula but all the URL links, in reality there a mutliple URL references and NAMEs so it would be very helpful

Hey Guys, How can I access Airtable’s pagination by including a given offset in either the url or query? My attempt below at including in the url has failed with the error “KeyError: ‘offset’”. I’ve been able to access the 1st offset per the function at_page(). For simplicity’s sake, I took the result from the function and hardcoded it to the variable offset_01. Thank you! import requests import pandas as pd offset_01 = 'itrCG3VDp2c34x1j1/recKTJGYMICe13iA8' url = 'https://api.airtable.com/v0/PRIVATETABLEKEY/accounts' + \ '&offset=' + offset_01 headers = {'Authorization': 'Bearer PRIVATEAPIKEY'} # Calling API response = requests.get( url, headers=headers, ) json_response = response.json() # Finding AT page offset def at_page(at_json): df_initial = pd.DataFrame(at_json) at_offset = df_initial['offset'][0] return at_offset offset = at_page(json_response) PS also have an open stackoverflow: stackoverflow.com Accessing Airtable'

I downloaded the airtable mac app but when I try to open it, I get this error message: “Airtable.app” can’t be opened because Apple cannot check it for malicious software. This software needs to be updated. Contact the developer for more information. I’m running macOS Catalina 10.15.2. Is there a fix for this?

I have two linked tables A & B A contains different projects B is where staff is logging different tasks linked to different project at different dates. I’m trying to roll up a the latest logged task for each project back in A. I tried rolling up MAX(values) but it only works on dates, so will not show the latest task field back in A. Is there any way to rollup a field based of the latest date?

I have two date fields and would like to pull out the months and years in separate fields from one or the other. I managed to get the single IF working but not the nested function. Here’s my formula: IF({Date A}, DATETIME_FORMAT({Date A},’YYYY’), IF({Date B}, DATETIME_FORMAT({Date B},’YYYY’))) which I based on: IF([logical argument1], [value1], IF([logical argument2], [value2], [value3])) Any help would be appreciated.

EDIT: It’s not letting me upload pictures, anyone know why? I have 2 tables. 1 called Members and 1 called Appointments. Here’s the members table: Each member has a Name, Membership Type, Shared with (linked to existing table), and another column linked to ‘appointments’ table. Here’s the Appointments table: You’ll notice a the field “Total Appointments per Active Member” Anyone that has membership type ‘shared’ means that I don’t count them as an actual member. I want to link them to the original member. And since I want to track each appointment by the main member, I’d like to figure out how to add the members ‘shared’ total with the existing membership. E.g. John Smith has a total of 3 appointments (his 2 booked, and 1 from his shared member Jenny). How would I do this?

Hi There, I am trying to create an Information Architecture document for an extremely large website. There are around 2000 pages. I have created a view where using the Visual (org chart) block I can display the entire chart. I would like to create a view where I can view all children pages under a parent page, including grandchildren pages in an orgchart/visual manner. Can you let me know if there’s a way I can create a view where I can see everything under a particular parent page? Thanks

Hi there! I’m working in two tables: Contacts and Interactions. The latter keeps records of all emails to and from Contacts (linked), including time/date and a single select field to indicate whether the email was inbound or outbound. I also have simple formula fields – IF(Type=‘To Contact’, Date, ‘0’) and IF(Type=‘From Contact’, Date, ‘0’) – because I’m trying to create respective rollup fields in the Contacts table to show the date of the most recent inbound email and the most recent outbound email. I can’t get my rollup to display any dates. MAX(values) displays zeros. Using ARRAYJOIN and then using DATETIME_PARSE(MAX({arrayjoinfield})) displays 1/1/1970. Is there anything I can add to the Interactions formulas so that the dates are read as values? Or is there a different function you can recommend for the rollups? I’m really scratching my head here.

Hello, I am brand new to Airtable and need help creating a formula. The formula works perfectly in Excel/Numbers, but my knowledge of formulas is proven to be insufficient and I can’t figure out how to do it in Airtable. Maybe it doesn’t have the capabilities to do what I want? Here’s the formula I use in Excel/Numbers and the ‘field names’ should transfer over because I’ve created fields in Airtable for each. See values below: “PPW” is a number field “kW” is a number field “25yr” is a checkbox field with a value of 23.5% “20yr” is a checkbox field with a value of 22.5% FORMULA: PPW * kW * 25yr * kW * 1000, PPW * kW * 20yr * kW * 1000 The 20yr and 25yr are checkboxes, and each deal will change depending on what the client chooses. So I want to be able to type in the PPW > kW amount > select a checkbox and have it automatically calculate the amount. Or put another way, I need to know how I can get a formula to calculate a percentage of the total (PPW * kW * 1000). Real world numbe

My JS needs some help :frowning: I’m trying to create a new record in one table for each of the records I pulled out of a view in another table. I’ve tried using people.map(person => {}), people.forEach(person => {}), and for (const person of people) {}, but I get the same error in all 3 cases: Error: <root> must be an array at Mutations._assertMutationIsValid (https://localhost:9000/__runFrame/bundle.js:4139:53) at _callee$ (https://localhost:9000/__runFrame/bundle.js:3852:21) at tryCatch (https://localhost:9000/__runFrame/bundle.js:75258:40) at Generator.invoke [as _invoke] (https://localhost:9000/__runFrame/bundle.js:75484:22) at Generator.prototype.<computed> [as next] (https://localhost:9000/__runFrame/bundle.js:75310:21) at tryCatch (https://localhost:9000/__runFrame/bundle.js:75258:40) at invoke (https://localhost:9000/__runFrame/bundle.js:75348:20) at https://localhost:9000/__runFrame/bundle.js:75383:11 at new Promise (&lt

Hi All, Trying to fix a goof in our Airtable. Backstory: We programmed a certain formula to add in the year a record was created into the record name(i.e. 2019 =19). We pre made some of these records in December, and now need to duplicate the records and have all the duplicated records keep the same name. I hope you all have realized the problem with this… If you haven’t all new records now automatically signify it’s 2020 and no longer 2019. My Idea is to add in a check box to the records we want to fix to say "If box = 1 then replace “DATETIME_FORMAT(CREATED_TIME(), ‘YY’)” With “19.” Here is the Original Formula: IF({Class} = “STR”, “ROS” & “" & {Instructor} & "” & {Class} & “" & {Strength ID} & "” & DATETIME_FORMAT(CREATED_TIME(), ‘YY’) & “" & {Playlist}) & IF(NOT({Class} = “STR”), "ROS” & {Instructor} & “" & {Class} & "” & DATETIME_FORMAT(CREATED_TIME(), ‘YY’) & “_”& {Playlist}) This would spit out something lik

My family business makes baskets. Each basket is numbered and with that number we track multiple things such as date it was made, type of wood used, basket size/style, and inlay style. I created a form to make it easy to enter all that info and numerous other tracking features, however, the one thing I can’t seem to figure out (and maybe its not possible?) is how to get a list of say the 10 most popular baskets for a year… we have about 25 different basket styles, 10 different wood species, and 5 different inlays… I can easily see what was the most popular basket style or wood species but I would like to have a list of each individual style… (not sure if I am making sense?) As an example: we make a napkin basket and a condiment basket and we use both cherry and walnut wood species. So let’s say we made 10 cherry napkin baskets, 2 walnut napkin baskets, 7 cherry condiment baskets, and 3 walnut condiment baskets. I would like my list to first list cherry napkin baskets with the amount ma

Hi! I have a Long text field that has 1-52 lines. Each line starts with either [ ] or [ x ] and is then followed by 10 digits (at present). How would I “magically” disapear all lines starting with [ x ] using a formula? Is there a way to "disapear " a whole line from [ x ] to \n without knowing the amount of caracters inbetween? That would be ideal if possible. I need to “disapear” lines from top to bottom (first line 1, then line 2, then line 3 and so on…) and not at random through the entire field if that makes any difference. I have tried various “solutions”, but haven’t found what I need. I’m probably nesting/combining it incorrectly and by now I’ve stared myself blind at the problem trying to get it right. I would greatly appreciate any and all help I could get.

Hi all. I have a filterbyformula where I am using an OR statement to get Record_IDs. It seems that on IE I have maxed out there rule of no more then 2000 characters in a Get URL. This seems to be happening to me. I am using the javascript and not curl. Any thoughts on how to get around this? If I call 50 people from the database using the OR statement I am screwed with each person needing roughly 40 characters… Thanks Jon

Hey all, I’m tracking scores of sports events. The main fields are “Home Score” (for how much the home team scored) and “Away Score” (you guessed it…) In soccer matches it’s common for a team to score nothing. i.e. “0”. I’m calculating: IF(AND({Home Score}, {Away Score}), IF({Home Score} = {Away Score}, “Draw”, IF({Home Score} > {Away Score}, {Home Team}, {Away Team}))) The issue is, if I input “0” Airtable ignores it. it’s a blank for calculating consideration. So, field {winning team} remains empty. The workaround is to input a “1” score in case of actual “0” and to give the other team a +1 on their actual score. i.e. if a game’s score is actually 0:1 I’d input it as 1:2 . Is there a way around it? I want to preserve the information integrity. Thanks.

Hey Guys, I’ve had this issue before, and was able to solve it. For some reason, it doesn’t work now. We’re betting on score difference, so: IF({Home Score}>{Away Score},{Home Score}-{Away Score},{Away Score}-{Home Score}) If the game hasn’t played yet, the {Home Score} & {Away Score} are empty, which results in ‘0’ So, I’ve tried checking if the records are empty or not. IF(AND({Home Score},{Away Score}), IF({Home Score}>{Away Score},{Home Score}-{Away Score},{Away Score}-{Home Score}) But I keep getting an error, that my syntax is wrong. After the above I’m running this: IF({Points Difference Bet}={Actual Points Difference},“Bingo!”,IF({Actual Points Difference}-{Points Difference Bet}<=5,“Very Close”, “Way Off”)) But the points difference can actually be higher than 5, but I’d still get “Very Close” Please help. Thank you.

Hi, I am looking for a formula to remove text between parentheses. For exemple, I would like to have : Le nord (Chili) > Le nord Le nord (Soudan) > Le nord Le sud (Soudan) > Le sud Thanks in advance for your help :slightly_smiling_face: !

I’m trying to write a formula that would find multiple parts of text (from a single cell) into a short formatted text (in a cell). Example: From “Nothing, we are a turn-key service, from site prep, permits, to completion” to “turn-key” From “The client has some responsibility like permits, site-prep, and transportation” to “door-step” From “We just send the kit of parts and the client takes care of the majority of work” to “kit-of-parts” From “We offer just the drawings / floor plan in addition or exclusively as a service” to “floorplan-only” I was able to get it to pull just one text but not multiple.

Hi, I have a table that connects pairwise my data in a kind of graph structure. Is it possible to implement a (recursive or not) depth-first search algorithm that will filter the connected records only for a given cell value?

I need to record weight data for observations that have different levels of precision because they span a wide range and must be measured on different scales. Is there a way to allow for differing levels of decimal precision across entries in a single “Numbers” field? For instance, to enter 4 sample measurements of: 3, 3.0, 3.02, and 3.020, Airtable makes me select a single level of decimal precision for all of the entries, so it ends up showing as something like: 3.000, 3.000, 3.020, 3.020 or 3, 3, 3, 3 or etc etc… You get the idea. In any case, the resulting entries do not accurately reflect the actual data. As far as I can tell, if I want to use this field for formula-based calculations, I must designate it a ‘numbers field’ and therefore must choose a single level of decimal precision for all of the entries. Is there a way to get around this without misrepresenting my data precision and without creating separate weight fields for each level of decimal precision? Thanks for the adv

Hey, I’m trying to calculate points difference. So, if the points difference <= 5 then I’ll give the player 2 ranking points. if the difference is great than that, he doesn’t get any points. I’ve noticed that Airtable doesn’t treat 5 and -5 the same. So, I’ve made two fields. Here’s my formula: IF(AND({Team Bet}=“Win”), IF(AND({Home Score},{Away Score}), IF({Points Difference Bet}={Actual Points Difference},“3”,IF(OR({Actual Diff - Diff Bet}<=5,{Diff bet - Actual Diff}<=5,“2”,“0”))))) But, I get nothing. Can anyone spot my mistake? Please help.

Can I share a calendar as read only which I create as a pro user sharing with a free user or / and someone who has not even signed up to airtable without paying for an additional user.

Does ‘create a shareable grid view link’ count as another user?