Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jul 08, 2020 11:20 AM
It’s 2020 halfway through. Are we getting trig functions in formula field? I need to have the ability to instantly calculating values when some fields are populated (no script block manual triggering).
Jul 09, 2020 05:10 PM
This is not true. Several new formula functions have been released since then. Off the top of my head, the SWITCH
and SET_TIMEZONE
functions have been release within the past year. There are more that I don’t remember.
In some cases it tells you where the error is. For example, I have seen it tell me when I have a typo in a field name.
It does preserve the spaces and carriage returns when you cut and paste into an external editor. Those white space characters are still there, the input box just doesn’t handle them well.
Color coding would be nice. A bracket matcher would also be nice. But then you’re talking about developing a whole new editor. For scripting block, Airtable was able to use the Monoco editor with JavaScript grammar. However, Airtable formulas use a proprietary grammar with a vocabulary that can be expand at any moment. Creating an editor for formulas might be significantly more difficult than creating the editor for Scripting block.
There are many aspects of the formula editor that could use improvements, but I feel the situation isn’t as dire as you describe.
BTW, my thoughts on code editors has evolved over the years. They are also heavily influenced by a programmer that I really respect who prefers an editor without color coding, syntax highlighting, grammar checking, bracket matching, a debugger, etc.
Jul 09, 2020 06:54 PM
You’ve given an exception to the rule, which is a very nice & welcome exception.
But in 95% of cases, it doesn’t tell you where the error is. Like all other formula editors, it should tell you exactly where the error is — even a character number would be helpful.
It never preserves carriage returns under any circumstances.
To start with, you’re never allowed to type in carriage returns into the formula editor, so you’re required to use an external editor if you want to use carriage returns while constructing your formula.
Next, let’s say you just spent a bunch of time typing up this beautifully-formatted formula in your text editor:
IF(
{Registrant Name},
IF(
OR(Individual="",{Registered Event}="",{Email}="",{Register/RSVP}=""),
"Yes","No"
),
"No Name"
)
Now, try pasting that beautiful code into Airtable, and then SAVE your formula.
Next time you open up your formula, Airtable has obliterated all the carriage returns in the formula, so that it now looks like this:
IF({Registrant Name},IF(OR(Individual="",{Registered Event}="",{Email}="",{Register/RSVP}=""),"Yes","No"),"No Name")
If you try to copy this and then paste it into an external editor, it does not revert back to how it used to look. The carriage returns are gone forever.
By the way, I used an extremely simple example there that you can still sort of read okay in Airtable. That formula above is not very complicated.
But imagine a “Nested IF” formula that has many, many more lines than that. Makes it very difficult to read as a human. And then, upon copying out of Airtable and pasting into a text editor, you don’t get your carriage returns back.
So then, in your text editor, you have to manually put all your carriage returns back again, if you want to read a cleanly-formatted version of your formula.
Not dire, just frustrating. (I bounce back & forth all day long between FileMaker & Airtable, and there are vast differences in usability between the 2 products.)
But yeah, I feel like the need for more functions — and the improvement of existing functions — might be a bigger issue than the formula editor.
Although they really go hand-in-hand — the more functions we have accessible to us (and we already have a small handful of good functions), the more we will need to depend on carriage returns & telling us where errors are located.
Yeah, I don’t really need any of those things, if the formula box would give us THE 3 BIG THINGS:
Those are the big 3.
And then, we really need better formula functions.
Here’s a list of all the functions in FileMaker Pro. If they pulled just 5% of the functions from FileMaker Pro, it would make Airtable much more usable.
p.s. @Jason — this post summarizes my top feature requests for formulas in Airtable! :slightly_smiling_face:
Jul 09, 2020 08:11 PM
[quote=“ScottWorld, post:12, topic:31745”]And then, upon copying out of Airtable and pasting into a text editor, you don’t get your carriage returns back.
I do get my carriage returns back. It’s puzzling that you don’t.
Jul 09, 2020 08:14 PM
@kuovonne I’ve tried pasting into many different apps on my Mac, and the carriage returns never come back. I’ve tried like 5 different apps. Which app are you pasting into, where the carriage returns are coming back?
Jul 09, 2020 09:00 PM
@ScottWorld I’m on Windows 10. The carriage returns paste into any app for me: notepad, Atom, MS Word, etc.
Jul 09, 2020 09:18 PM
Wow! Very interesting! It definitely doesn’t work on Mac. I’ve tried in every Mac app that I can think of — Microsoft Word, Apple Pages, TextEdit, BBEdit, Sublime Text Editor, and many other text editors as well.
There must be some difference between Airtable’s behavior on Mac vs. Windows.
p.s. I should mention that I’m using the web version of Airtable, not the Airtable desktop app.
Jul 09, 2020 10:54 PM
I’m not sure that it’s a Mac vs Windows difference. Carriage returns in formulas (when pasted after copying from another app, BBEdit in my case) are maintained on my Mac. This is also in the web version, though I don’t think it makes a difference which version is used, as the desktop version is just running a bare-bones web browser from what I’ve been told.
Jul 09, 2020 11:15 PM
Very strange. Yes, BBEdit is my primary text editor on the Mac, too. I just tried this right now, and it didn’t work for me.
This is what I did:
I copied my 20-line formula from BBEdit (with carriage returns separating the lines) and then pasted it into the formula field on Airtable. Upon saving the formula, all carriage returns were removed in Airtable. Then, I copied the formula from Airtable and pasted back into BBEdit — all carriage returns were still missing.
I’m just using command-c and command-v to copy and paste everywhere.
I’m also using Safari as my web browser.
Are you doing something differently than I am?
Jul 10, 2020 05:39 AM
If you’re using Safari as your browser everyone on the planet is probably doing something different because nobody uses Safari. Oh wait, now two people use Safari and I know both of them. :winking_face:
Levity aside, I don’t see any mention in your tests concerning how you actually invoke a copy.
There are actually two copy buffers in all modern browsers; some actually employ three. This is why it’s possible to see two (or more) different outcomes depending on a menu-selected copy vs a keyboard-invoked copy. To truly test any of your outcomes, you must explore the outcomes based on which buffers are used.
Bear in mind, some browsers attempt to sanitize anything copied, thus treating a keyboard copy (Ctrl-C/Cmd-C) as if you were copying from a plain text field (like the URL bar). Whereas, the OS-level copy (using a menu selection) doesn’t have this constraint and for good reason. There are also potential sanitization nuances with right-click-copy selections.
And then there’s the non-browser software apps (i.e., anything that is compiled). These each may support multiple copy buffers and employ different copy-sanitization practices as they see fit.
Test these operations requires a 3D matrix. Good luck hunting. :slightly_smiling_face:
Jul 10, 2020 10:35 AM
@Kasra, do you have any idea why other people are able to copy and paste formulas with carriage returns, but I am not? I have nothing special installed on my bare-bones Mac with just basic copying & pasting abilities.