Increment temporary value and and assign

[Miker (Mike Ruoppoli)]

Here is my event

I am counting the number of rows in the row-find and storing it in a temporary dataview field dvFilter.RowCount. I have confirmed that this value gets stored each time I execute the button click. In the condition i check to see if the value of dvFilter.RowCount is greater than 0. This is working

Next when I see that dvFilter.RowCount is greater than 0 I want to increment that stored value and assign it to the value of SplitID in a different data view, dvUpdate.SplitID.
All attempts to increment to increment this value and display in this new row have resulted in something that resembles this

but should be the number 2 in this case.

Here is the JSON value statement in the row-add

I have been working on this for a day now with no success. Any Suggestions?

[cory.davis]

Try putting the curly brackets around only your dataview.column:

"Calculated_SplitID": "{dvFilter.RowCount} +1"

This part, {dvFilter.RowCount}, should return your current row count.

[klincecum (Kevin Lincecum)]

@Miker

also I would try
{dvFilter.RowCount} > 0

[Miker (Mike Ruoppoli)]

Mine actually works for the condition check.

[Miker (Mike Ruoppoli)]

Got closer with your suggestion. But still not a number

[cory.davis]

You said dvFilter was a temporary dataview right? I know with transview it seems like any field you define on the fly gets stored as a string. Maybe you can define RowCount in the dataview and make it an Int so you can do math on it?

[klincecum (Kevin Lincecum)]

@Miker

Mine actually works for the condition check.

Are you sure…

[Miker (Mike Ruoppoli)]

Yup

[Miker (Mike Ruoppoli)]

Did that from the start and confirmed that there was a value in there from the get go before trying to increment it.

[klincecum (Kevin Lincecum)]

Show where you set it.

[Miker (Mike Ruoppoli)]

This is the KMH that displays the alert

[Miker (Mike Ruoppoli)]

[Miker (Mike Ruoppoli)]

Tested yours and it works as well.

[cory.davis]

Maybe just ditch the double quotes altogether? I tried doing a test with the row-update widget and just putting {dataview.column}+1 in the expression field worked.

If removing the quotes doesn’t work you could add a row then update it with row-update.

[Miker (Mike Ruoppoli)]

For some reason the + sign is being interpreted as a string not an operator.
{
“Calculated_SplitID”: “{dvFilter.RowCount} + 1”
}

[cory.davis]

Change this:

@Miker

{
“Calculated_SplitID”: “{dvFilter.RowCount} + 1”
}

Into this:

{
“Calculated_SplitID”: {dvFilter.RowCount} + 1
}

[Mark_Wonsil]

@Miker

For some reason

Javascript?

“Calculated_SplitID”: {dvFilter.RowCount} + parseInt(1, 10)

SWAG here.

[Miker (Mike Ruoppoli)]

@cory.davis

I added this back into the Row Update and then the add row with
{
“Calculated_SplitID” : “{dvFilter.RowCount }”
}

Worked… Thanks for your help!!!