You’re offline. This is a read only version of the page.
40
hello Everybody ,
I want to autoincrement my code in my from once I submit it ,
i want that once i submit my form the next value for my hierarchies code =5 , I've used 2 functions but it not working , i have the same hierarchies code=4 in 2 records (which is wrong)
in my datacardvalue10 : If(EditForm3.Mode = FormMode.New;Last(MDM_Hierarchie).HierarchieCode + 1;
ThisItem.HierarchieCode)
button submit : Refresh(MDM_Hierarchie);;NewForm(EditForm3);; SubmitForm(EditForm3);; Navigate(BrowseHierarchyLvl)
any help?
Try...
Share
Report
All responses (
Answers (
Max(
MDM_Hierarchie,
HierarchieCode
)+1
Or
First(
SortByColumns(
MDM_Hierarchie,
"HierarchieCode",
Descending
)
).HierarchieCode+1
