entries appearing in red text - not "orphaned" values

  • 0
  • 1
  • Question
  • Updated 5 years ago
  • Answered
I am having an issue with my multiple choice form. We will be using it as a checklist to log if/when/who signed off on a steps to complete a setup.

I have multiple steps with only two options from the multi choice pulldown. Default value is blank, and Complete is the only option.

When I save my form, all entries are in red text. I am not using an orphan value since I am choosing "complete" from my pulldown. When I had the form setup using radio buttons, my entries did not show up red after saving. I am not allowed to use the radio buttons because of the very annoying, impossible to get rid of, "None of the Above" option that automatically comes up. I wanted to just use checkboxes however I was unable to find a way to easily show history for each checkbox.


Photo of mkosek

mkosek

  • 928 Points 500 badge 2x thumb

Posted 5 years ago

  • 0
  • 1
Because you are "Logging changes", technically what is logged with the date and user name and [ ] is an invalid choice.

I suggest that you create a new field for reports which is the most recent update and show that field on reports.

The formula to parse out the most recent update (assuming that the new updates are being logged at the bottom of the logging) is



Trim(Right([my update field with logging],"]"))

That should grab off the right most characters up to the first ] character and then trim off a leading space.
Photo of mkosek

mkosek

  • 928 Points 500 badge 2x thumb
I really don't want the date/time stamp and user on the report. I just want it to say "complete" under the fields. If we need to check to see who signed off on that step and when, we can open the form and see it that way. The report is just a quick snapshot of whether or not the setup sheet has been completed.

Where would I put that formula which removes the logging info and just keeps the "Complete" entry? My Text-multi choice field does not have a place for a formula.

Thanks
Keep your current field which logs changes.

Make a new field of Type formula-text and put it on your report instead of the "red" one.