There seems to be a bug in the function:
Select([Gallery],[RecordNum]) --> Select(Gallery_Quotes,1)
I have used this function to select the First record of a Gallery's collection, BUT even when the Gallery is populated, my Users see the error message:
"row or column passed to the Select function is outside the bounds of the gallery items" - which is clearly not true.
I suspect that this is another consequence of the extremely flawed "Formula level error reporting" feature that has been full of bugs and spurious/erroneous error messages since it was introduced.
I have also noticed that this feature is now out of Experimentation, and in Preview status, which is very worrying, as there are clearly still some issues.
I believe the error is being thrown before the gallery has actually populated, so the Select formula thinks that there are zero records in the Gallery.
Please can you fix this faulty error reporting.
And in the meantime, can somebody point me towards the correct formula to use in the App.OnError function to suppress this spurious error message from hitting the Users?
Thanks
James.