I have a simple database recording investments with a P2P company. There is one record for each investment (loan), although there may be multiple investments made at different dates in the same loan. Occasionally a loan defaults, so I want to flag the status of each loan as either 'Live' or 'Defaulted' Simple enough to create a field to do that but my issue is that when I update records via importing the latest Excel s/s dump from the web of my investments, the status field seems to get out of sync and records are wrongly flagged as Default or Live. (I'm using these settings for import)
Assuming that these are the correct import options then I need to identify those records dynamically which are in default. Helpfully the Asset details field contains the text 'default' so my idea is to either use a calculation field to set the value of loan Status field to either 'Live' or 'Defaulted' or perhaps a simple script?