Skip to main content

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).


Dude! I said that way up here! Are my posts invisible or something?




Lol! Your post seemed comedic, not sincere, since you were poking fun of me for using Safari! 😜


If I knew you were being serious, I would’ve tried a different web browser earlier!!



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. 🙂




I made it clear that everything from that point down was sincere. Ignore my words at your peril. :winking_face:



Yep - always was a non-Airtable issue.


Airtable has no dog in this fight. It’s the browser and all elements of the development climate you happen to choose, including (but not limited to) the process you choose to invoke a copy event in the first place. If you choose something (like Safari) which tends to lean into consumers, you’ll likely have issues if you are fundamentally engaging in development activities - i.e., any sort of significant copying/pasting/transformations.



If Airtable seeks to make this possible, it would be like crossing the streams in Ghost Busters; things would get ugly and unpredictable. Furthermore, in my view, it’s not Airtable’s job to bring any behaviour to any modern browser except the full and complete embrace of modern browser standards.


Apple - as it is the case many times - tends to dodge certain standards to the direct benefit of its consumers and selfish support requirements. This is simply another case where it has tiptoed across a line where most browser vendors tend to be rigid about the adoption of standards. There is no shortage of articles about Safari becoming the new IE, a calamitous free-fall into the depths of obscurity.



That’s very cool! What app do you use to create these files? Can you post a screenshot of what one of your files looks like?



You were asking Jeremy how he keeps his formulas in text files, but I thought I’d mention my method too.


I also save my more complex formulas in text files and edit them using my code editor (Atom). Each formula is in its own file along with my personal notes about the formula (when to use it, how it works, limitations, etc.). All of these files are stored in a private GitHub repository.


I don’t keep copies of simpler formulas (e.g. formulas that take only a few functions or are only a few lines long).


Reply