This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
It's quite annoying when you need to need to add another variable to a script, but it only lets you append to the end. They are always presented in a consistent order, so it's a bit of an artificial limitation that one cannot change this presentation...
TODAY() and some similar functions are broken because they're stuck on Greenwich Mean Time. What it's meant to do is return a value that changes once per day, at the start of the day. It does this by setting the time part of the current date and time...
Almost 5 years to the day, and we still don't have such a simple and obvious improvement. We sometimes use emojis as a workaround but they are horrible as it it means both positive and negative glyphs are "truthy" values to IF(), their literal values...
They haven't updated it. Your formula is pointless as NOW() is already in GMT, except that the result type of yours is a string, not a real date, so it cannot be used for date-based operations.Sorry, but I think you've missed the point of needing val...
Page titles are still a bit lacklustre in general.When viewing automations, the title is just "Base Name - Airtable"The order of segments can make browser tab titles useless, i.e. "Base Name: Table Name - Airtable" will result in multiple adjacent ta...
Use console.log(...) at various points in your script to check the values of your input and output variables when testing it.Post a new help question if you continue to have trouble, unless you can contribute more information that will help others re...
The best way to do this is with the same kind of script step as in the accepted solution, but use Intl.NumberFormat as per my answer in another thread.@Camanzi I also updated my formula version so that it handles negative values and amounts less tha...
