I have a file containing 70,000 records - product names, pack sizes and pack costs, which is updated outside of zoho creator weekly. I have imported the first file into zoho creator which is used in a form with a dropdown field "Product name". Once the product is chosen it fetches the corresponding "pack size" and " pack cost" in the non editable fields.
I would like to import a fresh price list file into my Creator app each week which overrides the existing file without affecting existing records. For example, when I have tried a new import, if a product has been discontinued and has been used in a previous record then the records product name will be deleted. Any thoughts would be greatly appreciated