Forum Discussion

NicolaNicola's avatar
NicolaNicola
Qrew Member
7 years ago

How can I log changes to a field in a separate ""field

I have a status field as a dropdown. I need to display the latest project status only in reporting. However, I also need to know when the previous status was changed "from what to what" and by whom, b...
Formulas and functions
reports and charts
Tables and fields
KingslySamuel's avatar
KingslySamuel
Qrew Cadet
7 years ago
You can create a duplicate field of the existing status field and make that a log field and put the condition in the form to update it based on the update done to your existing status field. And, make that field appear only to you as admin, so that other cannot see it
  • NicolaNicola's avatar
    NicolaNicola
    Qrew Member
    7 years ago
    You make it sound easy. But I have only used conditions before in a formula, and not multiple-choice fields :-(