topic Dynamic counter as result (part) of the repeat(...)-function in App Development

Dynamic counter as result (part) of the repeat(...)-function

Christiann — Thu, 13 Jun 2024 11:47:56 GMT

Hi all,

I'm looking for a solution to the following problem:

I need a counter that counts up within the result of the repeat(...) function.

As an example:
=repeat( X, 5 ) should return '12345' as the result.

What can X look like for this?

Best regards

jpenuliar — Thu, 13 Jun 2024 11:59:13 GMT

look at Valueloop function:

Concat(distinct ValueLoop(1, 10),'',ValueLoop(1, 10))

Christiann — Thu, 13 Jun 2024 12:35:28 GMT

Thank you for your reply.
Unfortunately, it doesn't quite solve the problem.

I need to concretize it.

X is a combination of text and consecutive number, so the result should be the following:

'abc1', 'abc2', 'abc3', 'abc4', 'abc5'

Christiann — Thu, 13 Jun 2024 13:05:45 GMT

or more precisely, the result should be as follows:

'abc1 xyz1', 'abc2 xyz2', 'abc3 xyz3', 'abc4 xyz4', 'abc5 xyz5'

I need the number twice per repetition

Christiann — Mon, 17 Jun 2024 06:17:25 GMT

Hi,

here the complete solution:

concat( '<FirstPartOfText>' & valueloop( ExpForCounter ) & '<SecondPartOfText>' & valueloop( ExpForCounter ),

'<AdditionalPartOfText>', // this is important for the concat( ... ) function

valueloop( ExpForCounter ) ) // for correct sorting of the result