Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Changing type fonts of existing data within a field


EdY
 Share

Recommended Posts

Is it possible to change the type font or type size in fields with existing data? Example: I have 30,000 files with data that is imported from various other FileMaker databases, with multiple type fonts and sizes. I want all data in the specific field to be in the same font and size. Is there a way to standardize the font of all the existing data within a field?

Link to comment
Share on other sites

In a script

 

Set Field [YourTable :: YourField] [

TextFont( TextSize( YourTable :: YourField ;12) ; YourTable :: YourField;"Tahoma")

 

In this case it will change size to 12 and Font to Tahoma

Link to comment
Share on other sites

chopper, thanks for the script formula. Can you please give me more details on ho to implement it? Is it done in "Define Fields"? If so, what type of field do I choose, Container? Calculation? Summary?

Link to comment
Share on other sites

Can someone explain how to implement this script? Thank you.

Set Field [YourTable :: YourField] [

TextFont( TextSize( YourTable :: YourField ;12) ; YourTable :: YourField;"Tahoma")

 

In this case it will change size to 12 and Font to Tahoma

Link to comment
Share on other sites

*Open ScriptMaker

*Create a New Script

*Name it with meaning (What it does)

*On left choose Set Field Command

*Choose the field you want to set

*enter the Set Field [YourTable :: YourField] [

TextFont( TextSize( YourTable :: YourField ;12) ; YourTable :: YourField;"Tahoma")

//change YourTable :: YourField to the field you choose in the set field

// change the font size to your size choice

// Change the font to your font choice. Must be inside quotes

*close script

 

*Run script

 

When happy with result

you will need to add a set field for each field you want to change.

 

Then when you are really happy with how the script works on one record, Back up you DB

 

Add to script before setfield commands

 

Show All

Go To Record [First]

Loop

//set field here

...

...

...

...

//After set fields add

Go To Record [Next] [Exit After Last]

End Loop

 

After this any other new imports , you will need to remove or disable the Show All command

since when you run an import you should have only those imported in you current found set.

Link to comment
Share on other sites

chopper, thanks for the additional help. Sorry to say I'm still confused. I've gone this far:

*Open ScriptMaker

*Create a New Script

*Name it with meaning (What it does)

*On left choose Set Field Command

*Choose the field you want to set

Then you said:

*enter the Set Field [YourTable :: YourField] [

TextFont( TextSize( YourTable :: YourField ;12) ; YourTable :: YourField;"Tahoma")

 

How do I enter the Set Field? Do I choose the Specify button which then opens the Specify Calculation window and enter the data you provided: [YourTable :: YourField] [

TextFont( TextSize( YourTable :: YourField ;12) ; YourTable :: YourField;"Tahoma")?

 

Thanks.

Link to comment
Share on other sites

... sorry I thought you were an Intermediate... as your profile states

 

Yes select the set field command by double clicking it.

Choose specify target field field ... choose your field you want to set.

Select the specify button for calculated result. enter the code there

Link to comment
Share on other sites

  • 8 months later...
This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share



×
×
  • Create New...

Important Information

Terms of Use