Display field text in one field as something else in another field.
Hello, I am in need of a bit of help.
I have two layouts. One is for data collection and the other is for printing the collected data. In the data collection layout, I have a field with radio buttons for "Checked" and "Comments". I'd like to display these values in the print layout as either "✓" or "C".
I am guessing I will have to create a different field for the print view with a calculation that basically says:
If FieldData = "Checked" then Set Field FieldPrint = "✓"
If FieldData = "Comments" then Set Field FieldPrint = "C"
But I don't know how to write this calculation. I'd appreciate some help.
Thanks in advanced.