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 sowjanyav430 over 7 years ago

addRowlink: a!dynamicLink(
label: "Add New Employee",
value: 'type!{urn:com:appian:types}SVG_IAL1_Employee'(
employeeId: rule!SVG_IAL17_EmpAutoGenForGrid(
if(
rule!SVG_IAL_CheckForNull(
ri!employeeDetails
),
1,
count(
ri!employeeDetails
) + 1
)
)
),

and my rule is :
if(len(ri!employeeId)=0,
concat("INC-",stripwith(ri!employeeId,"INC-")+1)
,concat("INC-",right(year(today()),2),0,0,0,ri!employeeId)

)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 sowjanyav430 over 7 years ago

addRowlink: a!dynamicLink(
label: "Add New Employee",
value: 'type!{urn:com:appian:types}SVG_IAL1_Employee'(
employeeId: rule!SVG_IAL17_EmpAutoGenForGrid(
if(
rule!SVG_IAL_CheckForNull(
ri!employeeDetails
),
1,
count(
ri!employeeDetails
) + 1
)
)
),

and my rule is :
if(len(ri!employeeId)=0,
concat("INC-",stripwith(ri!employeeId,"INC-")+1)
,concat("INC-",right(year(today()),2),0,0,0,ri!employeeId)

)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data