In Appsheet for bulk upload from csv file... how we can allow only upload new entry and block existing file to avoid duplicate ? I tried using valid if expression. From the row i don't want to copy if business name is already available.
NOT(IN([_THIS], SELECT(VENDORS[BUSINESS NAME], [VENDOR_ID] <> [_ThisRow].[VENDOR_ID])))
But get stuck if duplicate entry available in csv file. Please advise.
LinkedIn
Twitter
