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.
Solved! Go to 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
User | Count |
---|---|
35 | |
35 | |
27 | |
23 | |
18 |