Adding a new row in a grid(interface)

sowjanyav430 over 7 years ago

Hi

I want to auto increment a user defined id in a grid when a new row is added.
I was able to increment the id but facing an issue...
Test scenario:
Add 2 new rows,delete the 1st row,
again add a new row.
In this scenario am getting the repeated id.
This is because i have used grid row index for id increment,
Please refer the attached screenshots for more details.

Can anybody suggest me how to handle this scenario.

Thanks in advance.

Discussion posts and replies are publicly visible

Parents

0 Vinay Kumar Rai over 7 years ago

Some correctness don't save Employee-Id on First Name,
instead save Employee Ids on Submit button
Uses a Rule called : TEST_Format_EmployeeId

On Submit button save :

a!save(
ri!CDT.employeeId,
           apply(
           rule!TEST_Format_EmployeeId(ri!CDT.employeeId,_),
           1+enumerate(count(ri!CDT))
           )
)

Rule : TEST_Format_EmployeeId
paramaters : EmployeeIds text array
Index number

          =with(
           if(
           len(ri!EmployeeIds[ri!Index])=0,
                     concat("INC-",stripwith(ri!EmployeeIds[ri!Index],"INC-")+ri!Index),
                     concat("INC-",right(year(today()),2),0,0,0,ri!EmployeeIds)
           )
          )
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Vinay Kumar Rai over 7 years ago

Some correctness don't save Employee-Id on First Name,
instead save Employee Ids on Submit button
Uses a Rule called : TEST_Format_EmployeeId

On Submit button save :

a!save(
ri!CDT.employeeId,
           apply(
           rule!TEST_Format_EmployeeId(ri!CDT.employeeId,_),
           1+enumerate(count(ri!CDT))
           )
)

Rule : TEST_Format_EmployeeId
paramaters : EmployeeIds text array
Index number

          =with(
           if(
           len(ri!EmployeeIds[ri!Index])=0,
                     concat("INC-",stripwith(ri!EmployeeIds[ri!Index],"INC-")+ri!Index),
                     concat("INC-",right(year(today()),2),0,0,0,ri!EmployeeIds)
           )
          )
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data