Input validation

Hi,
there is a problem with my app whenever there is duplicate value the app doesn’t say anything and it saves it so the question is how can I make the data entry to check if for example ID is currently in the spreadsheet and display an error and don’t save the record.

0 7 1,018
7 REPLIES 7

It should do that automatically if you have the latest data in your device when you create a new record so you should not be able to save that record. Is it possible that you don’t have the latest data?

i have the latest data but there is no duplication check while entering the data it should show an error i think saying that its duplicated cant be saved. is there like any valid_if code or something im new here so sorry.


https://help.appsheet.com/en/

So… are you talking about the key column or just what ever column?

just whatever column , not key column

and also if we could store the photos taken into a local storage such a the device itself .
please help me out with this if there is a such way

@bashiryousufy On the bottom of that article Steve mentioned you can find a formula that is checking duplicates in a column.

Top Labels in this Space