Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Aug 31, 2021 05:09 AM
Hi guys,
First time using Airtable, been trying to set it up for a nutritionist clinic and I ran into an issue. Hope I can receive some guidance here.
I have to tables
table1 has user_height, user_weight and user_bmi (calculated based on the height & weight)
table 2 has the bmi ranges min_bmi, max_bmi, bmi_status.
E.g. min_bmi = 1, max_bmi = 18.49, bmi_status = underweight
min_bmi = 18.5, max_bmi = 22.9, bmi_status = normal
min_bmi = 23, max_bmi = 27.49, bmi_status = overweight
min_bmi = 28, max_bmi = 100, bmi_status = obese
In order to retrieve the bmi_status, the calculated bmi needs to fall within the range of min_bmi and max_bmi.
How do I join table1 and table2 to get the bmi_status? Is it possible?
Expected output:
table1: user_id, height, weight, bmi(calculated), bmi_status (extracted from table2)
Sep 25, 2021 03:50 AM
Where was Airtable when I needed to learn a bunch of higher-order function patterns? Tricking me into just writing them would have worked way better than reading books with unnecessarily mean titles. 🥲
Either way, this new section is a super convenient reference for anyone.
EDIT: @Rose_K Seems like a good candidate for a featured resource spot, as well? Unless it’s already there and I’m just not seeing it.
Sep 28, 2021 08:38 AM
@Dominik_Bosnjak Thanks for the call out!
This article is included in the featured resources currently (it’s the “Formula field reference” article). I just updated the description for that article to include a reference to expressions for those searching for that term. :slightly_smiling_face: