Solved

I’m sure it’s here or obvious, but I’m not sure what to search for. I simply want a formula that says: If Field A is not empty, then 1 else 2. Sorry if it’s obvious. Thanks.

Forgive my ignorance, but is there something in my browser settings that is causing this?

I use an algorithm for assigning a client ID which is the static “0660” followed by the 2-digit year the client started, followed by a 2 number sequential. I am using the following formula. How do I adjust this formula so that clients who start in 2021 restart the sequential numbering? ‘0660’& (Year)&-REPT( ‘0’, 5-LEN( {AutoNbr}&’’ ) )& {AutoNbr}

Hi there, Tried different ways, without luck as of yet. It’s lacking documentation and I also couldn’t find an example in any of the block examples. Thanks, Ronen

Hey there - 01/26/2020, and everything seems to have ground to a halt for me. Anyone else having the same issue?

Hello, Is there a way to query the API for recently updated records? Trying to understand the best way to scan for records that need to be updated in a separate database. Thanks!

Is there a limit for how many links you can have from a one to many relationship?

I have a formula that puts a checkmark in front of the Task name if the task is done. It works fine. IF({DONE}="",{Task Name},“ :white_check_mark: ”&{Task Name})&" "&DATETIME_FORMAT({DUE DATE},‘M-D’) I want to add another condition and can’t figure out the syntax. If the event is not done but is past the {Due Date}, I want a :no_entry: emoji in front of the Task Name. I am not sure how to incorporate that in front of the task name. Any help would be appreciated.

I’m trying to make a formular to that’ll use certain information if it’s after a particular time stamp. However no matter what I do I seem not not be able to figure out how get airtable to tell me if a certain date is after another. Sofar I’ve been trying variations of the following. Possible someone has an idea to what I need to do? IS_AFTER(DATETIME_PARSE(‘22/1/2020’, ‘DD/MM/YYYY’),{Date stamp})

Newbie here. I have two tables I am trying to link… table #1. which has basic plant info…name, details, photo. this is the master list of all the plants I’m interested in growing. table #2. these are all the plants that I have seeds for. I made the second table and was able to grab the plant name from table #1, but now I’d love to include a photo of this plant from from table #1. I tried making a new field on table #2 with the same name, and nothing happened. question: do I have to manually link all the photos for every plant on table number 2?

I´m creating a form that I want the custumer can see only his related records in the options. I was create a table for each customer, I am interesting to limit the form with that view but I can´t select other view, apart the principal (Grid view). Can you help to find the problem? I will be very greatfull

Hi, I am entering the following formuula but after pressing save the formual appears with the end missing WHAT I ENTER IF({1st Sow Date}=BLANK(),"",DATETIME_FORMAT(DATEADD({1st Sow Date},{Min Germ Days},‘Days’)),‘DD/MM/YYYY’) WHAT APPEARS AFTER I PRESS SAVE IF({1st Sow Date}=BLANK(),"",DATETIME_FORMAT(DATEADD({1st Sow Date},{Min Germ Days},‘Days’))) Thanks for your help

I’m a happy new user! I’ve built a simple table to record Name, location and type of an object and want to record various conditions across inspection dates. I see how to record the conditions I want and how to enter a date in fields but I want to have an ongoing set of records for each item. There will be around 50 items. How can I do this without making a table for each item? (In my mind it looks like a portion of the table will be 3 dimensional)

I can only request 15 new record creations with a single API call. // create a People-Holiday::Christmas record for each person in the People table people.map(person => { peopleHolidaysTable.createRecordAsync({ 'Person' : [{id: `${person.id}`}], 'Holiday' : [{id: 'reclZYRpInJiev0ce'}] }); }); I have 33 people in my array. I’m not terribly proficient with async programming in JS yet. What is the proper way to chunk this into 3 API calls of 15/15/3? I suspect I need to split it up into arrays of 15 and then have each call await the one previous with a timeout of 1000ms. Anyone able to provide some guidance on how to do that?

I have volunteer applications imported from 123formbuilder to airtable using Zapier. Some parts of the application have radial selections, where an application can choose a predetermined option, or they can choose “something else” and enter a custom value in a short text field that becomes available. When this data is sent to my base, there becomes two columns, one that populates with a primary selection and a second one that will either be blank or has the applicant’s custom response in it. I’m trying to organize this data into one column that either pulls from the first column if the second column is blank, or chooses the second column if it is not blank. What is the best way to accomplish this? I’m fairly certain I need an IF formula of some sort, but I don’t know enough to know if there is a better way. An example of this can be viewed here: https://airtable.com/shrje2Jcz0ww2BrP1 I can’t share the actual table due to all the personal information we collect but the sample tabl

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.