Hello,
I have an After Field Edit action (no cond...
# suiteflows
Suite Deal
07/14/2021, 3:09 PMHello,
I have an After Field Edit action (no conditions) that looks for changes to a custom long text field (notes), and appends the employee name to the end; however, I appear to be stuck in an infinite loop. Any suggestions for fixing this formula:
{custbody_notes}.concat('Test Name')k
KevinJ of Kansas
07/14/2021, 3:25 PMOk - so if I'm guessing correctly - your goal here is to store within the field itself the last person to edit that field?
KevinJ of Kansas
07/14/2021, 3:26 PMcouldn't you create a separate field for storing that - and then on after field edit populate your seperate field
KevinJ of Kansas
07/14/2021, 3:26 PMYour after field edit is infinite looping because the act of editing it - causes it to have another field change
KevinJ of Kansas
07/14/2021, 3:27 PMuntil the workflow bombs out
s
Suite Deal
07/14/2021, 3:33 PMYes, and that makes sense. I will chart your suggested course.
Suite Deal
07/14/2021, 4:56 PM@KevinJ of Kansas is it possible to inject the current user/employee into the "separate field" After Field edit action via formula?
{custbody_notes} + ' ' + {user}k
KevinJ of Kansas
07/14/2021, 4:58 PMwhy not just make your custom field an employee list - and then "current user" becomes an option
s
Suite Deal
07/14/2021, 5:01 PM@KevinJ of Kansas Okay, I've sort of been tip toeing: The Long Text field is a Notes field that I need to include a user timestamp for after each edit to the note...
Note 1 [Suite Deal - 7/12/21 @ 1:00p]
Note 2 [KevinJ Of Kansas - 7/14/21 @ 1:01p]
Suite Deal
07/14/2021, 5:06 PMPerhaps at this point, I should just jump into a workflow action script?
k
KevinJ of Kansas
07/14/2021, 5:07 PMIf you really need something that does exactly that (and I'd question the actual need for it)
KevinJ of Kansas
07/14/2021, 5:07 PMI'd have a field: "New Note"
KevinJ of Kansas
07/14/2021, 5:07 PMand a field: "Note History"
s
Suite Deal
07/14/2021, 5:09 PMYes, sir, been down that path - I'm just recreating behavior that already exists natively in NetSuite...LOl
k
KevinJ of Kansas
07/14/2021, 5:10 PMmy workflow would be a before submit - and it would say "hey new note field isn't empty - set note history field equal to:
{newnotefield} || ' ' || {userfields.name} || ' ' || {today} ||' '|| '{Note history field}KevinJ of Kansas
07/14/2021, 5:10 PMand then clear new note field after submit.
s
Suite Deal
07/14/2021, 5:10 PMDone. I really appreciate your help.
k
KevinJ of Kansas
07/14/2021, 5:11 PMof course -that's just a loose concept.
KevinJ of Kansas
07/14/2021, 5:11 PMand you probably want carriage returns in there.
KevinJ of Kansas
07/14/2021, 5:11 PMbut realisitcally - it feels like you are using a body field when you really should be using LITERALLY the user notes functionality
KevinJ of Kansas
07/14/2021, 5:11 PMwhich does ALL OF THE THINGS YOU ARE LOOKING FOR
KevinJ of Kansas
07/14/2021, 5:11 PMhaha
s
Suite Deal
07/14/2021, 5:13 PMI'm just an order taker.
Suite Deal
07/14/2021, 5:13 PMLOL
k
KevinJ of Kansas
07/14/2021, 5:14 PMRight - either way - I've only provided a loose framework there - you'll have to fix all your field references appropriately
2 Views