I have a large field that logs previous entries. I want to show everything that is in that field

  • 1
  • 2
  • Question
  • Updated 2 years ago
  • Answered

I have a field called "Details". When a user types info into Details, the form appends that entry into a field called "Log". The problem is that Log gets very long. When Log reaches the preset number of lines, QuickBase truncates it and creates a link that says "Show All Entries".

How can I make quickbase show all entries on the same form?

Photo of EJ

EJ

  • 10 Points

Posted 4 years ago

  • 1
  • 2
Interesting question. I don't recall anyone ever asking that before.

You can make a new field called [Log field all entries]. It will be a formula text field with the formula of just


[my log field]

ie it will be be a mirror field, but since it's just a plain vanilla text field it will just show the text without any of that log behavior. You would set the Form properties to only show in edit mode.
Photo of Kelly

Kelly

  • 1,812 Points 1k badge 2x thumb
I just did this, and it's showing the log behavior.
Can you explain further what the problem is?
(Edited)
Photo of Kelly

Kelly

  • 1,812 Points 1k badge 2x thumb
I just realized that you have to use the 'Trim' formula. However, is there any way to display the truncated information without the dashes?
Sorry, I'm not understanding the question.
Photo of Kelly

Kelly

  • 1,812 Points 1k badge 2x thumb
I'm not unwilling. That's really the whole story. I don't know why the bracket is in there. It's code that I've copied. The actual text in the field, like I said, comes from a drop-down that lists departments.

Office
Online
Transportation
Lot

But because lot was the most recent selection, I get:

-----------
Lot

Just wanted to know how to get rid of the:
-----------
Do you need the dashed lines to show even in the log field?  If not, you can turn that off in the field properties.  So you are saying that the field is not logging who did the change or when?

The formula would be

Right([My text field with logging enabled],"-")

 
Photo of Kelly

Kelly

  • 1,812 Points 1k badge 2x thumb
I didn't see that in the field properties, but I do like it for the logs, and your solution worked perfectly! Thank you so much. It's a visual relief :)
OK sorry for putting you though the ringer on this, but I never heard of anyone logging changes but not logging the who changed it and when changed, so that threw me.
Photo of Kelly

Kelly

  • 1,812 Points 1k badge 2x thumb
Oh, I should've specified that it was for a form going to non-registered users. 'Everyone on the Internet'