Automate

Hello everyone!

As the title says, I have a repeating section with a bunch of fields and sublabels. I want to use the sublabels to write the old value of that field. The rule sounds like this: 

if new_value != old_value

set style of the new field, colour blue (which works absolutely fine)

set label of the new field as concat(Old value: old_value), true (so it's the sublabel).

Now here comes the problem.... whenever the set label rule runs, it sets the sublabel for all the fields in that repeating table.

I've already tried the "for i=0;i<count..." route and that doesn't work.. 

Any ideas or is this a dead end?

Here are some screenshots, in case I didn't explain it well.

Thank you! :)

Hi Florin,

You can try using ruleFieldInfo.rowIndices instead of running rule using a for loop (like : for i=0;i<count.)

ruleFieldInfo.rowIndices works only on the index where the field value is changed.

I have tried this with other rules in the repeating table, let me know if this helps, If not please attach a copy of test solution, I will give it a try if there's some other way to achieve it.

Regards

Hello everyone!

As the title says, I have a repeating section with a bunch of fields and sublabels. I want to use the sublabels to write the old value of that field. The rule sounds like this: 

if new_value != old_value

set style of the new field, colour blue (which works absolutely fine)

set label of the new field as concat(Old value: old_value), true (so it's the sublabel).

Now here comes the problem.... whenever the set label rule runs, it sets the sublabel for all the fields in that repeating table.

I've already tried the "for i=0;i<count..." route and that doesn't work.. 

Any ideas or is this a dead end?

Here are some screenshots, in case I didn't explain it well.

Thank you! :)

Hi Florin,

You can try using ruleFieldInfo.rowIndices instead of running rule using a for loop (like : for i=0;i<count.)

ruleFieldInfo.rowIndices works only on the index where the field value is changed.

I have tried this with other rules in the repeating table, let me know if this helps, If not please attach a copy of test solution, I will give it a try if there's some other way to achieve it.

Regards

Hello everyone!

As the title says, I have a repeating section with a bunch of fields and sublabels. I want to use the sublabels to write the old value of that field. The rule sounds like this: 

if new_value != old_value

set style of the new field, colour blue (which works absolutely fine)

set label of the new field as concat(Old value: old_value), true (so it's the sublabel).

Now here comes the problem.... whenever the set label rule runs, it sets the sublabel for all the fields in that repeating table.

I've already tried the "for i=0;i<count..." route and that doesn't work.. 

Any ideas or is this a dead end?

Here are some screenshots, in case I didn't explain it well.

Thank you! :)

Hello everyone!

As the title says, I have a repeating section with a bunch of fields and sublabels. I want to use the sublabels to write the old value of that field. The rule sounds like this: 

if new_value != old_value

set style of the new field, colour blue (which works absolutely fine)

set label of the new field as concat(Old value: old_value), true (so it's the sublabel).

Now here comes the problem.... whenever the set label rule runs, it sets the sublabel for all the fields in that repeating table.

I've already tried the "for i=0;i<count..." route and that doesn't work.. 

Any ideas or is this a dead end?

Here are some screenshots, in case I didn't explain it well.

Thank you! :)

Hi Florin

The JS route is one way to go.

I know rules on repeating sections or table scan sometimes be tricky.

How are you firing the rules for the sublabels?  Rules at the row level should be triggered by something in that row - on change - not on load.  Is that what you have?  If not, is that something you can try?  

Hope this helps.

Best Regards,

Sigrid

Hello everyone!

As the title says, I have a repeating section with a bunch of fields and sublabels. I want to use the sublabels to write the old value of that field. The rule sounds like this: 

if new_value != old_value

set style of the new field, colour blue (which works absolutely fine)

set label of the new field as concat(Old value: old_value), true (so it's the sublabel).

Now here comes the problem.... whenever the set label rule runs, it sets the sublabel for all the fields in that repeating table.

I've already tried the "for i=0;i<count..." route and that doesn't work.. 

Any ideas or is this a dead end?

Here are some screenshots, in case I didn't explain it well.

Thank you! :)

Hi Florin,

Can you share a copy of the solution, or may be create a test solution with just the required field.

I will try to work it out if this is something we can achieve.

Regards

Hi Florin

The JS route is one way to go.

I know rules on repeating sections or table scan sometimes be tricky.

How are you firing the rules for the sublabels?  Rules at the row level should be triggered by something in that row - on change - not on load.  Is that what you have?  If not, is that something you can try?  

Hope this helps.

Best Regards,

Sigrid

Hello everyone!

As the title says, I have a repeating section with a bunch of fields and sublabels. I want to use the sublabels to write the old value of that field. The rule sounds like this: 

if new_value != old_value

set style of the new field, colour blue (which works absolutely fine)

set label of the new field as concat(Old value: old_value), true (so it's the sublabel).

Now here comes the problem.... whenever the set label rule runs, it sets the sublabel for all the fields in that repeating table.

I've already tried the "for i=0;i<count..." route and that doesn't work.. 

Any ideas or is this a dead end?

Here are some screenshots, in case I didn't explain it well.

Thank you! :)