I am trying to get the last id for the specified location with the lookup function in the new responsive Forms. I have tried the formula= max(lookup("MyList", "Location", form.location, "ID")). It says that max requires a number parameter, but even if I put convert to number before the lookup function, it does not return anything. I need to that to generate a number for every location.
Thanks you in advance!