• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 257
  • Last Modified:

auto number

hi experts,

i'm building a web application. i need to auto number my field called cItemID.
i've placed this formula in the computed field.

@If(@DbColumn("":"NoCache";"":"";"Numberlist";1)="";1;
@Subset(@DbColumn("":"NoCache";"":"";"Numberlist";1);1)+1)

Numberlist is a separate view with one column, cItemID; sorted in descending order.

there is an internal server error. what could have gone wrong? please correct me. thx!
0
minority
Asked:
minority
1 Solution
 
scottrmaCommented:
Try this:

temp := @DbColumn("":"NoCache"; "":""; "Numberlist"; 1);
@If(@IsError(temp); 1; @Subset(temp; 1) + 1)

Regards,

Scott
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now