I have an Interactions and an Investors table. There are vaious interaction types as investors move from cold > warm > diligence, etc. These interaction types are managed via a single-select and piped in via various automations. Two metrics I’m tryin...
In an Interactions table, I’m using a checkbox field to mark specific interactions 7-day follow-up. In a different table, I’d like to see if the most recent interaction for a contact has 7-day follow-up checked. MAX(values) works for dates but return...
I have a concatenate function in a table’s primary field. One of the fields it combines is a rollup of companies in a Companies table. Typically, it’s one company per record, occasionally two.
To strip the pesky quotes I get when there’s comma in a c...
I’m setting up a base to among other things track articles aligned with specific research topics. The end goal is a record of articles/papers/research already reviewed and deemed relevant.
Two tables:
Reading log: web-clipped articles with four view...
An integration with Stripe, similar to Typeform’s “blocks” would be extremely helpful. While Stripe + Airtable Zapier integrations enable record updates once a product/service is sold, they don’t facilitate (to my knowledge) access to base data from ...
Thank you! This almost works but the data structure on Table 1 gets in the way. I’m curious about ‘Tod’ in your formula - I’m not sure how that works :slightly_smiling_face: If I switch it to anything else it fails. What’s the underlying logic?
That’s where I started but couldn’t find a way to eliminate zeros (no corresponding interaction) without adding 5 more formula fields. I then tried the same approach with a rollup but I’m not seeing an aggregation formula that only returns a numeric ...
Holy… Thanks for sharing this! I’m accustomed to resorting to an equally painful workaround on a different platform but didn’t expext this here. I’d absolyely go fo it but… bloat.
