Forum Discussion
GauravSharma3
8 years agoQrew Commander
Hi Sandeep,
Do you want to resize all columns or just one or two columns? if yes then, you can create a formula field to truncate the data for that particular column.
Tell me how you would like to proceed?
Thanks,
Gaurav
Do you want to resize all columns or just one or two columns? if yes then, you can create a formula field to truncate the data for that particular column.
Tell me how you would like to proceed?
Thanks,
Gaurav
- GauravSharma38 years agoQrew CommanderSometimes it is because of your column heading. For that, you can easily customize the column heading.
- sandeepsandeep8 years agoQrew Assistant CaptainThanks for ur quick response
We need to truncate two columns.
Thanks - GauravSharma38 years agoQrew CommanderIf it is a text field then, create a formula-text field and use the below formula.
Left([Your Text Field], 60)
Now, show this field in the report instead of using the original one.
Thanks,
Gaurav - sandeepsandeep8 years agoQrew Assistant CaptainIt is a Multi- line text and we have taken a new text formula and applied the formula
Left([multiline feild], 60)
But its not working .
Thanks - GauravSharma38 years agoQrew CommanderHi Sandeep,
I am able to do that. Can you please post some more information like before trim and after the trim. How you want to truncate the field.
Thanks,
Gaurav - abhireddy8 years agoQrew TraineeHello Gaurav,
I do have similar kind of issue, I need a column to shrink to certain width because of user visibility, Can you please help me on this?
I have changed column type (Text Multi line -> formula Rich text) But when am trying to shrink using formula that am not able figure it out.
My question is, As you mentioned in previous solution to use this "Left([Your Text Field], 60)" how do i integrate to this particular column.
Thank you,
Abhi. - GauravSharma38 years agoQrew CommanderHi Abhi,
Welcome to the Quick Base Community.
You don't have to change your existing field. You need to create a new formula text field and use the above-mentioned formula and use that formula field in place of your multi-line field on the report.
Thanks,
Gaurav - abhireddy8 years agoQrew TraineeGaurav,
You don't have to change your existing field. You need to create a new formula text field and use the above-mentioned formula and use that formula field in place of your multi-line field on the report. <quesiton> Is this new formula text field is a column or needed to be added to the existing field?
Thanks
Abhi - GauravSharma38 years agoQrew CommanderHi Abhi,
It is a new formula field which you will add as a column.
Thanks,
Gaurav