Skip to main content

Solved

7383 Topics
B
Brilliant_AdminParticipating Frequently
asked in Other Questions
Display a single value in a lookup or formula field from another table

I have a table where we have products defined something like: Product name | Client | Other product info In another table, we have the columns: Products selected | Client You select multiple products for Products selected and the Client column is a lookup. However, the same client shows up multiple times in the Client field if more than one of their products is selected. Is there a way to show any given client a single time in the Client field? I had hoped that using a new field, Client unique with the ARRAYUNIQUE function would do it. But ARRAYUNIQUE only seems to work on numeric arrays. Any idea how to accomplish this? Thanks.

204
B
J
James_OteyNew Participant
asked in Other Questions
Using FIND() on an ARRAYJOIN() returning inexpected results

I have 2 tables: Table 1 is a list of every country in the world Table 2 is every possible 3 letter combination of the English alphabet (all 3 character strings) My goal is to see how many countries contain each 3-letter string. I linked each of the 3-letter strings to every country, then performed an ARRAYJOIN(): UPPER(ARRAYJOIN(Countries)) Then I used FIND() to find all occurances of the Permutation in the Array: FIND(Permutation,{Country Array}) The FIND field is returning way more results than expected. For example, for the Permutation “ABO” is returning 722 results. It should be returning 1 results for GABON Can Airtable do this? https://airtable.com/shrElPYYr5XW1Y0i2

112
J
N
nathaniel_pulsiKnown Participant
asked in Other Questions
Find last entry

Hi- I am moving an application from Fieldbook to Airtable, FB has lovely formulas that allow the user to look thru a link to a table and perform any formula on that table, similar to rollups but with more functionality. Recreating my systems in airtable, i am stuck on one i can’t work out. i have a table of entries called 'table2 and want to find ‘price’ in the last entry. In fieldbook it’s simple: last(table2.price) I am not finding any equivalent in Airtable. there are various other data points in the row on table2, including a sequential integer field called ‘ownership Number’ where the ‘last’ would also be the ‘max’ however i am unable to get a formula to work in a rollup that says 'lookup ‘price’ on ‘table 2’ for the row with the max ‘ownership number’ Any suggestions?

1059
C
X
XingKnown Participant
asked in Other Questions
Formula on 2 linked tables

Hi, dear pros, can I ask, anyway that I can realize this: table A: tasks table B: doctors if a linked filed from table B writes on table A: for instance: Dr. Brown, i want to have another field on table A can show something like “Health” not sure how to write formula on something linked to another table

43
Justin_Barrett
M
Max_SchrammNew Participant
asked in Other Questions
Batch Update Block - Images are greyed out

The batch update block does not seem to allow selection of image fields for update. I plan to import 2000 records into a table. THEN I need to import 2000 images whose names match via the record ID as primary photos. THEN I need to import 2000 more images whose names match via the record ID as secondary photos. etc Cannot see where this may be possible in AirTable

143
B
J
J_J_MoncusNew Participant
asked in Formulas
How to count collaborators?

Question: I have a collaborator field with numerous collaborators per record, and I was hoping to add a field that would add up how many collaborators there are listed in that record. How would I do this? Thank you!

284
A
M
MICHAEL_RINALDINew Participant
asked in Other Questions
Sql type queries features

I’m absolutely brand new to this platform. I have a largish Excel spreadsheet of donations by donor versus time. Does your software allow queries (similar SQL) of these data? Thanks, Mike

1327
V
C
Clifton_EatonNew Participant
asked in Other Questions
Is it possible to hide fields in a view on the mobile app?

Is it possible to hide fields in a view on the mobile app? I’ve searched the forums and couldn’t find anything. I’ve also dug through help files and nothing mentioning that you can’t do it. Am I just being dense, or is this not something you can do on the mobile version of the app? Thanks!

217
M
R
Ryan_Lee2New Participant
asked in Formulas
Daily recurring reminder emails formatting

Hello, I would like to send daily recurring reminder emails to my team members. I would like the email to be formatted to include the task due and also include specific fields that I have created including multiple select fields and due date. For example, within a table, “tasks”, I have a view which is filtered to include a single team members tasks grouped by due date and a multiple select field identifying the “importance” of a task, either “low, moderate, and high”. I have a formula column which prints the text “send reminder” if the due date field is today’s date: “IF({Due Date}=TODAY(), “send reminder”, “”)” I have set up a Zapier trigger using the “scheduler” zap, which is scheduled to trigger every morning at 5am. Next, I set up a Airtable action, “find record”, to search for the value of “send reminder” in the table. I then set up an action for gmail to send an email to the team member. I want to format the contents of the e-mail to contain: The name of the tasks due today, alo

347
S
K
Kartik11Participating Frequently
asked in Other Questions
How to add if else condition in forms?

