I swear I've done this before without issue, but f...
# suiteflowd
Dylan Fields
10/10/2023, 9:01 PMI swear I've done this before without issue, but for some reason having trouble this time.
Scenario: I wish to capture the Amount Remaining on a Bill in a custom field for use in a suitelet. As far as I can tell, even though you can include a native Amount Remaining on a saved search, it's not a field whose ID you can use anywhere else. I created a summary saved search to capture the value, then a custom body field that pulls in the value from the SS, then another custom (stored) body field to capture it via WF from the first field.
It's a scheduled WF set to run every 30 mins. From there, which trigger do I use on the Set Field Value action? I had it on Entry as I have with another similar WF where I swear this is working, but no dice. I've now set the action to run via schedule as well, but it just seems wrong.
Dylan Fields
10/10/2023, 9:05 PMOf note: I'm most interested in updating the weeks/months old bills; would do on create/update if the focus was the new/to be created ones.
m
MGBC
10/11/2023, 12:37 AMFor a scheduled workflow you would use the entry trigger with no conditions.
MGBC
10/11/2023, 12:38 AMIf you turn on logging can you see what error it gives when setting the value
d
Dylan Fields
10/11/2023, 4:46 PMThanks.
It's weird - it seems to be working, but only firing off a handful before stopping (no error emails coming). There are about 10k old transactions I'm trying to get updated.
Dylan Fields
10/11/2023, 5:31 PMJust saw this: "How are you testing this? Are you waiting for the schedule to kick in? If you are testing this using the 'Save and Execute' functionality of Workflows, then it will only run on the first 20 results of the search." That explains that.
m
MGBC
10/11/2023, 6:05 PMYou can trigger your workflow for those 10,000 records specifically on demand using a Mass Update