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…
Yeah, I don’t think you can click on links directly in kanban view: The first click opens that particular card, and the next follows the URL. However, you could possibly create a multi-record Page Designer Block, each containing a URL, and print that...
Look at the second example in this reply. You can use a format specifier to extract a value you can then feed directly back into DATEADD() in order to restate your local time as GMT. I agree, it gets confusing when working with an integration timesta...