Newbie, recently imported an excel file and all of the formatting is off.
Looking at the table, I need to select everything in a field (column). How do you do this?
I tried selecting the top entry and the bottom entry but that didn't work.
see if these help
Using the inspector to format objects | FileMaker
Overview of font handling changes introduced in FileMaker Pro 14 | FileMaker
Specifying text formats for fields
p.s the last link has several other links that might be followed.
Thank you for your post.
The "Columns" in FileMaker Pro won't respond as they do in Excel, because they are now individual Fields with multiple Records (your rows). There isn't a way to simply select all Records (rows) at once in FileMaker Pro. If you haven't already, I would recommend checking out the Training Series Basics.
Find/Replace allows you to edit the data an entire "column" field.
However, if you need to do data cleaning, a looping script (to go to each field in each record) may be preferable.
What do you need to do?
Perhaps it's just the styling that needs work? (Select the field in layout mode, open the inspector and fix - this applies to every record/row for that field/column).
It it's data cleaning use the Find/Replace (works on found set) or script a loop.
And if you may be importing in the future, it may be something you set as auto-enter directly in the field definition.
you can't select a column, but you can switch to layout mode and define a formatting for your field. (if the field is not there, add it first). Back in column mode, the whole column will be formatted. What kind of formatting are you after ?
Notice that there are formattings that affect only the way the field looks and then there are permanent tattoos, achieved by using TextFormatting calcs.
What do you need to do?
Simple formatting like text centering and text style.
THANK YOU so much Beverly! I really appreciate all the help
"Simple formatting like text centering and text style."
Note that in general, you want to strip all formatting from the "raw" contents of a field; and then use the layout styling methods described by Beverly.
Otherwise, it may be possible that on the layout level, content is centered, but a user (or a paste operation) can apply other formatting to a particular record. In fairly rare cases, you want the user to be able style individual field contents on a record by record basis.
For most fields, it's a good idea to set up an auto-enter calc (AEC) using something like this, or variations on this, as noted in other discussions here:
trim( textFormatRemove( self ))
Thank you Bruce!
Retrieving data ...