Solved

I have four fields: FirstName, LastName, Email, and Zip. I’m trying to set up a conditional where if the Zip is any of ~75 options from a given geographic region it will color all of them one color for quick identification. The base is connected to webforms through Zapier with several dozen new records added every day, so just need an automated way for team members to identify which new records are in their region without having to compare every entry to the list of zip codes in their region. Any help would be greatly appreciated!

Hi guys! Relatively new to Airtable. I’ve got what feels like an advanced question. I want to be able to send SMS messages to members of my database. I know there is a Twilio block in which to do this, which is great and very useful (I like the feature that pulls in Name and other fields that personalise the messages). However, I want this to be automated. I am currently building a base for general management of members data, including their upcoming appointment dates in a field entitled ‘Date of appointment’. What I want to happen, rather than doing it manually, is for an SMS such as ‘Hi {First Name, Last Name}, you have an appointment with {Name of doctor} on {Date of appointment}. Please call our offices if you’re running late on 07xxxxxxxxx.’ to be sent when {Date of appointment} is 24 hours away, for example. I’ve also had a look at Zapier to help with this but I’m not entirely sure how to do it. Can any body help/point me towards a tutorial or something that deals with this? I ho

I have fields named Tasks, Due Date, Task Completed and Status. Using a guide from another post I came up with: IF({Task Completed?}=1,“Done”, IF(IS_BEFORE({Due Date}, TODAY()), “Overdue”, “In Progress”)). This works fine. But, I would like to somehow have it so if the task field is Empty, it returns “No Task”. How would I add that to the above formula without confounding what is already going on? It’s like a third ELSE statement, or am I thinking completely backwards on this?

Hey all, I’m trying to create an estimating tool that pulls pricing details from one base and sums them together. I have 10 “item” fields and 10 “quantity” fields. The item field is linked. The goal is to select the item, enter a qty and then get one big total for all the prices as well as the individual totals for each item * qty. Problem 1: I now have 10 linked fields on the services base. I can just hide them, but I don’t understand this at all. Problem 2: Do I have to create 10 lookup fields to pull the pricing details into the estimate base and then have that be the data that’s used for the formula? Is there an easier way? Thanks!

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?