exact form: fields displaying incorrectly

  • 0
  • 2
  • Question
  • Updated 3 years ago
  • Answered
See photos for ref:

My exact form is not displaying the way it should according to my settings.

1) pcar # should not have a comma

  • setting show "simple number" with no separators
  • reports show correctly, exact form shows with comma

2) Initated by should be full name, not email address

  • settings show "full name"
  • reports show correctly with full name, exact form shows email address

Does anyone know how I can fix this?

Thank you in advance!


Photo of mkosek

mkosek

  • 918 Points 500 badge 2x thumb

Posted 5 years ago

  • 0
  • 2
Photo of Patrick

Patrick

  • 20 Points
I had the same problem with the user name. I made a formula text field and pointed it at my user field:

UserToName([Initiated By], "FF")




I haven't tried it with the number, but my suspicion is that you could create a formula text field that would work:

ToText([P/CAR#])

The form shouldn't add commas if it thinks it's text.
Photo of Thierry

Thierry

  • 0 Points
I also created a formula text field that I then used in my ExactForm.
The exact form needed to show two number, the 1st one (a formula numeric) did not show commas, the 2nd one did and was a filed created by a relationship to aonther table.
My formula text field looks like:
"Install #"&[Install Number]&", Ship #"&[Shipment Number]
And now the commas have disappeared from the "Shipment number"
Photo of Carlos

Carlos

  • 0 Points
In this formula, the one posted by Patrick, what is the meaning/purpose of "FF"? Can anyone tell me, please?

UserToName([Initiated By], "FF")
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 69,572 Points 50k badge 2x thumb
https://login.quickbase.com/db/6ewwzuuj?a=dr&rid=155&rl=cic

It means First name first as opposed to LF which is Last name First.  John Smith    vs   Smith, John
Photo of Carlos

Carlos

  • 0 Points
Thank you, I realized it 1 minute after posting. Much appreciated.