The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
As some of you may know, I’ve spent the past year, at least, battling a debilitating physical condition. For the last few months, this expressed itself as near-disabling reflected pain in my arms and shoulders that made working at a keyboard – or foc...
Those of you who’ve tried to reach me lately will either have been met with silence or, if lucky, very occasional messages punctuated by extended periods of silence. The good news is, after a lot of false starts and some extremely expensive tests (ah...
I’ve long had grumpy thoughts about how Airtable’s VALUE() function deals with conversion of malformed numerals. For instance, VALUE('96t7 4B.32') returns 9674.32; personally, I’d be happier if it returned #ERROR!.
A couple of months ago, I fat-finge...
Note: I finally found (and finished) the quick little project I started back in March — right before all my teeth exploded. :winking_face:
Here’s another niche application: Code to generate random[ish] unique numbers in an arbitrary range — say, f...
All –
I want to apologize for my extended absence from Airtable Community; let me assure you it was neither intentional nor enjoyed on my part.¹ I hope what I bring as a peace offering helps make up for all the unanswered questions and messages.
Here...
That has been a function for a while – and, if you reread the OP’s comment, it doesn’t necessarily return the expected result. For instance, WEEKNUM('12/28/2020') – in MM/DD/YYYY format – returns 1, as that date falls in a week that also contains 01/...
I don’t seem to have one. You might want to contact the Think Company author of the accompanying article to see if it’s still available. You might also be able to reverse-engineering it based on the two-part article…
AFAIK, you can only achieve this by installing a browser plugin as described in this undoubtedly outdated response. (Every now and then I dig up an updated plugin and install it to make sure the instructions are still roughly accurate, but I haven’t ...
You can create formulas with indentation, white space, and the like; however, to do it and still retain your sanity, you probably need to do so using an external editor and paste the complete formula into the formula field. The ability to do so is cr...