Highlighted Text in field upon new record creation
I'm using FMP (10 & 11) to manage my client database for my band. Each client will have a record of every performance we do. Often, there will be repeat performances, so I simply duplicate the previous record, remove all of unncessary information, and then continue to modify the new record until the gig is fulfilled... at which point, I will repeat the process and make a new record.
I've recently decided that using scripts can speed up the process and erase specified fields after I've created the new record. I'd like to take it one step further and create a button or script that will create the new record and erase the old data automatically.
Here's the thing... because I have six other people working on the same database, I'd like to have a visual way of indicating which information is carried over from the old record by means of a highlighted box or coloured text. An example of this would be carrying over the amount charged from the previous gig. Then, once there is an interaction with that particular field, then the highlight/decorated text will revert back to normal (indicating that the information is now current and not carried over from the previous record).
Does this make sense? Sorry... it's hard to explain without going into excessive detail.