Hello, I am trying forms in Airtable… I want my user to select number of his brothers from a dropdown list of 5 numbers: 0, 1, 2, 3, 4. If he/she chooses 4, then display 4 groups of 7 text inputs like name, last name, occupation, dob, email, business, mobile number. same for 0,1,2,3. if 0, then jump to next dropdown of sisters and do same process & next children. How should I do this? Thanks for any help in advance :slightly_smiling_face: Kartik

183
Justin_Barrett
L
Lisa_GervaisInspiring
asked in Formulas
Calculate the years worked based on career start date

I’m looking to estimate a person’s retirement date based on their career start date, this would be using the assumption that they would work 35 years following their first job.

125
L
R
Richard_CasemorNew Participant
asked in Development & APIs
Clearing a Collaborators Cell using PATCH

I’m looking at removing all collaborators from a cell. I have attempted to send different variations of data and always receive 422. I’ve tried to: Update the field with an empty string: ‘’ Update the field with an empty json: {} Update the field with an empty record: {‘id’ : ‘’ } I can always update it correctly with {‘id’ : ‘usrXXXXXXXXXX’} I know I can send a valid request but I can’t send a valid request to clear the cell. The cell is clearable in Airtable on the web interface, so I believe it can be done but the API documentation doesn’t say how to clear a cell with PATCH. Using PUT seems drastic to update a single cell by sending all the other data except that cells data. For reference, most field types are an empty string apart from the checkbox which is the string “false”.

101
R
S
SunLynxKnown Participant
asked in Formulas
If/Switch Function Help

I am trying to write a function that allows me to add a set of numbers if a specific criteria has been met. EX: SUM (IF {Category 1} = “widget”, value {Cost 1})+(IF{Category 2} = “widget”, value {Cost 2})+(IF{Category 3} = “widget”, value {Cost 3})+(IF{Category 4} = “widget”, value {Cost 4}) (I’m not even sure if an IF function can be used this way.) I also don’t know if I should be using a rollup table or something else, given that this data would be on a separate sheet. Any help is appreciated. Thank you.

102
S
T
TWuInspiring
asked in Other Questions
Rolling up linked records from multiple columns

I’m trying to roll up linked records from multiple columns and return only the unique ones (ideally in record form, not string). For my example imagine I have different car models that can have different packages of wheels, chassis, and accessories. Each of those have separate tables where they have keywords associated with each package. I’d like to display a unique list of keywords associated with each car model that is a rollup of ALL the unique keywords associated with all 3 packages associated with each car. I’ve tried 3 solutions on the far right but I’m running into a few challenges: CONCATENATE({Keywords-Wheels},", “,{Keywords-Chassis},”, ",{Keywords-Accessories}). My solutions are returning strings. Is it not possible to return the actual records so they’re linked? I have commas with empty spaces in between for cases where columns may not have any tags associated ARRAYUNIQUE({Keywords-Wheels},{Keywords-Chassis},{Keywords-Accessories}). When I try to apply ArrayUnique() across

1046
T
M
Mehul_BhandariKnown Participant
asked in Formulas
Display only the Last Updated Modified Value

HI, I have a guest list for an event and want only the last /recent entered values to remain. Unique identifier is guest name guest code as F1,F2,F3,F4,F5. Suppose guest F2 again enters the form after 10 days with new arrival date and departure date - then he previous entry one should be hidden from my sheet and only this be considered in all rollups/lookups/linking.formula etc. I shall calculate rooms required, catering etc when guests enter arrival/departure/no.of persons etc. data using a form When there are two entries in the form for same guest, say F2 - I want the Last modified time to be picked up /maybe in a different view and the first one should be hidden and out of my calculations. Effectively- Duplicates in the same column (F2, F2) need to be removed and only the value (F2) with last modified time should remain. With this feature- I allow guests to change their plan/date/no.of persons requirement in future by entering their guest code.

143
J
B
Brandon_MillerNew Participant
asked in Other Questions
AirTable.net with a shared view

I’m new to AirTable. One of our vendors has provided us with a shared view that I want to automate downloading via the API with a C# console app. All of the documentation I see refers to a base ID, and I’m able to get the sample APIs to work. But our view doesn’t have a base. When I go to the URL directly, I simply get a password prompt. Entering that, I get access to the grid/view. I’m looking for a little guidance for how to connect to our page via the API. Thanks

184
B
C
CBANew Participant
asked in Other Questions
Conditional ability to link?

Hi all, I’m using Airtable to make a list of contacts for conflict checking in a law firm. I made a single table of all “contacts” including both people and organizations, and added some basic info like phone numbers, emails, etc. I also added a column which says “contact type” and splits the contacts into people or organizations. I want to be able to list the individuals who make up or work for organizations. I did this by making a new column called “members” and linking it to the same “contacts” table. Then I type in and select individuals’ names. However, I don’t want to be able to list individuals as members of other individuals. Can I write a formula by which an individual is unable to be added as a “member” of another individual? If you’re wondering why I don’t separate individuals and organizations into distinct tables–the reason is because (1) it will be easier to search a single table and (2) I also want (and made) a separate “cases” table which has a column for clients a

