https://community.esri.com/t5/arcgis-online-questions/arcade-smart-form-calculation-no-longer-working/m-p/1248122#M49774 <P>Hello,&nbsp;</P><P>I have an Arcade script that was used to auto-sequence the case number for a site and reset to 1 every year. This was working in a smart form less than a year ago. But now I get an error that my arguments for my Filter function have an invalid parameter. I tried adjusting the script to put my sql filter into its own variable then refer to it in the Filter function, but then I get an error message saying "parameter isn't a function". The code that was working before is below.&nbsp;</P><P>Was there an update in Arcade that affected the Filter function?&nbsp;</P><LI-CODE lang="python">//returns the current year var timestam = Today() var currentyear = Year(timestam) //increment by 1 from highest number for only features within current year var setfeatures = FeatureSetByName($map,"layer name",['CaseNumber','CaseYear'],false) var numberlist = Filter(setfeatures, 'CaseYear=@currentyear') var topnum = Top(OrderBy(numberlist,'CaseNumber DESC'),1) var counter = Number(Max(topnum,'CaseNumber')) var siteid = counter+1 return siteid</LI-CODE><P>&nbsp;&nbsp;</P> Fri, 13 Jan 2023 17:09:45 GMT Caitlin_Todd_LCOR 2023-01-13T17:09:45Z https://community.esri.com/t5/arcgis-online-questions/arcade-smart-form-calculation-no-longer-working/m-p/1248122#M49774 <P>Hello,&nbsp;</P><P>I have an Arcade script that was used to auto-sequence the case number for a site and reset to 1 every year. This was working in a smart form less than a year ago. But now I get an error that my arguments for my Filter function have an invalid parameter. I tried adjusting the script to put my sql filter into its own variable then refer to it in the Filter function, but then I get an error message saying "parameter isn't a function". The code that was working before is below.&nbsp;</P><P>Was there an update in Arcade that affected the Filter function?&nbsp;</P><LI-CODE lang="python">//returns the current year var timestam = Today() var currentyear = Year(timestam) //increment by 1 from highest number for only features within current year var setfeatures = FeatureSetByName($map,"layer name",['CaseNumber','CaseYear'],false) var numberlist = Filter(setfeatures, 'CaseYear=@currentyear') var topnum = Top(OrderBy(numberlist,'CaseNumber DESC'),1) var counter = Number(Max(topnum,'CaseNumber')) var siteid = counter+1 return siteid</LI-CODE><P>&nbsp;&nbsp;</P> Fri, 13 Jan 2023 17:09:45 GMT https://community.esri.com/t5/arcgis-online-questions/arcade-smart-form-calculation-no-longer-working/m-p/1248122#M49774 Caitlin_Todd_LCOR 2023-01-13T17:09:45Z