Hi! So…to all the old heads who have been working...
# generalp
PaulJ
06/20/2023, 4:22 PMHi! So…to all the old heads who have been working with NS for years, I know that a custom field with ‘store value’ unchecked and a formula used to dynamically calculate the field value isn’t available for saved search……except now it seems like it is?? I have built such a field and can pull it into search results with the result still calculating correctly. Is this….a bug? A super great useful bug? Or was it buried somewhere in release notes and I missed it?
r
RJMNS
06/20/2023, 4:27 PMOh wow that would be super useful. I haven't noticed that, but I'll now have to go try it.
I wonder if it's also updating the table in the back end or if they are still just doing the calc on-demand and just expanded where it shows.
Probably the latter, but it would be great if it was both.
RJMNS
06/20/2023, 4:31 PMIt seems like they toss in a bunch of these little quality of life improvements into each release, but I don't think they're in the release notes. Likely because they're not flashy. Even though for those of us who have been annoyed with this stuff for years, it's a great improvement.
Similar to a few years back when they made GL account number only an option to use as "account" when importing JEs. Where previously you had to either use the account number + name (incl hierarchy), External ID or Internal ID.
p
PaulJ
06/20/2023, 4:34 PMyes!! exactly like that
PaulJ
06/20/2023, 4:35 PMokay I’ll keep an eye on this over the next few days and see if it continues working (the calculated field is a counter of today - {customdatefield}) and will update this thread if it stops working.
s
sam1128
06/20/2023, 7:10 PMFormula field are supported by workflow and saved search for few years now it’s not bug.
d
Dylan Fields
06/20/2023, 8:54 PMInteresting.
k
Kristy Kapsner
06/20/2023, 10:10 PMHmmm, I haven't seen that work yet. How recent is recent?
m
michoel
06/20/2023, 10:44 PMj
Jon Kears
06/21/2023, 1:04 AMwhaaaaaaat? I had no idea!
Similar to a few years back when they made GL account number only an option to use as "account" when importing JEs. Where previously you had to either use the account number + name (incl hierarchy), External ID or Internal ID.
r
RJMNS
06/21/2023, 6:24 PMYup @Jon Kears. Last I knew it only worked for JEs. I don't know if they ever enabled that for vendor bills, which would also be nice.
p
PaulJ
06/21/2023, 8:44 PMnext day - formula still works on the field AND in search. Wild stuff.
3 Views