Replace Field Contents
I'm trying to help a friend with a problem.
She created a shipping database and did it completely wrong. So we're trying to fix the problem.
She has built 5 different fields for shipping when she really only needs one.
Currently she has a field for shipping, best way prepaid, best way collect, bestway frieght, best was other shipper, fedex and ups. These are all checkbox fields by the way.
On each record, only one of these checkboxes are marked.
We've made a new field called carrier. Is there any way for a script or something to mark the new field carrier as whichever one of the checkbox fields has a value?