AnsweredAssumed Answered

How to set a field value based on specific text in another field

Question asked by johnfleet on Mar 5, 2018
Latest reply on Mar 9, 2018 by erolst

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)Screen Shot 2018-03-05 at 12.28.48 pm.jpg

 

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?

Outcomes