Thanks. Had not thought of using a case formula:
New LeadQualified LeadRe-InstatedRough Cut CompletedComps & ValuationBiddingContractExchangedCompletedTrackingLostDroppedSite Allocation
The last 4 which are in bold italics you can ignore.
I am struggling with this. I have created a new field that contains the Case formula. When I report against this it appears to work properly. However when I try to incorporate this in the Formula URL for the button, the record does not update:
var text url=
URLRoot()& "db/" &Dbid()& "?a=API_EditRecord" &
"&rid=" & [Record ID#]&
"&_fid_9=" & URLEncode([What is the next Stage]) &
"&_fid_351=" & URLEncode([What is the next Stage]) ;
OK. So the when I use my code, the screen refreshes, but the record is not updated.
When I use your code, it progresses to the HTML above and when I return to the record manually it has been updated.
So I am guessing the code I have to return me to the record is cause it to fail?