Generate sequential number in Fusion | Community
Skip to main content
R
RobertMa23
December 11, 2023
Question

Generate sequential number in Fusion

  • December 11, 2023
  • 1 reply
  • 643 views

Hello, 

 

Is possible to generate a sequential number in Fusion? (ex 100001, 100002) and then update a specific filed in a custom form in Workfront? 

 

 

Thanks 

Robert 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

R
Community Advisor
Richard_Le_Community Advisor
Community Advisor
December 11, 2023

Hi Robert,

 

Fusion doesn't have any memory outside of each scenario execution. So whilst it is possible to use a count function to increment a number sequentially, during the next execution of that scenario it would lose all memory of what count was reached and would start from 1 again. . .  If that makes sense. 

 

The way to tackle this would be to set up a data store to hold a numeric attribute. Each time the scenario is triggered, Fusion reads the datastore to fetch the latest "count", increments it by 1, writes to Workfront and then writes back to the attribute in the data store with the latest count (so it can then be referenced in the next scenario execution). By using this approach, you are effecitvely creating a memory function to store the latest sequential number in an "external" database so that it can be referenced by your Fusion scenario as and when required. 

 

Does that help?

 

Best Regards,

Rich.

 

RandyRoberts
Community Advisor
RandyRobertsCommunity Advisor
Community Advisor
December 20, 2023

That would be a great template to add to the built-in Fusion templates!

    Terms & ConditionsAccessibility statement

    Loading footer...