Amazing. I’ve been using these all over the place since they’ve been released. No Code at it’s finest!
Love the speed of shipping stuff. Great work GLIDE!
Any plugin that can get days in a month yet? I’ve been using this formula from @ThinhDinh in the meanwhile:
Awesome ! ! !
I don’t have the actual code for this (i have only done this in SQL), but the logic is to get the first day of the next month (by adding 1 to the current month and setting day =1). then subtract 1 from that date to get the last day of a month.
Awesome ! Does this mean we can now include them in apps for the template store?
Yes. (If not today, then soon.)
and is arrived just in time to make me easy the truncate text!
actually the EOMONTH(D2:D,0) formula is giving you the end of month date, then from this you get the days.
These are the parameters associated to your code or plugin. The parameter can be your column name.
Take a look at this tread to understand better this Convert number in words
Hi Robert, i belive that is this you need
is really easy to use. if let the values empty will consider the actual year and month, and if need a specific date, is just send the parameters year or month
hope that help!
e.g. hyperformula, JSON and array manipulation create myriad of new possibilities
return new Date(new Date( p1).getFullYear(), new Date( p1).getMonth()+1,0).getDate()
I have started playing with plugins with a view to replacing and enhancing functionality in some apps.
I may have missed something, in a few apps I need to remove a space from a string.
So John Smith becomes JohnSmith.
In a google sheets I use
What plugin can I use to replace a space?
Extract Matching Text should do it.
But… why use a plugin when you could do it with a simple template column?