We need to regularly import csv’s and have this app update existing records and create new records. All records have a unique identifier field (“RefID”), however it’s a calculated field (concatenation of a text field and the record ID). This is where the csv import block wouldn’t work, and we’re hoping this is something that can be “coded around” rather than simply being impossible!
CSV’s to be imported will either have a “RefID” value matching an existing one or no value at all. If they match, then certain specific fields in the existing record should be updated with values from the csv (not fields that would impact the RefID value), and if there is no match a new record should be created.
Ideally this would work with short and long text, single select, numerical, and linked field types (linking to existing records in another table, or creating a new one).
Let us know if this sounds doable for you! Thanks