Relatively new to FM, but here's quick question:
Is there a way to calculate the maximum length of all data for a particular field? For example, I have many layouts that contain concatenated fields for text (usually an address), and it feels like the width of the field is much too large for the data within in.
I could always export all my data to Excel, use the LEN function and go about it that way, it feels like there should be a simpler solution.
Any ideas would be very appreciated.