Discussions

Expand all | Collapse all

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

QuickBaseCoach Dev./Training11-30-2017 16:59

QuickBaseCoach Dev./Training11-30-2017 17:06

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

     
    Posted 03-10-2015 20:23

    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?



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

    Posted 03-10-2015 20:35
    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.


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

    Bronze
    Contributor
    Posted 11-30-2017 16:56
    I just did this, and it's showing the log behavior.


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

    Posted 11-30-2017 16:59
    Can you explain further what the problem is?


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

    Bronze
    Contributor
    Posted 11-30-2017 17:05
    I just realized that you have to use the 'Trim' formula. However, is there any way to display the truncated information without the dashes?


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

    Posted 11-30-2017 17:06
    Sorry, I'm not understanding the question.


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

    Bronze
    Contributor
    Posted 11-30-2017 17:10
    When you 'Trim' a note to display the most recent entry, it displays a series of dashes above the message (as pictured above the word 'lot' in the image I sent). Is there anything that can be added to the this to remove the dashes? Trim(Right([Department Log],"]"))


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

    Posted 11-30-2017 19:44
    Can you post the text of a typical logging field, not just a screen shot.  I can't work with just a tiny snippet of the whole picture.


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

    Bronze
    Contributor
    Posted 11-30-2017 20:04
    I have a multiple choice drop-down for departments, but I don't want the log history to display in my report. So I created a formula field to mirror the current department selected. To do that, I had to use the formula I described above. Departments include: Office, Lot, Arbitration, Transportation, Online
    I'm able to accomplish what I need functionally, but aesthetically, the dashed lines are just a visual annoyance.  Does that give you a better understanding of what I'm trying to accomplish? Thanks, in advance, for your help.


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

    Posted 11-30-2017 20:26
    Sorry, but I cannot see you screen from here :)


    Really this is a brand new question that you have tacked onto an old thread.

    I'm happy to try to help but I suggest that you post a new question, and include an example of the actual the actual text that you want the TRIM type formula to deal with.

    Please post a clear question and I will answer it.


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

    Bronze
    Contributor
    Posted 11-30-2017 20:59
    I guess I don't understand what isn't clear. The image shows the dashed lines that are caused by the 'log edits' feature. When you use the Trim formula, it truncates the message, but keeps the dashed lines. No big deal. I can live with it. Thanks for reaching out.


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

    Posted 11-30-2017 21:17
    You asked for help with a formula that you posted. I understand exactly what that formula does. The formula includes a ] type bracket.

    But you seem unwilling to post more than 1 tiny piece of the screen shot of a full example of your text.  I assume, for example that your actual app does have an ] in that field.  Your screen shot does not, so I assume that the screen shot was just a small piece of the whole picture of the actual text in that field.


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

    Bronze
    Contributor
    Posted 11-30-2017 21:25
    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:
    -----------


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

    Posted 11-30-2017 21:30
    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],"-")

     


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

    Bronze
    Contributor
    Posted 11-30-2017 21:47
    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 :)


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

    Posted 11-30-2017 21:49
    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.


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

    Bronze
    Contributor
    Posted 11-30-2017 21:53
    Oh, I should've specified that it was for a form going to non-registered users. 'Everyone on the Internet'