Hi,
I have an application where I input invoices received that are tied to a specific number. The number is unique across the invoices and used for the primary key on the table. Is it possible to validate the field that contains that number when entering it as a new record? What I mean is if I receive a duplicate invoice or am not sure if I entered it yet, can Xataface pop up a warning on the add new item form when I type an invoice number that already exists in the database into the field prior to me hitting save? It looks like field name__validate only works after hitting submit (I don't want to fill out the entire form just to find the record already exists)
Thanks!