Can I make the grid only display part of the inputted field?

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered
Sorry, I'm new to quickbase and I'm still getting a hang of the more basic functions. I was wondering if there was a way to limit the amount of words that are displayed on the report grid for multi-line and URL fields. Some URL's can be quite lengthy and they take up a lot of space on the grid. Rather than the report displaying the entire length of the URL, is there a way to have it only display part of it? For example, could I make the report display "file:\\C:\documents..." on the grid rather than "file:\\C:\documents\folders\newdocuments\reports\contacts\email\addresses\contacts within the US"? Same question for multi-line fields. There is one multi-line field where the user inputs notes for a job. They still need to be visible so that the user can easily see if there are notes, but I just don't want them to take up so much space on the grid. I have attached a picture of an example of a URL taking up too much space on the grid.

Thank you for your help.

Photo of Brandon

Brandon

  • 120 Points 100 badge 2x thumb

Posted 4 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb
For the file link, you might choose to hide the file path altogether by using the field property to give them a generic name in the "Link Text", which is a field property of the file attachment. For example "File Attachment".  The links would still be clickable, but they would all say the same thing, and there would be no link if there was no file attached.




If you could give up on the link text being clickable, you could make a new field  to be used in reports where space is tight and it could be a  formula text field of

Right([My File Attachment Field],"\\")

That would just give the file name without the file path prefix. But it would not be clickable.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb
Oh, and also if you wanted to only show the first 500 characters of a text field on a report you could make a new formula text field

Left([CATSA Issue / Request],500)
&
If(Length([CATSA Issue / Request])>500,"<font color=red>more.......")
Photo of Brandon

Brandon

  • 120 Points 100 badge 2x thumb
I'm sorry but I'm still fairly new at formulas as well. Do I copy those formulas in exactly? I wanted to try limiting it to 5 characters so I changed the 500 to 5 and I changed the "[CATSA Issue / Request]" to the field I'm working on which is "[notes]", but it doesn't seem to have changed anything.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb
You would need to post your formula so i can see it.  But what do you mean by limiting a descriptive text field to just 5 characters. Man, that is pretty frugal, so something does not sound right.   So this would be a new field and you would add it to your reports in place of the full field.

if this is a multi line field with carriage returns I think you should not try the red coding and just use.

Left([Notes],100)
&
If(Length([Notes])>100,"and more.......")
Photo of Brandon

Brandon

  • 120 Points 100 badge 2x thumb
Thank you! Once I removed the "<font color=red>" it worked exactly how I wanted it to. I was just using the 5 characters for testing purposes. I appreciate the help.