RepeatSerializedValue ( Text ; StartingNum ; NumRepeat ; TextReplace )
Returns a repeating list with a serialized counter
Average rating: 4.1 (24 votes) Log in to vote
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
This is based on the RepeatValue function by Koji Takeuchi.
This returns a repeated ¶ separated list to include a serialized counter.
Text = The value to repeat.
StartingNum = The starting Number of the incremental counter.
NumRepeat = The number of times to repeat the text.
TextReplace = The value to be replaced by the incremental
If StartingNum is one (1), then the first serialized value is 1. If StartingNum is 20, then the first serialized value is 21.
#1) RepeatSerializedValue ( "I have @FM dogs"; 1; 3 ; "@FM")
#2) RepeatSerializedValue ( "Chapter @FM"; 10; 3 ; "@FM")
#1) "I have 1 dogs¶I have 2 dogs¶I have 3 dogs"
#2) "Chapter 11¶Chapter 12¶Chapter 13"
Nov 16, 2015
Why "If StartingNum is 20, then the first serialized value is 21." , not 20?
Rather than you can't get result starting with 2.
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.