This script adds sequential values based on the last value. My problem is I have to have at least one value already in place for First() to work, else it errors out.
Also when I try to add a Count() I get Array type expected error.
How do you properly code for: AKA how do you check for empty table and if empty give it a value?
if count == 0 {return something}
else do this
else do that
This code below works great as long as there one record in the table with an assignednum. If not it errors on line 3. I tried to code with IIf & IsNaN/IsEmpty with no avail. (Attribute Calculation Rule on Insert)
Thanks.
Xander Bakker
var sql = Concatenate("assignednum like", "'%", Year(Now()), "%'")
var fs = first(OrderBy(Filter(FeatureSetbyName($datastore, table), sql), 'assignednum DESC'))
var lastnum = Number(mid(fs.assignednum,11,4),'0000' )
var int = ++lastnum
if (number(mid(fs.assignednum,6,4)) == Year(Now())) {
return Concatenate("SUDOE ",Year(Now()),"-",text(int,'0000'),"RCI")
}
else if (number(mid(fs.assignednum,6,4)) != Year(Now())) {
return Concatenate("SUDOE ",Year(Now()),"-0001","RCI")
}
