Increment row value by 1

[rrhirani]

I have a column named Row(s) - Enumlist and in the form, I need it’s last valid value + 1 preselected.
for eg., if last value in Row(s) is Row 1 then I preselected value should be Row 2

I wrote below expression in Initial Value.

LIST(ANY(SELECT(Row[Row(s)], ([Row_ID] = ANY(ORDERBY(FILTER(“Row”,ISNOTBLANK([Row(s)])), [Completion Timestamp],TRUE))), TRUE)))

It’s giving me result “Row 1”. how can I increment it by 1? I need Row 2 as result.

Any suggestions would be great. Thanks.

[WillowMobileSys]

The error you posted is complaining that the number of open parentheses do not match the number of closed parentheses. You are missing one somewhere. Did you fix that already?

[rrhirani]

@WillowMobileSystems : Yes, I fixed it and updated the question.

LIST(ANY(SELECT(Row[Row(s)], ([Row_ID] = ANY(ORDERBY(FILTER(“Row”,ISNOTBLANK([Row(s)])), [Completion Timestamp],TRUE))), TRUE)))

Now I am getting row value “Row 1” but I need “Row 2” as a result. Any suggestion?

[rrhirani · Accepted solution]

I’ve found the solution. The below expression worked for me. I hope there must be some simple solution. It’s complex.

CONCATENATE("Row ", LIST(NUMBER(INDEX(SPLIT(LIST(ANY(SELECT(Row[Row(s)], ([Row_ID] = ANY(ORDERBY(FILTER(“Row”,ISNOTBLANK([Row(s)])), [Completion Timestamp],TRUE))), TRUE))), " "),2)) + 1))

Thanks @WillowMobileSystems for your reply. @Steve @Suvrutt_Gurjar @AlexM Let me know if there is any simple alternative available. Thanks in Advance