Ability to Update fields with formulas like now(), increment values etc | Voters

Ability to Update fields with formulas like now(), increment values etc

Audrey Melnik

Allow actions to support values that perform date and math functions on other values plus also support now()

August 2, 2021

Michael Connolly

To be able to set time fields to today() or now() would be great for adding new records to bases.

matt billiodeaux

Bump... the ability to update a field's value using results from a formula calculation is a needed feature.  But, I need TEXT operators as well. 
For example, I'd like the ability to extract the last 2 characters of a text ID field (ex "JohnDoe-DrApt12"  --> "12") and increment it ("12" --> "13") then recombine ("JohnDoe-DrApt13").
There are many other useful things that can be done with an "Update Using Formula" button.  
Some useful operators I'd like to see:  
+, -, /, *, ^, &, >, <, =, <=, >=, OR, AND, XOR, 
ToArray(), Filter(), Sort(), Unique()
Regex(), Left(), Right(), Len(), IsNumber(), IsText(), Find(), FormatText()
IfError(), If(), Case(), Choose()
Max(), Min(), Sum(), Avg(), Count(), CountA(), DEC2HEX(), 
Split(), Join(), Index(), Transpose()
**the index would be useful for working with arrays loaded into the formula...
Date(), DateDiff(), StringToDate(), Now(), Year(), Month(), Day(), Week()
While I'm requesting, just go ahead and let us use a javascript light flavor for the making our own UDF functions :D