+ Start a Discussion

Bids/Customising setup

I am trying to modify our current set up.  I want to put in four new fields (names first then type) -
Bid completed - Checkbox
Bid number - Autoformat
Raised date - Date
Bid location - text
What I want is that these values are inaccessible until bid completed is checked.  Then these are available.  This cannot be done by field dependencies as they are not picklist values.
To complicate it further I also need to have Bid number as an autoformat value.  Once bid completed is checked it assigns a value that increments from the last highest value (i.e. SSS0000001 is the previous bid number so it will assign the new value SSS0000002).
Is this possible, and how???