Rock Paper Airtable
Airtable
Rock Paper Airtable - Airtable Universe
Rock Paper Airtable
This formula was the Airtable contest winner for April.
For a video demo and some information about myself check out my i...
When turning off ‘Allow linking to multiple records’ on the to corresponding ‘linked fields’ in two tables it is still possible to link multiple records to one.This is because only the relationship is only restricted from the active table, so it is p...
Giving dedicated real estate to notifications would send a clear signal that the platform is intended for collaboration. Each individual record has an ‘Activity’ sidebar which allows for viewing not only record history but also comments.Notifications...
You could use SWITCH() and IF():
SWTICH({Operational Status},
“Out For Repair”,“Unavailable”,
“Retired”,“Retired”
) &
IF({Check Out Status}=“Checked Out”,“Checked Out”) &
IF(AND(
{Operational Status}=“In Service”,
{Check Out Status}...
Hi :wave: @Tom_R,
I found a few things helpful:
Talk about ‘things’ before even going into relational data. This is surprisingly hard because most people who have experience with excel or google sheets are used to making reports.
Make simple tabl...
Hi :wave: @Ramona_Russo,
Like @David_Skinner said. It’s not possible… but:
If you dig into the thread you’ll find there are a few work arounds with @openside and Zapier.
It might be that you just want to combine both your bases. If the informatio...
@Baka_Serkoukou glad it worked!! So many great answers!
@JonathanBowen really gets to the heart of how powerful relational databases can be.
–
Sidenote: @Jeremy_Oglesby and @Justin_Barrett my new favorite method for making a switch statement is:
cre...
Hi @JonathanBowen & @Umut_UYDAS,
You should consider a Switch formula:
Switch(Rating,
'Excellent', 4,
'Good', 3,
'Fair', 2,
'Poor', 1
)
It’s easier to read. And works well when you have many options.