124
S
N
Nikolai11New Participant
asked in Development & APIs
Error: Row Does Not Exist

I am trying to patch fields, however I am facing trouble with the record ID: Here are the records {"records": [{"id": "recMcKXnqXUsJ2Ptu", "fields": {"Name": "GoodLife"}, "createdTime": "2019-10-10T11:56:56.000Z"}, {"id": "recayWtmjGL5k1kgK", "fields": {"Name": "Love"}, "createdTime": "2019-10-10T11:56:56.000Z"}, {"id": "recqCoVKArOQS4UPL", "fields": {"Name": "Fashion"}, "createdTime": "2019-10-10T11:56:56.000Z"}]} And here is the error message I received {'error': {'type': 'ROW_DOES_NOT_EXIST', 'message': 'Record ID recayWtmjGL5k1kgK does not exist in this table'}} As you can see above, there actually is a record with the ID recayWtmjGL5k1kgK, hence I do not understand the error message.

262
N
T
Tom_KeysersInspiring
asked in Development & APIs
Creating a public web view of an entire base -- caching and filtering ideas?

I’m about to develop a public view of our entire product database, which is one Airtable base of around 2000 records. Right now we’re having something like that in place, but basically just as an embedded view (the standard Airtable functionality) – but we’d like to enhance this public view, hence the custom developing need of it. The functionality of our public view will have to enable filtering all of the products on multiple levels – e.g. product category, price range, colour … you name it. Since this will be a public view, and hitting the api limits would happen easily with around 2000 records (I guess), I believe some sort of caching of the entire base data is in order. My main question is: how, and in what way? My first thought is to poll for the Airtable base at like an hourly interval, and saving all that data in one json file, then reading that json file on the client side with vue.js and outputting it in a gallery sort of way, with all the filters in place. That still leaves

616
T
S
Sylvain_DionneKnown Participant
asked in Formulas
Document numbering

Hello everyone, I use Airtable to manage projects and elements (Balcony, Terrace, Stairs, Separator Screen) in projects. I look for a method to automatically create drawings numbers. Indeed in elements table I have a link to projects table and for each element I create a drawing. I want drawings numbers drawing like this: ProjectNumber-ElementCode-Number the numbers is reset for each different element in same project. Example: Project1-Balcony A-01 Project1-Balcony A-02 Project1-Terrace X-01 Project1-Terrace X-02 Project2-Balcony A-01 Project2-Balcony A-02 Project1-Terrace X-01 So, as you see, the numbers at the end are reset for each element in same project, and reset between project. Can someone help me? Thanks SDionne

43
S
M
mycaleNew Participant
asked in Formulas
IF Checkbox, add +1

Hi there I’d like to make a formula that whenever I mark the checkbox (I’ll unmark it later again), it will add +1. It’s a counter for how many times I already did a recurring task. Any ideas on how to do that? Many thanks in advance Cheers Marc

192
M
N
Nikolai11New Participant
asked in Development & APIs
Patch records with computed fields

I have a table/records with a computed column/fields (using a lookup function) - let’s call this field/column F0. I would like to PATCH the table by changing the values of field F1 and leave everything else as is. However, when I send the request I obtain the following error { "error": { "type": "INVALID_VALUE_FOR_COLUMN", "message": "Field \\"F0\\" cannot accept a value because the field is computed" } } Any guidance would be appreciated!

81
B
V
Val_MarinNew Participant
asked in Other Questions
Printing Broken

Hello, Seeking help from the community for a printing error. Printing from any view worked fine until the most recent major Windows update (Windows 10). Now, after trying to print, I will get a preparing to print dialogue and nothing happens after that. Any tips?

01
V
M
mycaleNew Participant
asked in Formulas
Change date - depending on single select

Hello there For recurring tasks, I’d like to calculate the data depending on what I select in the single select field. For example: if “2 weeks” choose the formula which adds 2 weeks to a date or if “1 month” then add 1 month and so on. Is that possible? Thank you. Cheers Marc

81
M
S
Stacy_CarlsonKnown Participant
asked in Formulas
IF Yes, Add Columns

Column #1 {Need Hotel?} Yes or No Column #2 {Hotel Cost (Estimate)} {Estimated # Staff} * 250 * {Duration (Days) (Do Not Edit)} What I need is to change the column in #2 so that If {Need Hotel?} = Yes, then Do {Estimated # Staff} * 250 * {Duration (Days) (Do Not Edit)}

62
S

Badge winners

Show all badges
Terms & Conditions