Is it possible to write a formula within a workflo...
# suiteflowh
Henry Neils
08/31/2022, 7:14 PMIs it possible to write a formula within a workflow to populate this field to say "ACH1" and then each transaction it adds to ACH2, ACH3, etc etc....
reason we are not doing this within the auto gen numbers is because it is running on conditions on the vendor record.
b
battk
08/31/2022, 7:17 PMdo the script, a workflow will have issues handling concurrency
h
Henry Neils
08/31/2022, 7:18 PMdo you have an example website I can go to for writing this script? I have never written my own
a
AI1
08/31/2022, 7:23 PMYes you can do this using a saved search, hidden custom field and then a formula
AI1
08/31/2022, 7:23 PMall within a wirkflow
b
battk
08/31/2022, 7:23 PMyou need to decide if you want to handle 2 payments being created at the same time before deciding to customize this
battk
08/31/2022, 7:26 PMthe SuiteApp Designs and Concurrency Issues section from the SAFE guide goes over how to handle issues related to concurrency
battk
08/31/2022, 7:26 PMits not a simple topic, certainly not one I would expect a beginner at scripting to solve
battk
08/31/2022, 7:27 PMyour first approach should be seeing if you can use Advanced Numbering
battk
08/31/2022, 7:28 PMprobably try extra hard trying to get that to work, its a lot easier getting advanced numbering to work than it is to find someone able to correctly handle concurrency
h
Henry Neils
08/31/2022, 8:39 PMOkay that sounds good, thank you!
2 Views